ClickHouse for Claude Code

io.github.clickhouse/mcp-clickhouse

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

client:Claude Code transport:stdio runtime:pypi

Install ClickHouse in Claude Code

run in your project directory

CLICKHOUSE_HOST

CLICKHOUSE_USER

CLICKHOUSE_PASSWORD

CLICKHOUSE_PORT

CLICKHOUSE_SECURE

CLICKHOUSE_VERIFY

CLICKHOUSE_CA_CERT

CLICKHOUSE_CLIENT_CERT

CLICKHOUSE_CLIENT_CERT_KEY

CLICKHOUSE_TLS_MODE

CLICKHOUSE_DATABASE

CLICKHOUSE_ROLE

CLICKHOUSE_ALLOW_WRITE_ACCESS

CLICKHOUSE_ALLOW_DROP

CLICKHOUSE_MCP_QUERY_TIMEOUT

CLICKHOUSE_MCP_MAX_WORKERS

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

claude mcp add mcp-clickhouse -e CLICKHOUSE_HOST=<CLICKHOUSE_HOST> -e CLICKHOUSE_USER=<CLICKHOUSE_USER> -e CLICKHOUSE_PASSWORD=<CLICKHOUSE_PASSWORD> -e CLICKHOUSE_PORT=<CLICKHOUSE_PORT> -e CLICKHOUSE_SECURE=<CLICKHOUSE_SECURE> -e CLICKHOUSE_VERIFY=<CLICKHOUSE_VERIFY> -e CLICKHOUSE_CA_CERT=<CLICKHOUSE_CA_CERT> -e CLICKHOUSE_CLIENT_CERT=<CLICKHOUSE_CLIENT_CERT> -e CLICKHOUSE_CLIENT_CERT_KEY=<CLICKHOUSE_CLIENT_CERT_KEY> -e CLICKHOUSE_TLS_MODE=<CLICKHOUSE_TLS_MODE> -e CLICKHOUSE_DATABASE=<CLICKHOUSE_DATABASE> -e CLICKHOUSE_ROLE=<CLICKHOUSE_ROLE> -e CLICKHOUSE_ALLOW_WRITE_ACCESS=<CLICKHOUSE_ALLOW_WRITE_ACCESS> -e CLICKHOUSE_ALLOW_DROP=<CLICKHOUSE_ALLOW_DROP> -e CLICKHOUSE_MCP_QUERY_TIMEOUT=<CLICKHOUSE_MCP_QUERY_TIMEOUT> -e CLICKHOUSE_MCP_MAX_WORKERS=<CLICKHOUSE_MCP_MAX_WORKERS> -- uvx mcp-clickhouse

Adds it for this project only. Append --scope user to make it available everywhere. Claude Code docs

ClickHouse in other clients

ClickHouse MCP server