Server data from the Official MCP Registry
DataOps ClickHouse MCP server with query optimization and pipeline monitoring
DataOps ClickHouse MCP server with query optimization and pipeline monitoring
Valid MCP server (1 strong, 4 medium validity signals). 3 known CVEs in dependencies (0 critical, 3 high severity) Package registry verified. Imported from the Official MCP Registry.
12 files analyzed · 4 issues found
Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.
Set these up before or after installing:
Environment variable: CLICKHOUSE_HOST
Environment variable: CLICKHOUSE_PORT
Environment variable: CLICKHOUSE_PASSWORD
Add this to your MCP configuration file:
{
"mcpServers": {
"io-github-aguantar-clickhouse-dataops-mcp": {
"env": {
"CLICKHOUSE_HOST": "your-clickhouse-host-here",
"CLICKHOUSE_PORT": "your-clickhouse-port-here",
"CLICKHOUSE_PASSWORD": "your-clickhouse-password-here"
},
"args": [
"clickhouse-dataops-mcp"
],
"command": "uvx"
}
}
}From the project's GitHub README.
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.
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 warningsch_explain_query — EXPLAIN-based analysis with optimization suggestionsch_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 checksch_slow_queries — Slow query detection with root cause diagnosisch_disk_usage — Disk analysis with TTL and optimization recommendationsch_list_tables — Table catalog with built-in descriptionsAll queries are read-only. DDL/DML operations are blocked at the SQL validation layer:
DROP, TRUNCATE, DELETE, ALTER, INSERT, UPDATE, CREATE, etc.; separator)pip install clickhouse-dataops-mcp
Add to your .mcp.json:
{
"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 |
MIT
Be the first to review this server!
by Toleno · Developer Tools
Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.
by mcp-marketplace · Developer Tools
Create, build, and publish Python MCP servers to PyPI — conversationally.
by Microsoft · Content & Media
Convert files (PDF, Word, Excel, images, audio) to Markdown for LLM consumption
by mcp-marketplace · Developer Tools
Scaffold, build, and publish TypeScript MCP servers to npm — conversationally
by mcp-marketplace · Finance
Free stock data and market news for any MCP-compatible AI assistant.
by Taylorwilsdon · Productivity
Control Gmail, Calendar, Docs, Sheets, Drive, and more from your AI