DataSocial
Query a TikTok data warehouse (creators, videos, sounds, daily history) with read-only SQL.
Sollte ich dies verwenden
Qualität und Sicherheit
Basierend auf einer automatisierten Analyse der Tool-Definitionen und der Einhaltung des Protokolls.
Kontextkosten
Dies ist die ungefähre Anzahl der Tokens, die jedes Mal verbraucht werden, wenn die Tools des Servers in den Kontext eines Modells geladen werden. Höhere Werte verringern die Aufmerksamkeit, die für andere Aufgaben verfügbar ist.
Installieren
Installation mit einem Klick
Fügen Sie dies Ihrer Datei `claude_desktop_config.json` hinzu:
{
"mcpServers": {
"datasocial-mcp": {
"url": "https://api.datasocial.ai/mcp"
}
}
}Remote-Endpunkte
https://api.datasocial.ai/mcpstreamable-httpWas es kann
Tool-Inventar
Tools (4)
🟢list_tables
The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.
Eingabe-Schema
{
"type": "object",
"properties": {},
"$schema": "http://json-schema.org/draft-07/schema#"
}Ausgabe-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.
Eingabe-Schema
{
"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#"
}Ausgabe-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.
Eingabe-Schema
{
"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#"
}Ausgabe-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.
Eingabe-Schema
{
"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#"
}Ausgabe-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
}Community
Nachweis