MCP Clickhouse
by ClickHouse
Query ClickHouse, inspect schemas, bind SQL parameters, and optionally run queries through embedded chDB.
Install MCP Clickhouse
Pick your client, then add it in one click or paste the config.
~/Library/Application Support/Claude/claude_desktop_config.json{
"mcpServers": {
"clickhouse-mcp-clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_ALLOW_WRITE_ACCESS": "YOUR_VALUE_HERE",
"CLICKHOUSE_ALLOW_DROP": "YOUR_VALUE_HERE"
}
}
}
}
Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.
Values are written into the snippet above so you can paste it as is. They never leave your browser.
Automated check passed— started and listed 3 tools correctly ().
Overview
Use cases
- Inspect ClickHouse databases and table schemas before generating SQL
- Run read-only analytical queries with typed named parameters
- Check query output columns before execution
- Estimate MergeTree reads before an expensive SELECT
- Query local or remote sources through embedded chDB
Key features
- ClickHouse database and table discovery
- Paginated table metadata with filters
- Read-only SQL execution by default
- Typed named query parameters
- DESCRIBE and EXPLAIN ESTIMATE checks
- Optional embedded chDB query tool
Tools3
What MCP Clickhouse lets your agent do. Expand a tool for its parameters.
Security & health
What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.
Recent health check succeeded.
What it can do
From the 3 tools this server returned when we ran it.
Observed 2026-11-12 in an isolated sandbox. A description of reach, not a security audit.
Supply-chain signal
No high-severity advisories surfaced by our automated scan.
Scanned 10d ago via OSV.dev · mcp-clickhouse (PyPI)
Adoption & maintenance
Factual signals from GitHub, npm, and our automated checks — not a rating.
How MCP Clickhouse works
Reviews
No reviews yet — be the first to share how it worked for you.
Frequently Asked Questions about MCP Clickhouse
Related MCP servers
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.
AllMCPs Directory Badge
Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.
[](https://allmcps.com/mcp/clickhouse-mcp-clickhouse)<a href="https://allmcps.com/mcp/clickhouse-mcp-clickhouse"><img src="https://allmcps.com/api/badge/clickhouse-mcp-clickhouse?style=directory" alt="MCP Clickhouse on AllMCPs" /></a>