mcp-clickhouse

ClickHouse

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

stdioofficialapplication

Package Details

mcp-clickhouse

0.4.1•https://pypi.org/project/mcp-clickhouse

Transportstdio

Runtimeuvx

Environment Variables

CLICKHOUSE_HOST

Required

Hostname of the ClickHouse server

CLICKHOUSE_USER

Required

Username for ClickHouse authentication

CLICKHOUSE_PASSWORD

RequiredSecret

Password for ClickHouse authentication

CLICKHOUSE_PORT

ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise

CLICKHOUSE_SECURE(bool)

Default:true

Use HTTPS to connect to ClickHouse

CLICKHOUSE_VERIFY(bool)

Default:true

Verify SSL certificates

CLICKHOUSE_DATABASE

Default database to use

CLICKHOUSE_ROLE

ClickHouse role to activate for the session

CLICKHOUSE_ALLOW_WRITE_ACCESS(bool)

Default:false

Allow write operations (DDL and DML). Queries run read-only by default

CLICKHOUSE_ALLOW_DROP(bool)

Default:false

Allow destructive operations (DROP, TRUNCATE) when write access is also enabled

CLICKHOUSE_MCP_QUERY_TIMEOUT(num)

Default:30

Query tool timeout in seconds

ghcr.io/clickhouse/mcp-clickhouse:0.4.1

https://github.com/clickhouse/mcp-clickhouse/pkgs/container/mcp-clickhouse

Transportstdio

Environment Variables

CLICKHOUSE_HOST

Required

Hostname of the ClickHouse server

CLICKHOUSE_USER

Required

Username for ClickHouse authentication

CLICKHOUSE_PASSWORD

RequiredSecret

Password for ClickHouse authentication

CLICKHOUSE_PORT

ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise

CLICKHOUSE_SECURE(bool)

Default:true

Use HTTPS to connect to ClickHouse

CLICKHOUSE_VERIFY(bool)

Default:true

Verify SSL certificates

CLICKHOUSE_DATABASE

Default database to use

CLICKHOUSE_ROLE

ClickHouse role to activate for the session

CLICKHOUSE_ALLOW_WRITE_ACCESS(bool)

Default:false

Allow write operations (DDL and DML). Queries run read-only by default

CLICKHOUSE_ALLOW_DROP(bool)

Default:false

Allow destructive operations (DROP, TRUNCATE) when write access is also enabled

CLICKHOUSE_MCP_QUERY_TIMEOUT(num)

Default:30

Query tool timeout in seconds