MCP server

ClickHouse

MCP

Official ClickHouse MCP. Analytics, not a second console.

Query and explore clusters and chDB from ClickHouse’s own server.

latest·Apache-2.0·Updated this quarter·github.com/ClickHouse/mcp-clickhouse·Transport: stdio

Claude CodeCursorVS CodeDesktop
ScannedActive

claude_desktop_config.json

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "…"
      }
    }
  }
}

By ClickHouse

Spec

What the server actually exposes.

  • list_tables

    read

    Tables and columns on the cluster.

  • run_query

    read

    Read-only SQL.

  • cluster_health

    read

    Basic cluster status.

Guardrails

  • Credentials stay in env
  • Read-first unless a write tool is called
  • Official package, not a wrapper

clickhouse-mcp.mcp/tools

Tools

  • list_tables

    Tables and columns on the cluster.

    read
  • run_query

    Read-only SQL.

    read
  • cluster_health

    Basic cluster status.

    read

Last call

{ "ok": true,
  "tool": "list_tables",
  "rows": 12 }

Other servers worth installing

Discussion

No notes yet. Be the first hunter to report back.