clickhouse-dataops-mcp

mcp-name: io.github.Aguantar/clickhouse-dataops-mcp

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

Features

Unlike generic ClickHouse MCP servers that only run queries, this server acts as a query optimization advisor:

• `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
• `ch_disk_usage` — Disk analysis with TTL and optimization recommendations
• `ch_list_tables` — Table catalog with built-in descriptions

Safety

All queries are read-only. DDL/DML operations are blocked at the SQL validation layer:

• Blocked: DROP, TRUNCATE, DELETE, ALTER, INSERT, UPDATE, CREATE, etc.
• Multi-statement queries blocked (; separator)
• Comment-based bypass prevented (comments stripped before validation)
• System tables restricted to allowlist
• Query timeout: 30 seconds
• Row limit enforcement

Installation

pip install clickhouse-dataops-mcp

Usage with Claude Code

Add to your .mcp.json:

{
  "mcpServers": {
    "clickhouse": {
      "command": "clickhouse-mcp-server",
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_PORT": "8123",
        "CLICKHOUSE_DATABASE": "cdc_pipeline"
      }
    }
  }
}

Environment Variables

License

MIT