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

MIT license

Stale

Last commit 240d ago

Works with most clients

Transport: stdio

8 tools · ~364 tok

Grade A · 0.2% of 200K ctx

MCPpedia last refreshed this data 2d ago

Edit this pageView history

io.github.Aguantar/clickhouse-dataops-mcp is an MCP server that DataOps ClickHouse MCP server with query optimization and pipeline monitoring. Its tool list has not been published yet over stdio, requires no API key, and scores 77/100 on MCPpedia's security, maintenance and efficiency rubric.

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

DataOps ClickHouse MCP server with query optimization and pipeline monitoring

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

77/100across 5 weighted dimensions

How we score →

0255075100

−23

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. Authentication requirements were not detected automatically - check the project's documentation before connecting in a shared environment. Licensed under MIT.
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 less actively maintained - last commit was 240 days ago.

Similar servers

Others in data / devops

View all →

Dbhub96

Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite

3.8k 2

Supabase MCP Server96

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

3.0k 4

Mcp Gitlab96

MCP server for using the GitLab API

2.1k 12

Vibe Assistant95

A cross-platform desktop application for managing AI Agents and MCP Servers. 一款用于管理AI智能体与MCP服务器的跨平台桌面应用程序。

169 3

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. Authentication requirements were not detected automatically - check the project's documentation before connecting in a shared environment. Licensed under MIT.

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 less actively maintained - last commit was 240 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