ClickHouse/mcp-clickhouse

MCP Data & Storage

ClickHouse database integration with schema inspection and query capabilities

Python Latest v0.4.0 · 9h ago Security brief →

Features

Execute SQL queries on a ClickHouse cluster via `run_query`
List databases and tables with pagination and optional filters using `list_databases` and `list_tables`
Run embedded chDB Select queries against various data sources

View all 3 releases →

Config change

v0.4.0 Breaking risk 9h

Auth

Exclusive auth + JSON responses

Open

v0.3.0 New feature 1mo

⚠ Upgrade required

Set CLICKHOUSE_WRITE_ACCESS to enable write‑access mode with built‑in DROP/TRUNCATE protection
Use CLICKHOUSE_MCP_MIDDLEWARE to inject custom middleware into the MCP server lifecycle

Notable features

SNI override via CLICKHOUSE_SNI environment variable for proxy/load balancer connections
Client config override through MCP Context session states enabling runtime connection switching
Optional chdb dependency and lazy-load to reduce memory overhead on Windows

Full changelog

SNI override support via CLICKHOUSE_SNI environment variable for connections behind proxies or load balancers. (#127)
Lazy-load chdb to avoid ~80-100 MB memory overhead when the feature is disabled. (#144)
Made chdb an optional dependency for Windows compatibility. (#145)
Optional write access mode via CLICKHOUSE_WRITE_ACCESS environment variable, with built-in DROP and TRUNCATE protection. (#93)
Client config override support through MCP Context session states, enabling dynamic connection switching at runtime. (#115)
Custom middleware injection via CLICKHOUSE_MCP_MIDDLEWARE environment variable for hooking into the MCP server lifecycle. Includes an example middleware module. (#114)