ClaudeMap

ClickHouse MCP

ClickHouse's official MCP server — let Claude run SQL against your OLAP data.

MCP Serversofficialdatabaseolapsqlmcp
Visit projectClickHouse/mcp-clickhouse

The official MCP server from ClickHouse: connects Claude to a ClickHouse instance (or an embedded chDB) so the model can list databases, explore schemas, and run read-oriented SQL. The natural pick for analytics workflows where the fastest path from question to answer is a query the agent writes itself.

What it does

  • Official ClickHouse MCP — run SQL queries, list databases/tables, against any ClickHouse cluster
  • Optional `chdb` extra queries local files/URLs directly without a server
  • Health endpoint `/health` when run over HTTP/SSE for orchestrator probes

When to use it

Let Claude explore a warehouse schema and iterate on analytical SQL — especially with the ClickHouse SQL playground for zero-setup testing.

Getting started

{
  "mcp-clickhouse": {
    "command": "uv",
    "args": [
      "run", "--with", "mcp-clickhouse",
      "--python", "3.12", "mcp-clickhouse"
    ],
    "env": {
      "CLICKHOUSE_HOST": "<clickhouse-host>",
      "CLICKHOUSE_PORT": "<clickhouse-port>",
      "CLICKHOUSE_USER": "<clickhouse-user>",
      "CLICKHOUSE_PASSWORD": "<clickhouse-password>",
      "CLICKHOUSE_SECURE": "true",
      "CLICKHOUSE_VERIFY": "true"
    }
  }
}

Use `which uv` for the absolute path if the client can't resolve `uv`.

Things to know

Read/write power follows the ClickHouse user you configure — point it at a read-only user for safety. Requires Python 3.12 via uv; `chdb` local-file mode needs `pip install 'mcp-clickhouse[chdb]'`.

Repository

ClickHouse/mcp-clickhouse

Charted

Related on the map

  • Blitz Strike

    MCP Server

    A penetration-testing methodology delivered as one MCP server: BLITZ maps the attack surface, EAGLE-EYE traces source-to-sink, STRIKE live-verifies every finding before it is reported.

    • mcp-server
    • security
    • pentest
    • methodology
    View

  • Ripwire

    MCP Server

    Red Hat's "ripgrep for AI context" — a C++23 zero-dependency CLI that also speaks MCP.

    • mcp
    • code-context
    • cli
    • red-hat
    View

  • Deja Vu

    MCP Server

    One shared session memory for 25+ coding agents — Claude Code, Codex, and Cursor finally remember the same project.

    • mcp
    • memory
    • cross-agent
    • context
    View