ClickHouse MCP

Stack Score

Editorial pick✓ Verified workingMCP server

ClickHouse MCP

Query ClickHouse columnar OLAP from Claude.

Try ClickHouse MCP

Best for

Best for analytics-heavy teams running ClickHouse for event or time-series data.

At a glance

Pricing: open-source
Setup time: 20 minutes
Learning curve: moderate
Last verified: 5/27/2026

What we love

✓Maintained by ClickHouse
✓Blazing fast on huge tables
✓Cloud + self-host options

Where it falls short

−Different SQL dialect quirks
−Best for read-only mode
−Cost of misqueries can be real

Install & connect

Copy-paste ready

Install

shell

uv run --with mcp-clickhouse --python 3.10 mcp-clickhouse

Config — Claude Desktop

json

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uv",
      "args": ["run", "--with", "mcp-clickhouse", "--python", "3.10", "mcp-clickhouse"],
      "env": {
        "CLICKHOUSE_HOST": "your-clickhouse-host",
        "CLICKHOUSE_PORT": "8443",
        "CLICKHOUSE_USER": "your_user",
        "CLICKHOUSE_PASSWORD": "your_password",
        "CLICKHOUSE_SECURE": "true"
      }
    }
  }
}

Pricing

✓ Pricing verified Jun 21, 2026

1 tier

Open-source

perpetual

✓Apache 2.0

Overview

MCP server for ClickHouse — SELECT, schema introspection, query history. Use Claude to write fast analytical SQL against billion-row tables.

Key features

●Read + write queries
●Schema introspection
●ClickHouse Cloud + self-host
●Cluster aware
●TLS auth

Exposed tools

The MCP-tool names this server exposes. Your agent can invoke any of these when this server is connected.

run_query
Execute SQL queries on a ClickHouse cluster; read-only by default with optional write access.
list_databases
List all databases on a ClickHouse cluster.
list_tables
List tables in a database with pagination, LIKE/NOT LIKE filters, and optional column metadata.
run_chdb_select_query
Execute SQL queries using chDB's embedded ClickHouse engine for ad-hoc analysis over files, URLs, and databases.

Best use cases

Event-data exploration

Have Claude query billion-row event tables for ad-hoc analysis.

Real-time analytics

Run sub-second analytical SQL against ClickHouse from chat.

Integrations

ClickHouse Cloud

ClickHouse OSS

Tinybird

Similar tools

See all analytics →

Hotjar

Heatmaps, session recordings, and surveys.

Mixpanel

Event analytics for product teams.

RudderStack

Open-source customer data platform.

Compare side-by-side

ClickHouse MCP vs Hotjar vs Mixpanel

Pros, cons, pricing, role-fit — all on one page.

Open comparison

One AI Stack pick every week.

The tool we’d pay for this week, why we’d pay for it, and what we’d skip. No promo spam.