Skip to content
AgentAtlas

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
Full steps for Claude Code →

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)

run_select_querylist_databaseslist_tablesget_organizationsget_organization_detailsget_services_listget_service_detailslist_service_backupsget_service_backup_detailsget_service_backup_configurationlist_clickpipesget_clickpipeget_organization_cost

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 →