Query a TikTok data warehouse (creators, videos, sounds, daily history) with read-only SQL.
Scored across 4 tools
Each tool targets a clearly distinct step in the warehouse-query workflow: list tables, inspect one table's schema, get examples/tips, and run SQL. list_tables versus describe_table is a clear discovery-versus-detail split, and examples is documentation rather than execution. No two tools appear to do the same thing.
Three tools follow a predictable verb_noun pattern (list_tables, describe_table, run_sql), while examples is a noun-only name. The deviation is minor and still readable in context. Overall naming is mostly consistent.
Four tools is well-scoped for a read-only warehouse querying interface. Each tool earns its place: discovery, schema inspection, examples, and execution. There is no redundant tool bloating the surface.
The surface covers the full read-only query lifecycle: discovering tables, understanding schemas, learning conventions through examples, and executing SQL. Since the domain is explicitly read-only ClickHouse SELECT access, missing write operations are not gaps. Agents have no obvious dead ends.
One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.
Inputs: table (required). Returns: table, description
Worked examples (a question and SQL that runs here) and the SQL tips: growth maths, history-table patterns, big sound_history days. Pass a table to get only its examples.
Inputs: table. Returns: examples, sql_tips
The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.
Inputs: no named parameters. Returns: tables
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Public TikTok profiles, videos, comments and keyword search as JSON. No developer account.
TikTok search demand, videos, creators, comments and captions for AI agents. OAuth or API key.
TikTok research for AI agents. Ask ChatGPT, Claude, Cursor, Codex or any MCP client what people search, watch, say and buy on TikTok, and get real numbers back. 34 tools: weekly TikTok search volume and 7-day trends, content gaps, videos, creators, comments and caption transcripts, hashtags and sounds, TikTok Shop sales estimates for products, shops, creators, videos and LIVE streams, TikTok’s Top Ads library with CTR and retention, places, and a fair comment-giveaway picker. 17 markets. Built for marketers, agencies, TikTok Shop sellers and creators. Sign in with OAuth or an API key; 50 free credits, no card.
Real-time TikTok videos, profiles, comments, trends & Creative Center ads MCP. OAuth or API key.
Add one secure layer between your agents and this server.
