English Français العربية

io.github.Aguantar/clickhouse-dataops-mcp

Official registry Data and databases

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

Source code Documentation

What can you do with 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

Install

Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).

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 configuration (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>"
            }
        }
    }
}

Environment variables

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

Documentation

From the project's README on GitHub, refreshed weekly. Links open on GitHub.

Contents
  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

Frequently asked questions

What is io.github.Aguantar/clickhouse-dataops-mcp?

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

How do I install io.github.Aguantar/clickhouse-dataops-mcp?

It runs on your machine. In 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. For other clients, paste the JSON configuration from this page into their MCP settings.

Does io.github.Aguantar/clickhouse-dataops-mcp need an API key?

Yes. It expects CLICKHOUSE_PASSWORD, which you set in its configuration.

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

Yes. Its code is on GitHub under the MIT license.

Who maintains io.github.Aguantar/clickhouse-dataops-mcp?

It is published by Aguantar. AI.tn lists it but does not maintain or endorse it.

From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.