clickhouse-mcp
Provides tools for interacting with ClickHouse databases, including listing databases, listing tables, and executing SQL queries (read-only or read-write depending on access mode).
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
ClickHouse MCP (stackblaze fork)
Fork of ClickHouse/mcp-clickhouse for the kubero chat feature MCP broker. See FORK.md for divergence notes.
One long-lived Deployment per workload cluster serves every ClickHouseInstallation
add-on — the connection target arrives per request via HTTP headers, not at boot.
Tools (namespaced ch__* in chat)
Tool | Mode | Description |
| read | List all databases |
| read | List tables in a database (paginated) |
| read/write | Execute SQL ( |
chDB tools (run_chdb_select_query) are disabled in the kubero Deployment (CHDB_ENABLED=false).
Related MCP server: clickhouse-mcp-server
Kubero headers
X-Kubero-DB-URI: clickhouse://user:pass@clickhouse-<instance>.<ns>.svc.cluster.local:9000[/db]
X-Kubero-Access-Mode: restricted | unrestrictedPort 9000 in the URI is the CHI native port; the MCP connects over HTTP on 8123 on the same Service.
Run locally (stdio, single cluster)
export CLICKHOUSE_HOST=localhost
export CLICKHOUSE_USER=default
export CLICKHOUSE_PASSWORD=
export CLICKHOUSE_SECURE=false
export CLICKHOUSE_PORT=8123
uv run mcp-clickhouseRun like kubero (HTTP, connection-from-request)
uv run mcp-clickhouse \
--transport streamable-http \
--connection-from-request \
--streamable-http-host 0.0.0.0 \
--streamable-http-port 3010Container
docker build -t ghcr.io/stackblaze/clickhouse-mcp:local .
docker run --rm -p 3010:3010 ghcr.io/stackblaze/clickhouse-mcp:local \
--transport streamable-http \
--connection-from-request \
--streamable-http-host 0.0.0.0 \
--streamable-http-port 3010Image: ghcr.io/stackblaze/clickhouse-mcp:<tag>
Upstream docs
For full upstream configuration (auth providers, chDB, middleware hooks), see the original README.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Governed access to production AI-agent traces in an existing ClickHouse store.
Query Postgres, MySQL, SQL Server, Oracle, BigQuery, ClickHouse and Redshift from your AI client.
Multi-tenant database orchestration: isolated Postgres, MySQL, MongoDB, Redis tenants on demand.
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
AlicenseAqualityBmaintenanceClickHouse database integration with schema inspection and query capabilities3904Apache 2.0- AlicenseNot gradedqualityDmaintenanceEnables interaction with ClickHouse databases via MCP, providing tools to list databases and tables and execute safe SELECT, SHOW, and DESCRIBE queries.78 npmMIT
- AlicenseAqualityDmaintenanceEnables AI assistants to query and manage ClickHouse databases, supporting SELECT queries, DDL/DML statements, and metadata listing.54 npmMIT
- AlicenseAqualityBmaintenanceEnables querying ClickHouse databases using natural language with AI models, supporting multiple providers and access restrictions via per-call allow-lists.3118 PyPI1MIT