DataSocial
Query a TikTok data warehouse (creators, videos, sounds, daily history) with read-only SQL.
使うべきか
品質と安全性
ツール定義とプロトコルへの準拠に関する自動分析に基づいています。
コンテキストコスト
これは、サーバーのツールがモデルのコンテキストに読み込まれるたびに消費されるおおよそのトークン数です。数が多いほど、ほかのタスクに使える注意が減ります。
インストール
ワンクリックインストール
これを `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
}コミュニティ
エビデンス