ClickHouse MCP
Query and explore ClickHouse databases with AI assistants
How to Install ClickHouse MCP
$npx -y @clickhouse/mcp-clickhouseRequires Claude Desktop, Cursor, Windsurf, or another MCP-compatible client.
About ClickHouse MCP
The ClickHouse MCP server enables secure, read-only SQL querying and database exploration for ClickHouse clusters directly from AI coding tools. It supports both cloud and self-hosted ClickHouse deployments, enabling natural-language analytics queries, schema exploration, and data validation through any MCP-compatible client.
ClickHouse MCP is a Database MCP server designed for developers, analysts, and data teams. It enables querying and managing databases from an AI assistant by exposing schema introspection and SQL execution as MCP tools. Key capabilities include schema introspection across tables and views, parameterised sql execution, read-only and read/write modes, and structured tool calls that work cleanly inside an LLM context. It integrates with Postgres, MySQL, SQLite, MongoDB, Redis, BigQuery, and Snowflake, and is best suited for developers, analysts, and data teams who need ad-hoc analytics without a bi tool.
Key Features
- database
- analytics
- sql
- clickhouse
- data
Pricing
- Core MCP server
- Community support
- Works with any MCP client
- Everything in Free
- Higher usage limits
- Priority support
- Everything in Pro
- SLA & SSO
- Dedicated support
Tier details are indicative — visit the ClickHouse MCP website for current pricing.
Pros & Cons
Pros
- Lets the assistant write and run real queries instead of guessing
- Read-only mode is safe to point at production-shaped data
- Skips most ORM and CSV-shuffling boilerplate
Cons
- Misconfigured permissions can expose sensitive data
- Long-running queries need explicit timeouts
- Schema drift requires reconnecting or refreshing context
Best For
- Ad-hoc analytics without a BI tool
- Drafting migrations and reviewing query plans
- Letting non-SQL teammates ask questions of a database
- Bootstrapping internal admin workflows
Screenshots
Screenshots coming soon —
Submit yours →Our Take on ClickHouse MCP
ClickHouse MCP makes analytical database exploration conversational — ideal for data teams who want AI-assisted query building and schema understanding without leaving their coding environment.