This server connects Claude to ClickHouse with a focus on query optimization and pipeline monitoring rather than just raw query execution. It exposes tools like ch_explain_query for EXPLAIN-based analysis with optimization suggestions, ch_pipeline_latency for CDC pipeline performance tracking, and ch_data_quality for null and duplicate detection. All operations are read-only with validation that blocks DDL, DML, and multi-statement queries. You'd reach for this when you need Claude to help diagnose slow queries, analyze data quality issues, or optimize ClickHouse table schemas. It includes built-in safeguards like 30-second timeouts and system table allowlists, making it safer for production database analysis.
claude mcp add --transport stdio io.github.aguantar-clickhouse-dataops-mcp -- uvx clickhouse-dataops-mcp