{
  "markdown": "# clickhouse-dataops-mcp\n\nmcp-name: io.github.Aguantar/clickhouse-dataops-mcp\n\nA DataOps-focused MCP server for ClickHouse with query optimization, pipeline latency analysis, and data quality monitoring.\n\n## Features\n\nUnlike generic ClickHouse MCP servers that only run queries, this server acts as a **query optimization advisor**:\n\n- **`ch_query`** — Execute SELECT with automatic partition pruning warnings\n- **`ch_explain_query`** — EXPLAIN-based analysis with optimization suggestions\n- **`ch_table_schema`** — Comprehensive table metadata (columns, keys, partitions, samples)\n- **`ch_pipeline_latency`** — CDC pipeline per-segment latency (p50/p95/p99)\n- **`ch_data_quality`** — Null/duplicate/gap detection with market coverage checks\n- **`ch_slow_queries`** — Slow query detection with root cause diagnosis\n- **`ch_disk_usage`** — Disk analysis with TTL and optimization recommendations\n- **`ch_list_tables`** — Table catalog with built-in descriptions\n\n## Safety\n\nAll queries are read-only. DDL/DML operations are blocked at the SQL validation layer:\n\n- Blocked: `DROP`, `TRUNCATE`, `DELETE`, `ALTER`, `INSERT`, `UPDATE`, `CREATE`, etc.\n- Multi-statement queries blocked (`;` separator)\n- Comment-based bypass prevented (comments stripped before validation)\n- System tables restricted to allowlist\n- Query timeout: 30 seconds\n- Row limit enforcement\n\n## Installation\n\n```bash\npip install clickhouse-dataops-mcp\n```\n\n## Usage with Claude Code\n\nAdd to your `.mcp.json`:\n\n```json\n{\n  \"mcpServers\": {\n    \"clickhouse\": {\n      \"command\": \"clickhouse-mcp-server\",\n      \"env\": {\n        \"CLICKHOUSE_HOST\": \"localhost\",\n        \"CLICKHOUSE_PORT\": \"8123\",\n        \"CLICKHOUSE_DATABASE\": \"cdc_pipeline\"\n      }\n    }\n  }\n}\n```\n\n## Environment Variables\n\n| Variable | Default | Description |\n|----------|---------|-------------|\n| `CLICKHOUSE_HOST` | `localhost` | ClickHouse HTTP host |\n| `CLICKHOUSE_PORT` | `8123` | ClickHouse HTTP port |\n| `CLICKHOUSE_USER` | `default` | ClickHouse username |\n| `CLICKHOUSE_PASSWORD` | (empty) | ClickHouse password |\n| `CLICKHOUSE_DATABASE` | `cdc_pipeline` | Default database |\n| `CLICKHOUSE_QUERY_TIMEOUT` | `30` | Query timeout in seconds |\n\n## License\n\nMIT\n",
  "bytes": 2200,
  "sha": "e0a76cbfa57eb099887b7cd8693e86779de026401c8d7d4f7ed25f1c485825d4",
  "repo_slug": "aguantar/clickhouse-mcp-server",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/mcp_io_github_aguantar_clickhouse_dataops_mc_9250c23e/readme"
}