How do I install the clickhouse mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `CLICKHOUSE_HOST`, `CLICKHOUSE_PORT`, `CLICKHOUSE_DATABASE` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Clickhouse MCP Server

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

Local serverstdio

What is the Clickhouse MCP Server?

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

What you get

A DataOps-focused MCP server for ClickHouse with query optimization, pipeline latency analysis, and data quality monitoring.

ch_query — — Execute SELECT with automatic partition pruning warnings
ch_explain_query — — EXPLAIN-based analysis with optimization suggestions
ch_table_schema — — Comprehensive table metadata (columns, keys, partitions, samples)
ch_pipeline_latency — — CDC pipeline per-segment latency (p50/p95/p99)
ch_data_quality — — Null/duplicate/gap detection with market coverage checks
ch_slow_queries — — Slow query detection with root cause diagnosis

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the Clickhouse MCP Server

{
  "mcpServers": {
    "clickhouse-dataops": {
      "command": "uvx",
      "args": ["clickhouse-dataops-mcp"],
      "env": {
        "CLICKHOUSE_HOST": "your-value",
        "CLICKHOUSE_PORT": "your-value",
        "CLICKHOUSE_DATABASE": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

Variable	Description	Required
CLICKHOUSE_HOST	Endpoint or connection string the server talks to.	Optional
CLICKHOUSE_PORT	Configuration value read at startup.	Optional
CLICKHOUSE_DATABASE	Configuration value read at startup.	Optional

Frequently asked questions

DataOps ClickHouse MCP server with query optimization and pipeline monitoring Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.