ClickHouse
Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
Open the source (opens github.com) https://github.com/clickhouse/mcp-clickhouse
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: CLICKHOUSE_PASSWORD. Use a key with the least access you can.
What it is
MCP servers from io.github.ClickHouse.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
pypi package (stdio)
mcp-clickhouse@0.7.0
From the server's entry in the official MCP Registry
oci package (stdio)
ghcr.io/clickhouse/mcp-clickhouse:0.7.0
From the server's entry in the official MCP Registry
Settings it asks for
CLICKHOUSE_HOSTrequired · Hostname of the ClickHouse serverCLICKHOUSE_USERrequired · Username for ClickHouse authenticationCLICKHOUSE_PASSWORDsecret · Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS modeCLICKHOUSE_PORT· ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwiseCLICKHOUSE_SECURE· Use HTTPS to connect to ClickHouseCLICKHOUSE_VERIFY· Verify SSL certificatesCLICKHOUSE_CA_CERT· Path to a PEM CA bundle for ClickHouse server certificate verificationCLICKHOUSE_CLIENT_CERT· Path to a PEM client certificate for the ClickHouse HTTPS connectionCLICKHOUSE_CLIENT_CERT_KEY· Path to the PEM private key for CLICKHOUSE_CLIENT_CERTCLICKHOUSE_TLS_MODE· Client certificate mode: mutual, proxy, or strictCLICKHOUSE_DATABASE· Default database to useCLICKHOUSE_ROLE· ClickHouse role to activate for the session
Related
-
clickhouse-dataops-mcp
MCP serversDataOps ClickHouse MCP server with query optimization and pipeline monitoring
clickhouse-dataops-mcp@0.1.1 -
ClickHouse
MCP serversRead-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.
mcp-clickhousex@0.11.0 -
nightingale
MCP serversOpen-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.
git clone https://github.com/ccfos/nightingale.git -
mcp-clickhouse
MCP serversClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.
@dockndevai/mcp-clickhouse@0.3.0 -
mcp-clickhouse
MCP serversRead-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health.
@infoinlet/mcp-clickhouse@0.1.1 -
hypequery ClickHouse
MCP serversGoverned ClickHouse analytics for agents: named datasets and metrics as tools, never raw SQL.
@hypequery/mcp@0.14.0