Distributism logoDistributism

Data & APIs

ClickHouse MCP

ClickHouse MCP connects your AI assistant to ClickHouse, the fast open-source OLAP database. Execute analytical queries, inspect table schemas, analyze large datasets in real-time, and generate reports from billions of rows. Optimized for columnar data and aggregation workloads.

Stars

560

Installs

32.0k

License

Apache-2.0

Kind

MCP

Trust evidence

Verified

Verified MCP — curated catalog entry with reviewed setup metadata.

  • Stars: 560 · catalog
  • Freshness: Updated 2026-01-18
  • Used in 0 known stacks (editorial graph may still apply)

Prerequisites

  • · Host app that loads MCP config (Cursor, Claude Desktop, etc.)
  • · Environment: CLICKHOUSE_HOST
  • · Environment: CLICKHOUSE_USER
  • · Environment: CLICKHOUSE_PASSWORD
  • · Python 3 + pip

Reference command

{
  "mcpServers": {
    "clickhouse": {
      "command": "python",
      "args": ["-m", "mcp_clickhouse"],
      "env": {
        "CLICKHOUSE_HOST": "<your-host>",
        "CLICKHOUSE_USER": "<your-user>",
        "CLICKHOUSE_PASSWORD": "<your-password>"
      }
    }
  }
}

Often stacked with