ClickHouse MCP
Official ClickHouse MCP server with both ClickHouse Tools (production cluster queries) and chDB Tools (embedded ClickHouse for local analytics). Apache-2.0 with destructive-operation protection: write access is opt-in via configuration.
“Official ClickHouse MCP server with both ClickHouse Tools (production cluster queries) and chDB Tools (embedded ClickHouse for local analytics). 766 GitHub stars and 8 commits on main in the last 30 days. Apache-2.0 with destructive-operation protection: write access is opt-in via configuration.”
INSTALL THIS SERVER
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "<your-clickhouse-host>",
"CLICKHOUSE_USER": "<your-user>",
"CLICKHOUSE_PASSWORD": "<your-password>"
}
}
}
}
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "<your-clickhouse-host>",
"CLICKHOUSE_USER": "<your-user>",
"CLICKHOUSE_PASSWORD": "<your-password>"
}
}
}
}
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "<your-clickhouse-host>",
"CLICKHOUSE_USER": "<your-user>",
"CLICKHOUSE_PASSWORD": "<your-password>"
}
}
}
}
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "<your-clickhouse-host>",
"CLICKHOUSE_USER": "<your-user>",
"CLICKHOUSE_PASSWORD": "<your-password>"
}
}
}
}
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "<your-clickhouse-host>",
"CLICKHOUSE_USER": "<your-user>",
"CLICKHOUSE_PASSWORD": "<your-password>"
}
}
}
}
5 TOOLS AVAILABLE
OUR ASSESSMENT
- Official ClickHouse maintenance.
- 766 GitHub stars and Apache-2.0 licence.
- 8 commits on main in the last 30 days.
- Two tool families: production cluster (ClickHouse Tools) and embedded analytics (chDB Tools).
- Destructive-operation protection: write access requires explicit configuration opt-in.
- Authentication for HTTP and SSE transports built in.
- Custom middleware support for request logging, rate limiting, or auth wrapping.
- Dynamic client configuration via Context State for multi-tenant deployments.
- Self-hosted: operator runs the MCP against their ClickHouse cluster.
- chDB tools require additional local setup for the embedded engine.
- ClickHouse SQL has dialect specifics; agents trained on standard SQL may produce queries that need ClickHouse-specific revision.
The MCP carries the credentials configured at startup through to the ClickHouse cluster. Default to read-only credentials; opt into write access via the destructive-operation protection toggle only when the agent flow needs DML. Custom middleware can wrap the MCP to add audit logging, rate limiting, or per-request authentication. For multi-tenant deployments, Dynamic Client Configuration via Context State scopes the connection per agent session.
Teams running ClickHouse for analytics who want agents to query production data with SQL inside the editor; data engineers who want both production-cluster and embedded-chDB tooling in one MCP; multi-tenant deployments using Dynamic Client Configuration.
TECHNICAL DETAILS
ADOPTION METRICS
// Reading this766 stars on the ClickHouse/mcp-clickhouse repo. 8 commits on main in the last 30 days. Official ClickHouse maintenance carries the editorial weight.
// Reading thisTop OLAP database MCP at time of review; complements existing OLTP-focused database entries.
SOURCES & VERIFICATION
We don't take any single directory's word for it. Before scoring, we cross-reference 5 public MCP sources, install the server ourselves against the clients we cover, and record when we last re-verified.
The same server, 5 different lenses. We reconcile these signals into our editorial score, which is why our number sometimes diverges from a directory-aggregate star count.
| Source | Their rating | Their star count | Their downloads | Last synced |
|---|---|---|---|---|
| AutomationSwitch This page | 4.5editorial | 766 | — | MAY 3, 2026 |
| PulseMCP | — unrated | unavailable | unavailable | MAY 3, 2026 |
| MCP.so | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Glama | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Smithery | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Official MCP Registry | — unrated | unavailable | unavailable | MAY 3, 2026 |
// Counts are directory-reported; we don't adjust them. Discrepancies usually come from different snapshot times or star-caching.
OTHER DATABASE MCP SERVERS
Postgres MCP
Official MCP server for PostgreSQL. Provides read and write access to PostgreSQL databases with schema introspection, query execution, and transaction support. The reference implementation for database MCP servers.
Supabase
Persistence layer with full Postgres access and Row Level Security awareness. Query tables, manage schemas, handle auth users, and work with storage buckets.
Redis MCP
Official Redis MCP server with natural-language interface for managing and searching Redis data. EntraID authentication for Azure Managed Redis included; Redis ACL configurable via environment variables. Tool coverage spans strings, lists, hashes, sets, sorted sets, JSON, vectors, and search.
MindsDB
A federated query engine that exposes 200+ data sources as MCP tools through a unified SQL-compatible interface. Built around a Connect → Unify → Respond workflow with structured tables fused with vectorized data inside Knowledge Bases.
Neon MCP
MCP server for Neon serverless Postgres. Provides database branching, query execution, and project management. Branch-per-query makes every schema change reversible.
MongoDB MCP Server
Vendor-built MongoDB MCP server covering both direct database operations (against any MongoDB connection string) and MongoDB Atlas API operations (via Service Accounts credentials). Ships with --readOnly enabled by default in every official install snippet.
DISCUSS YOUR
MCP REQUIREMENTS.
Evaluating a server, scoping an internal deployment, or working out whether MCP is the right fit at all. Start the conversation and we will point you at the right piece of the ecosystem.