ClickHouse MCP server

What it does

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

Description as published by the publisher in the official MCP Registry, read 10 Oct 2026. Not written or verified by Few Servers.

Facts

Install

• PyPI package, as published: mcp-clickhouse · version 0.7.0 · transport stdio

  uvx mcp-clickhouse

  Standard run command for PyPI packages. The registry publishes the package name, not a command; check the repository for required arguments.
• Docker package, as published: ghcr.io/clickhouse/mcp-clickhouse:0.7.0 · transport stdio

  docker run -i --rm ghcr.io/clickhouse/mcp-clickhouse:0.7.0

  Standard run command for Docker packages. The registry publishes the package name, not a command; check the repository for required arguments.

Install details read from the registry record on 12 Oct 2026. We have not run this server.

Keys and settings

The registry record declares a secret value (a key or token) that is not marked required. Declared by the publisher:

• CLICKHOUSE_HOST (environment variable, required): Hostname of the ClickHouse server
• CLICKHOUSE_USER (environment variable, required): Username for ClickHouse authentication
• CLICKHOUSE_PASSWORD (environment variable, secret, not marked required): Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode
• CLICKHOUSE_PORT (environment variable, not marked required): ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise
• CLICKHOUSE_SECURE (environment variable, not marked required): Use HTTPS to connect to ClickHouse
• CLICKHOUSE_VERIFY (environment variable, not marked required): Verify SSL certificates
• CLICKHOUSE_CA_CERT (environment variable, not marked required): Path to a PEM CA bundle for ClickHouse server certificate verification
• CLICKHOUSE_CLIENT_CERT (environment variable, not marked required): Path to a PEM client certificate for the ClickHouse HTTPS connection
• CLICKHOUSE_CLIENT_CERT_KEY (environment variable, not marked required): Path to the PEM private key for CLICKHOUSE_CLIENT_CERT
• CLICKHOUSE_TLS_MODE (environment variable, not marked required): Client certificate mode: mutual, proxy, or strict
• CLICKHOUSE_DATABASE (environment variable, not marked required): Default database to use
• CLICKHOUSE_ROLE (environment variable, not marked required): ClickHouse role to activate for the session
• CLICKHOUSE_ALLOW_WRITE_ACCESS (environment variable, not marked required): Allow write operations (DDL and DML). Queries run read-only by default
• CLICKHOUSE_ALLOW_DROP (environment variable, not marked required): Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled
• CLICKHOUSE_MCP_QUERY_TIMEOUT (environment variable, not marked required): Query tool timeout in seconds
• CLICKHOUSE_MCP_MAX_WORKERS (environment variable, not marked required): Maximum query worker thread pool size

Links

RepositoryWebsiteRegistry record (JSON)PyPI package

Being listed is not a safety check. Read the repository and check what a server asks for before you connect it. How the directory works.