← all integrations

integrations/clickhouse-mcp

ClickHouse MCP Server mcp

List databases and tables and run SQL on a ClickHouse cluster, with every query sent as readonly=1.

Third-party software. Forgeprint hosts none of this code: it is an installation recipe for a project somebody else publishes and maintains. Review the permissions below before installing.

Upstream

What it can reach

Reads every database and table the ClickHouse user can read and runs SQL with the readonly=1 setting; it writes only if CLICKHOUSE_ALLOW_WRITE_ACCESS is set to true, which these commands do not.

It needs CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD. Create it at the upstream with the narrowest scope that works and put it in your environment — an agent never enters a secret for you.

Install

Claude Code

claude mcp add-json clickhouse '{"command":"uvx","args":["mcp-clickhouse==0.7.0"],"env":{"CLICKHOUSE_HOST":"${CLICKHOUSE_HOST}","CLICKHOUSE_USER":"${CLICKHOUSE_USER}","CLICKHOUSE_PASSWORD":"${CLICKHOUSE_PASSWORD}","CLICKHOUSE_ALLOW_WRITE_ACCESS":"false"}}'

Codex CLI

codex mcp add clickhouse --env "CLICKHOUSE_HOST=$CLICKHOUSE_HOST" --env "CLICKHOUSE_USER=$CLICKHOUSE_USER" --env "CLICKHOUSE_PASSWORD=$CLICKHOUSE_PASSWORD" --env "CLICKHOUSE_ALLOW_WRITE_ACCESS=false" -- uvx mcp-clickhouse==0.7.0

Gemini CLI

gemini mcp add clickhouse -e 'CLICKHOUSE_HOST=$CLICKHOUSE_HOST' -e 'CLICKHOUSE_USER=$CLICKHOUSE_USER' -e 'CLICKHOUSE_PASSWORD=$CLICKHOUSE_PASSWORD' -e 'CLICKHOUSE_ALLOW_WRITE_ACCESS=false' uvx mcp-clickhouse==0.7.0

Only agents whose command syntax has been verified are listed. A missing agent is one nobody has confirmed, not one that does not work.

Read it

README.md