io.github.Aguantar/clickhouse-dataops-mcp

clickhouse-dataops-mcp

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

8 tools GitHub PyPI

No known CVEs

No license

Maintained

Last commit 71d ago

Works with most clients

Transport: stdio

8 tools · ~364 tok

Grade A · 0.2% of 200K ctx

Edit this pageView history

Data DevOps

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktopstdio · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "clickhouse": {
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_PORT": "8123",
        "CLICKHOUSE_DATABASE": "cdc_pipeline"
      },
      "command": "clickhouse-mcp-server"
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/io-github-aguantar-clickhouse-dataops-mcp)](https://mcppedia.org/s/io-github-aguantar-clickhouse-dataops-mcp)

Read me

What io.github.Aguantar/clickhouse-dataops-mcp does

mcp-name: io.github.Aguantar/clickhouse-dataops-mcp

Test This Server

Run this in your terminal to verify the server starts. Then let us know if it worked — your result helps other developers.

uvx 'clickhouse-dataops-mcp' 2>&1 | head -1 && echo "✓ Server started successfully"

After testing, let us know if it worked:

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

80/100across 5 weighted dimensions

How we score →

0255075100

−20

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

Checked clickhouse-dataops-mcp against OSV.dev.

Inventory

Tools (8)

Click any tool to inspect its schema.

~364 tokens total

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is io.github.Aguantar/clickhouse-dataops-mcp safe to use?: io.github.Aguantar/clickhouse-dataops-mcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments.
How do I install io.github.Aguantar/clickhouse-dataops-mcp?: io.github.Aguantar/clickhouse-dataops-mcp supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
What can io.github.Aguantar/clickhouse-dataops-mcp do?: io.github.Aguantar/clickhouse-dataops-mcp provides 8 tools: ch_query, ch_explain_query, ch_table_schema, ch_pipeline_latency, ch_data_quality and 3 more. See the full tools list on the server page for descriptions and parameters.
What AI clients work with io.github.Aguantar/clickhouse-dataops-mcp?: io.github.Aguantar/clickhouse-dataops-mcp is compatible with claude-desktop, cursor, claude-code. It uses stdio transport.
Is io.github.Aguantar/clickhouse-dataops-mcp actively maintained?: io.github.Aguantar/clickhouse-dataops-mcp is recently maintained — last commit was 71 days ago.

Similar servers

Others in data / devops

View all →

PostgreSQL MCP Server98

Query and manage PostgreSQL databases directly from AI assistants

86.4k 1

Mcp Gitlab96

MCP server for using the GitLab API

1.6k 12

Firecrawl Mcp Server95

🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.

6.4k 4

Supabase MCP Server95

Manage Supabase projects — databases, auth, storage, and edge functions

2.7k 4

MCP Security Weekly

Get CVE alerts and security updates for io.github.Aguantar/clickhouse-dataops-mcp and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

{ "mcpServers": { "clickhouse": { "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_PORT": "8123", "CLICKHOUSE_DATABASE": "cdc_pipeline" }, "command": "clickhouse-mcp-server" } } }

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

{ "mcpServers": { "clickhouse": { "command": "clickhouse-mcp-server", "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_PORT": "8123", "CLICKHOUSE_DATABASE": "cdc_pipeline" } } } }

Variable

Default

Description

CLICKHOUSE_HOST

localhost

ClickHouse HTTP host

CLICKHOUSE_PORT

8123

ClickHouse HTTP port

CLICKHOUSE_USER

default

ClickHouse username

CLICKHOUSE_PASSWORD

(empty)

ClickHouse password

CLICKHOUSE_DATABASE

cdc_pipeline

Default database

CLICKHOUSE_QUERY_TIMEOUT

30

Query timeout in seconds

Frequently Asked Questions

Is io.github.Aguantar/clickhouse-dataops-mcp safe to use?

io.github.Aguantar/clickhouse-dataops-mcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments.

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

io.github.Aguantar/clickhouse-dataops-mcp supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.

What can io.github.Aguantar/clickhouse-dataops-mcp do?

io.github.Aguantar/clickhouse-dataops-mcp provides 8 tools: ch_query, ch_explain_query, ch_table_schema, ch_pipeline_latency, ch_data_quality and 3 more. See the full tools list on the server page for descriptions and parameters.

What AI clients work with io.github.Aguantar/clickhouse-dataops-mcp?

io.github.Aguantar/clickhouse-dataops-mcp is compatible with claude-desktop, cursor, claude-code. It uses stdio transport.

Is io.github.Aguantar/clickhouse-dataops-mcp actively maintained?

io.github.Aguantar/clickhouse-dataops-mcp is recently maintained — last commit was 71 days ago.

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

Variable	Default	Description
`CLICKHOUSE_HOST`	`localhost`	ClickHouse HTTP host
`CLICKHOUSE_PORT`	`8123`	ClickHouse HTTP port
`CLICKHOUSE_USER`	`default`	ClickHouse username
`CLICKHOUSE_PASSWORD`	(empty)	ClickHouse password
`CLICKHOUSE_DATABASE`	`cdc_pipeline`	Default database
`CLICKHOUSE_QUERY_TIMEOUT`	`30`	Query timeout in seconds

License

MIT