DataSocial

io.github.hashfunction-devPublished by GitHub account hashfunction-devv1.0.0Updated Nov 10, 2026

Query a TikTok data warehouse (creators, videos, sounds, daily history) with read-only SQL.

VerifiedStreamable HTTPWeb executableDatabasesWeb Search & ScrapingData & Analytics

Overview

AI-generated overview

Hosted MCP server that lets an assistant write and run read-only SQL against a TikTok data warehouse of creators, videos, sounds and follow edges.

What you can do
  • List warehouse tables with row counts and what one row represents
  • Describe a table's columns, types, sort key and coverage
  • Get worked question-and-SQL examples and SQL tips, optionally filtered to one table
  • Run one read-only ClickHouse SELECT on tiktok.* and get up to 100 rows back
When to use it
Useful when you want to answer questions about TikTok creators, videos, sounds or follow relationships without building your own dataset, for example ranking fast-growing creators or finding trending sounds. The assistant writes the SQL itself, so it suits exploratory analysis rather than fixed reports.
Requirements
A remote Streamable HTTP endpoint (no local install); Claude Desktop needs the mcp-remote bridge via npx. A free API key sent as a bearer token in the Authorization header, obtained by signing in at the provider's site. Network access to the hosted endpoint.
Before you install
The Authorization header carries your API key, so keep it out of shared configs and repositories. Queries are read-only and capped at 100 rows and 10 seconds, so results are partial samples rather than full exports. Data comes from scraping TikTok's mobile API and is sent to the hosted service; the full database without the row limit is a paid offering.

Installation

In SourceWeft

  1. Open DataSocial in the dashboard and add it to a workspace.
  2. Connect Authorization token credentials. They are stored privately and never shown on public pages.
  3. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/io.github.hashfunction-dev%2Fdatasocial-mcp/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "datasocial": {
      "type": "http",
      "url": "https://api.datasocial.ai/mcp",
      "headers": {
        "Authorization": "Bearer <YOUR_TOKEN>"
      }
    }
  }
}

README

DataSocial MCP: query TikTok data from Claude, Cursor or any MCP client

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.

  • Endpoint: https://api.datasocial.ai/mcp (Streamable HTTP, stateless)
  • Key: free. Sign in at datasocial.ai, open the MCP tab, and copy the command with your key already in it.
  • Limits: 100 rows per query, 10 s per query, read-only.

Connect

Claude Code

bash
claude mcp add --transport http datasocial https://api.datasocial.ai/mcp \  --header "Authorization: Bearer $DATASOCIAL_KEY"

Cursor (~/.cursor/mcp.json)

json
{  "mcpServers": {    "datasocial": {      "url": "https://api.datasocial.ai/mcp",      "headers": { "Authorization": "Bearer YOUR_KEY" }    }  }}

Claude Desktop (claude_desktop_config.json, via mcp-remote)

json
{  "mcpServers": {    "datasocial": {      "command": "npx",      "args": ["-y", "mcp-remote", "https://api.datasocial.ai/mcp", "--header", "Authorization:${AUTH}"],      "env": { "AUTH": "Bearer YOUR_KEY" }    }  }}

Tools

ToolWhat it does
list_tablesThe tables, their row counts and what one row is
describe_tableOne table's columns, types and sort key
examplesWorked questions with SQL that runs, plus SQL tips
run_sqlRuns one read-only SELECT (up to 100 rows)

Things to ask

  • "Which US creators with over 1M followers grew fastest this week?"
  • "Which sounds are being used in the most new videos today?"
  • "Who does @<username> follow?"
  • "What's the average view count of videos by creators in Brazil with 100K–500K followers?"

Daily creator and video history started on 2026-09-26; sound history has 106 days since January 2026.

Also

This repo holds documentation only; the server is hosted.

Source: README.md at commit b41d084

Tools

4

list_tables

List tables

The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.

Takes no parameters.

describe_table

Describe a table

One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.

Parameterstablerequired

examples

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.

Parameterstable

run_sql

Run 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.

Parameterssqlrequired

Version history

1
  1. v1.0.0LatestSep 29, 2026

Score

90% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listedRequired15 pts
  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts

    Declare a license in the repository or the registry entry.