English Français العربية

io.github.Aguantar/clickhouse-dataops-mcp

Registre officiel Données et bases de données

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

Code source Documentation

Que pouvez-vous faire avec io.github.Aguantar/clickhouse-dataops-mcp ?

  • 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

Installation

Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).

PYPI package clickhouse-dataops-mcp
Claude Code 
claude mcp add clickhouse-dataops-mcp -e 'CLICKHOUSE_HOST=<CLICKHOUSE_HOST>' -e 'CLICKHOUSE_PORT=<CLICKHOUSE_PORT>' -e 'CLICKHOUSE_PASSWORD=<your clickhouse_password>' -- uvx clickhouse-dataops-mcp==0.1.1
Configuration JSON (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "clickhouse-dataops-mcp": {
            "command": "uvx",
            "args": [
                "clickhouse-dataops-mcp==0.1.1"
            ],
            "env": {
                "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
                "CLICKHOUSE_PORT": "<CLICKHOUSE_PORT>",
                "CLICKHOUSE_PASSWORD": "<your clickhouse_password>"
            }
        }
    }
}

Variables d'environnement

  • CLICKHOUSE_HOST ClickHouse HTTP host
  • CLICKHOUSE_PORT ClickHouse HTTP port
  • CLICKHOUSE_PASSWORD secret ClickHouse password

Documentation

Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.

Sommaire
  1. clickhouse-dataops-mcp
  2. Features
  3. Safety
  4. Installation
  5. Usage with Claude Code
  6. Environment Variables
  7. License

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

VariableDefaultDescription
CLICKHOUSE_HOSTlocalhostClickHouse HTTP host
CLICKHOUSE_PORT8123ClickHouse HTTP port
CLICKHOUSE_USERdefaultClickHouse username
CLICKHOUSE_PASSWORD(empty)ClickHouse password
CLICKHOUSE_DATABASEcdc_pipelineDefault database
CLICKHOUSE_QUERY_TIMEOUT30Query timeout in seconds

License

MIT

Questions fréquentes

Qu'est-ce que io.github.Aguantar/clickhouse-dataops-mcp ?

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

Comment installer io.github.Aguantar/clickhouse-dataops-mcp ?

Il s'exécute sur votre machine. Dans Claude Code : claude mcp add clickhouse-dataops-mcp -e 'CLICKHOUSE_HOST=<CLICKHOUSE_HOST>' -e 'CLICKHOUSE_PORT=<CLICKHOUSE_PORT>' -e 'CLICKHOUSE_PASSWORD=<your clickhouse_password>' -- uvx clickhouse-dataops-mcp==0.1.1. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.

Faut-il une clé API pour io.github.Aguantar/clickhouse-dataops-mcp ?

Oui. Il attend CLICKHOUSE_PASSWORD, à renseigner dans sa configuration.

io.github.Aguantar/clickhouse-dataops-mcp est-il open source ?

Oui. Son code est sur GitHub sous licence MIT.

Qui maintient io.github.Aguantar/clickhouse-dataops-mcp ?

Il est publié par Aguantar. AI.tn le référence sans le maintenir ni le recommander.

Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.