MCP Radar
Servidor MCP

DataSocial

io.github.hashfunction-dev/datasocial-mcp
Datos y analítica Redes sociales Público y accesible MCP 2025-11-25

Qué hace este MCP

Runs read-only SQL queries against TikTok creator, video, sound, and historical performance data.

Capacidades

Herramientas

4 herramientas
describe_table
Describe a table
One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.
Solo lectura
Esquema de entrada 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['table'], 'properties': {'table': {'type': 'string', 'description': 'The table, e.g. "creators" or "tiktok.creators"'}}}
Esquema de salida 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['table', 'description'], 'properties': {'table': {'type': 'string'}, 'description': {'type': 'string', 'description': 'Size, grain, sort key, coverage and every column with its type and meaning'}}, 'additionalProperties': False}
examples
Examples and SQL tips
Worked examples (a question and SQL that runs here) and the SQL tips: growth maths, history-table patterns, big sound_history days, follows lookups. Pass a table to get only its examples.
Solo lectura
Esquema de entrada 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'table': {'type': 'string', 'description': 'Only examples on this table, e.g. "sound_history"; omit for all'}}}
Esquema de salida 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['examples', 'sql_tips'], 'properties': {'examples': {'type': 'array', 'items': {'type': 'object', 'required': ['table', 'question', 'sql'], 'properties': {'sql': {'type': 'string'}, 'table': {'type': 'string'}, 'question': {'type': 'string'}}, 'additionalProperties': False}}, 'sql_tips': {'type': 'string'}}, 'additionalProperties': False}
list_tables
List tables
The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.
Solo lectura
Esquema de entrada 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
Esquema de salida 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['tables'], 'properties': {'tables': {'type': 'array', 'items': {'type': 'object', 'required': ['table', 'rows', 'one_row_is', 'about'], 'properties': {'rows': {'type': 'string'}, 'about': {'type': ['string', 'null']}, 'table': {'type': 'string'}, 'one_row_is': {'type': ['string', 'null']}}, 'additionalProperties': False}}}, 'additionalProperties': False}
run_sql
Run SQL
Run one read-only ClickHouse SELECT on tiktok.* and get the rows back (at most 100 per request; 10 s per query). Name the columns you need and add a LIMIT.
Solo lectura
Esquema de entrada 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['sql'], 'properties': {'sql': {'type': 'string', 'maxLength': 100000, 'description': "One ClickHouse SELECT, e.g. SELECT username, followers FROM tiktok.creators WHERE country = 'US' ORDER BY followers DESC LIMIT 10"}}}
Esquema de salida 
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['columns', 'rows', 'capped', 'rows_read', 'elapsed_ms'], 'properties': {'rows': {'type': 'array', 'items': {'type': 'array', 'items': {}}, 'description': 'One array per row, values in the order of columns'}, 'capped': {'type': 'boolean', 'description': 'true when the result was cut at the 100-row limit'}, 'columns': {'type': 'array', 'items': {'type': 'string'}}, 'rows_read': {'type': 'number'}, 'elapsed_ms': {'type': 'number'}}, 'additionalProperties': False}
Historial

Cambios recientes en herramientas

Añadido
run_sql
2 de October de 2026 a las 02:40
Añadido
examples
2 de October de 2026 a las 02:40
Añadido
describe_table
2 de October de 2026 a las 02:40
Añadido
list_tables
2 de October de 2026 a las 02:40
Descubrir

Servidores MCP similares

captapi

io.github.CDCStream/captapi

Retrieves social media profiles, posts, engagement metrics, comments, marketplace listings, events, and Meta advertising data acr…

Social Media Search API — Twitter, Instagram, Reddit, TikTok (XPOZ)

ai.xpoz/social-insights

Searches and analyzes posts, comments, users, trends, and tracked topics across Twitter/X, Instagram, Reddit, and TikTok.

Stocktwits

io.github.pipeworx-io/stocktwits

Provides public Stocktwits market data, including ticker chart history, OHLCV bars, and related stock-market context.

Social Signal

io.github.pipeworx-io/social-signal

Provides time-series analysis of post volumes across open social networks for monitoring social activity and signals.

Viral Outliers

com.viraloutliers/viral-outliers

Finds viral outlier posts across TikTok, Instagram, and YouTube, tracks creator profiles, analyzes media, monitors watchlists, an…

Reel25 — Video Analytics for TikTok, Instagram & YouTube

io.github.usnmax88/reel25-mcp

Tracks and analyzes TikTok, Instagram, and YouTube creator accounts and videos, including performance metrics, trends, discovery,…

telemost-mcp-server

io.telemost/telemost-mcp-server

Searches public Telegram content and channels, extracts entities, tracks posts and mentions, analyzes sentiment, and reports chan…

Youfiliate Smart Links

io.github.andrewmpierce/youfiliate-mcp

Creates geo-targeted affiliate smart links, manages redirects and deep links, provides click analytics, and migrates YouTube desc…