DataSocial
Query a TikTok data warehouse (creators, videos, sounds, daily history) with read-only SQL.
我该使用它吗
质量与安全性
基于对工具定义和协议合规性的自动分析。
上下文开销
这是每次将服务器的工具加载到模型上下文窗口时所消耗的大致 token 数。数值越高，可用于其他任务的注意力就越少。
安装
一键安装
将以下内容添加到你的 `claude_desktop_config.json` 文件中：
{
"mcpServers": {
"datasocial-mcp": {
"url": "https://api.datasocial.ai/mcp"
}
}
}远程端点
https://api.datasocial.ai/mcpstreamable-http它能做什么
工具清单
工具（4）
🟢list_tables
The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.
输入模式
{
"type": "object",
"properties": {},
"$schema": "http://json-schema.org/draft-07/schema#"
}输出模式
{
"type": "object",
"properties": {
"tables": {
"type": "array",
"items": {
"type": "object",
"properties": {
"table": {
"type": "string"
},
"rows": {
"type": "string"
},
"one_row_is": {
"type": [
"string",
"null"
]
},
"about": {
"type": [
"string",
"null"
]
}
},
"required": [
"table",
"rows",
"one_row_is",
"about"
],
"additionalProperties": false
}
}
},
"required": [
"tables"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}🟢describe_table(table)
One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.
输入模式
{
"type": "object",
"properties": {
"table": {
"type": "string",
"description": "The table, e.g. \"creators\" or \"tiktok.creators\""
}
},
"required": [
"table"
],
"$schema": "http://json-schema.org/draft-07/schema#"
}输出模式
{
"type": "object",
"properties": {
"table": {
"type": "string"
},
"description": {
"type": "string",
"description": "Size, grain, sort key, coverage and every column with its type and meaning"
}
},
"required": [
"table",
"description"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}🟢examples(table)
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.
输入模式
{
"type": "object",
"properties": {
"table": {
"description": "Only examples on this table, e.g. \"sound_history\"; omit for all",
"type": "string"
}
},
"$schema": "http://json-schema.org/draft-07/schema#"
}输出模式
{
"type": "object",
"properties": {
"examples": {
"type": "array",
"items": {
"type": "object",
"properties": {
"table": {
"type": "string"
},
"question": {
"type": "string"
},
"sql": {
"type": "string"
}
},
"required": [
"table",
"question",
"sql"
],
"additionalProperties": false
}
},
"sql_tips": {
"type": "string"
}
},
"required": [
"examples",
"sql_tips"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}🟢run_sql(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.
输入模式
{
"type": "object",
"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"
}
},
"required": [
"sql"
],
"$schema": "http://json-schema.org/draft-07/schema#"
}输出模式
{
"type": "object",
"properties": {
"columns": {
"type": "array",
"items": {
"type": "string"
}
},
"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"
},
"rows_read": {
"type": "number"
},
"elapsed_ms": {
"type": "number"
}
},
"required": [
"columns",
"rows",
"capped",
"rows_read",
"elapsed_ms"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}社区
证据