English Français العربية

io.github.Aguantar/clickhouse-dataops-mcp

السجل الرسمي البيانات وقواعدها

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

الشيفرة المصدرية التوثيق

ماذا يمكنك أن تفعل مع 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

التثبيت

أضف هذا إلى إعدادات MCP في عميلك (Claude Desktop: claude_desktop_config.json، وCursor: ‏.cursor/mcp.json، ويستخدم VS Code وغيره الصيغة نفسها «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
إعداد 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>"
            }
        }
    }
}

متغيرات البيئة

  • CLICKHOUSE_HOST ClickHouse HTTP host
  • CLICKHOUSE_PORT ClickHouse HTTP port
  • CLICKHOUSE_PASSWORD سري ClickHouse password

التوثيق

مأخوذ من ملف README للمشروع على GitHub ويُحدَّث أسبوعيًا. تفتح الروابط على GitHub.

المحتويات
  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

الأسئلة الشائعة

ما هو io.github.Aguantar/clickhouse-dataops-mcp؟

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

كيف أثبّت io.github.Aguantar/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. وفي العملاء الآخرين، الصق إعداد JSON من هذه الصفحة في إعدادات MCP الخاصة بهم.

هل يحتاج io.github.Aguantar/clickhouse-dataops-mcp إلى مفتاح API؟

نعم. يتطلب CLICKHOUSE_PASSWORD، وتضبطها في إعداداته.

هل io.github.Aguantar/clickhouse-dataops-mcp مفتوح المصدر؟

نعم. شيفرته متاحة على GitHub بترخيص MIT.

من يصون io.github.Aguantar/clickhouse-dataops-mcp؟

ينشره Aguantar. يدرجه AI.tn لكنه لا يصونه ولا يوصي به.

من سجل MCP الرسمي. الإدراج ليس توصية: راجع شيفرة الخادم وصلاحياته قبل منحه الوصول إلى بياناتك.