list_tables
List tables
The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.
無需輸入參數。

io.github.hashfunction-dev由 GitHub 帳號 hashfunction-dev 發布v1.0.0更新於 Nov 10, 2026
Query a TikTok data warehouse (creators, videos, sounds, daily history) with read-only SQL.
託管型 MCP 伺服器,讓助理對包含創作者、影片、音訊與追蹤關係的 TikTok 資料倉儲撰寫並執行唯讀 SQL。
Web executable,透過 Streamable HTTP。 遠端服務在工作區中設定後即可從網頁執行環境執行。
把這段提示詞貼上到 Claude Code、Codex、Cursor 等代理程式,或 SourceWeft 對話中。代理程式會讀取該伺服器的安裝指南,先向你展示發布者、端點和登入方式,經你同意後再把它新增到你的客戶端。金鑰不會寫進任何命令。
閱讀 https://sourceweft.com/mcp/io.github.hashfunction-dev%2Fdatasocial-mcp/install.md,並按其中說明把這個 MCP 伺服器接入我的客戶端。修改任何設定之前,先告訴我它的發布者、端點和登入方式,等我確認。不要把 API 金鑰寫進命令或我會提交的檔案;問我金鑰應從哪裡取得。把它新增到你客戶端的 mcpServers 設定中。
{
"mcpServers": {
"datasocial": {
"type": "http",
"url": "https://api.datasocial.ai/mcp",
"headers": {
"Authorization": "Bearer <YOUR_TOKEN>"
}
}
}
}A hosted MCP server over a ClickHouse warehouse of TikTok data: 4.1B creators, 5.5B videos, 604M sounds and 113.7B follow edges (124.6B rows). Ask your AI assistant a question; it writes the SQL and runs it. Free.
https://api.datasocial.ai/mcp (Streamable HTTP, stateless)Claude Code
Cursor (~/.cursor/mcp.json)
Claude Desktop (claude_desktop_config.json, via mcp-remote)
Daily creator and video history started on 2026-09-26; sound history has 106 days since January 2026.
This repo holds documentation only; the server is hosted.
來源:README.md,提交 b41d084
List tables
The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.
無需輸入參數。
Describe a table
One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.
table必填Examples and SQL tips
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.
tableRun 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.
sql必填已滿足適用檢查項的 90%
該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。
請在儲存庫或註冊中心條目中宣告授權條款。
claude mcp add --transport http datasocial https://api.datasocial.ai/mcp \ --header "Authorization: Bearer $DATASOCIAL_KEY"{ "mcpServers": { "datasocial": { "url": "https://api.datasocial.ai/mcp", "headers": { "Authorization": "Bearer YOUR_KEY" } } }}{ "mcpServers": { "datasocial": { "command": "npx", "args": ["-y", "mcp-remote", "https://api.datasocial.ai/mcp", "--header", "Authorization:${AUTH}"], "env": { "AUTH": "Bearer YOUR_KEY" } } }}