Skip to content

DataSocial

by hashfunction-dev · remote · no sign-in to list tools · v1.0.0 · published by GitHub user hashfunction-dev

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

Changes · 2
CompareRegistry entry

4 tools: 2 change things and 2 only read.

Scanned Oct 21, 2026

1 check matched something in the tool definitions. No finding is not a safety guarantee. How the checks work.

claude mcp add --transport http datasocial https://api.datasocial.ai/mcp --header 'Authorization: <your-authorization>'

Findings

Matches of fixed checks, with the text they matched.

1 warn
  • Warnrun_sql

    The server marks "run_sql" read-only (readOnlyHint: true), and its own name, description or input give the class "write".

    Matched text

    annotations: {"readOnlyHint":true,"openWorldHint":false}; The name "run_sql" says "run": a word for a change.

    What this check looks for

Tools

Open a tool for its reasons and full description. Descriptions are the publisher's own words, shown as they are.

4 tools

Changes things 2Claude Code: ask
  • examplesWorked examples (a question and SQL that runs here) and the SQL tips: growth maths, history-table patterns, big sound_history days, follows lookups.No findings

    Why it is in this group

    • Nothing in its name or description says what it does, so it is counted as a write.
    • The server marks it read-only (readOnlyHint: true), but an annotation never lowers a class.
    Description, as the server wrote it
    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.

    Annotations the server declares

    • readOnlyHint: true
  • run_sqlRun one read-only ClickHouse SELECT on tiktok.* and get the rows back (at most 100 per request; 10 s per query).1 finding

    Why it is in this group

    • The name "run_sql" says "run": a word for a change.
    • The input takes a statement or command to run (input.sql), which can change anything it can reach.
    • The server marks it read-only (readOnlyHint: true), but an annotation never lowers a class.

    Findings

    • Warn

      The server marks "run_sql" read-only (readOnlyHint: true), and its own name, description or input give the class "write".

      Matched text

      annotations: {"readOnlyHint":true,"openWorldHint":false}; The name "run_sql" says "run": a word for a change.

      What this check looks for
    Description, as the server wrote it
    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.

    Annotations the server declares

    • readOnlyHint: true
    • openWorldHint: false
Only reads 2Claude Code: allow
  • describe_tableOne table's columns with types and meanings, its sort key and coverage.No findings

    Why it is in this group

    • The name "describe_table" says "describe": a word for reading.
    Description, as the server wrote it
    One table's columns with types and meanings, its sort key and coverage. Read it before writing SQL on a table.

    Annotations the server declares

    • readOnlyHint: true
  • list_tablesThe tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.No findings

    Why it is in this group

    • The name "list_tables" says "list": a word for reading.
    Description, as the server wrote it
    The tables in the DataSocial TikTok warehouse: name, row count, what one row is, and what it holds.

    Annotations the server declares

    • readOnlyHint: true

This is not a safety rating, and no finding is not a safety guarantee. The groups and findings come from fixed checks of the tool definitions the server returned on the date shown, not from its code or what it does when called. How the checks work.

Install

Pinned to version 1.0.0. Values in angle brackets are yours to fill in.

claude mcp add --transport http datasocial https://api.datasocial.ai/mcp --header 'Authorization: <your-authorization>'

Run in a terminal.

Claude Code permissions

Allow the reads, ask before a change, deny the deletes. Paste into .claude/settings.json.

.claude/settings.json
{
  "permissions": {
    "allow": [
      "mcp__datasocial__list_tables",
      "mcp__datasocial__describe_table"
    ],
    "ask": [
      "mcp__datasocial__examples",
      "mcp__datasocial__run_sql"
    ],
    "deny": []
  }
}

Tools that only read are allowed, tools that change things ask first, tools that delete or cancel are denied. It assumes the server is installed as datasocial. Review it before you use it.