Official server by ClickHouse
ClickHouse MCP server
Query and explore ClickHouse clusters and chDB.
Install
Pick your agent and copy one line. Remote servers ask you to sign in on first use.
claude mcp add clickhouse -e CLICKHOUSE_HOST=YOUR_VALUE -e CLICKHOUSE_USER=YOUR_VALUE -- uvx mcp-clickhouse
# ~/.codex/config.toml [mcp_servers.clickhouse] command = "uvx" args = ["mcp-clickhouse"] [mcp_servers.clickhouse.env] CLICKHOUSE_HOST = "<your CLICKHOUSE_HOST>" CLICKHOUSE_USER = "<your CLICKHOUSE_USER>"
gemini mcp add -e CLICKHOUSE_HOST=YOUR_VALUE -e CLICKHOUSE_USER=YOUR_VALUE clickhouse uvx mcp-clickhouse
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
"CLICKHOUSE_USER": "<your CLICKHOUSE_USER>"
}
}
}
}code --add-mcp '{"name":"clickhouse","command":"uvx","args":["mcp-clickhouse"],"env":{"CLICKHOUSE_HOST":"<your CLICKHOUSE_HOST>","CLICKHOUSE_USER":"<your CLICKHOUSE_USER>"}}'Comparing options? Database MCP servers compared →
What it can do
From ClickHouse's own MCP documentation.
Sign in
Cloud remote server: OAuth 2.0 with ClickHouse Cloud credentials, or a ClickHouse Cloud API key sent as HTTP Basic auth (key ID and secret). Open-source server: CLICKHOUSE_HOST, CLICKHOUSE_USER and CLICKHOUSE_PASSWORD env vars.
Tools (13)
Options
- Remote MCP must be turned on per service in the Cloud console (Connect, then MCP).
- Open-source server mcp-clickhouse runs locally with tools run_query, list_databases, list_tables and run_chdb_select_query.
- Open-source writes need CLICKHOUSE_ALLOW_WRITE_ACCESS=true. Destructive statements also need CLICKHOUSE_ALLOW_DROP=true.
- CHDB_ENABLED=true turns on the embedded chDB engine.
- CLICKHOUSE_MCP_QUERY_TIMEOUT sets the query timeout (default 30 seconds).
Good to know
- Every remote tool is read-only. run_select_query only runs SELECT queries.
- Turning remote MCP on or off needs the control-plane:service:manage-mcp permission.
- get_organization_cost covers at most a 31-day range.
- The remote server only works with ClickHouse Cloud services. Use the open-source server for self-hosted ClickHouse.
- Open-source server is read-only by default, enforced with readonly=1.
Details
- Registry name
- io.github.ClickHouse/mcp-clickhouse
- Latest version
- 0.7.0 (updated 2026-09-21)
- Packages
mcp-clickhouse (pypi)
ghcr.io/clickhouse/mcp-clickhouse:0.7.0 (oci)
- Links
- ClickHouse docsSource
More in Databases
Reviewed Oct 21, 2026. Official means published under ClickHouse's namespace in the MCP registry. It is not a security audit.
Built an MCP server? Get it listed everywhere →
Shipping an Android app? Google Play needs 12 testers for 14 days first. Get them with Tester Exchange →