Query a TikTok data warehouse (creators, videos, sounds, daily history) with read-only SQL.
Maintain this server? Claim it
Call this server's tools from your browser. Nothing to install.
Bearer <your key>; free key at datasocial.ai/keys (sign in)
Requests go through mcptry because browsers can't call most MCP servers directly. Header values are sent to the server for that request only and are never stored or logged.
Tool list from our last check. Connect live to refresh it.
One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.
The table, e.g. "creators" or "tiktok.creators"
One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.
| Argument | Type | Description |
|---|---|---|
| table* | string | The table, e.g. "creators" or "tiktok.creators" |
{
"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\""
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| table | string | Only examples on this table, e.g. "sound_history"; omit for all |
{
"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"
}
}
}The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.
No arguments.
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {}
}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.
| Argument | Type | Description |
|---|---|---|
| sql* | string | One ClickHouse SELECT, e.g. SELECT username, followers FROM tiktok.creators WHERE country = 'US' ORDER BY followers DESC LIMIT 10 |
{
"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"
}
}
}