# ClickHouse MCP server

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

## Links
- Registry page: https://www.getdrio.com/mcp/io-github-clickhouse-mcp-clickhouse
- Repository: https://github.com/ClickHouse/mcp-clickhouse
- Website: https://clickhouse.com

## Install
- Command: `uvx mcp-clickhouse`
- Auth: Auth required by registry metadata

## Setup notes
- Package: Pypi mcp-clickhouse v0.4.1
- Environment variable: CLICKHOUSE_HOST (required)
- Environment variable: CLICKHOUSE_USER (required)
- Environment variable: CLICKHOUSE_PASSWORD (required; secret)
- Environment variable: CLICKHOUSE_PORT
- Environment variable: CLICKHOUSE_SECURE (default true)
- Environment variable: CLICKHOUSE_VERIFY (default true)
- Environment variable: CLICKHOUSE_DATABASE
- Environment variable: CLICKHOUSE_ROLE
- Environment variable: CLICKHOUSE_ALLOW_WRITE_ACCESS (default false)
- Environment variable: CLICKHOUSE_ALLOW_DROP (default false)
- Environment variable: CLICKHOUSE_MCP_QUERY_TIMEOUT (default 30)
- Package: Oci ghcr.io/clickhouse/mcp-clickhouse:0.4.1
- Environment variable: CLICKHOUSE_HOST (required)
- Environment variable: CLICKHOUSE_USER (required)
- Environment variable: CLICKHOUSE_PASSWORD (required; secret)
- Environment variable: CLICKHOUSE_PORT
- Environment variable: CLICKHOUSE_SECURE (default true)
- Environment variable: CLICKHOUSE_VERIFY (default true)
- Environment variable: CLICKHOUSE_DATABASE
- Environment variable: CLICKHOUSE_ROLE
- Environment variable: CLICKHOUSE_ALLOW_WRITE_ACCESS (default false)
- Environment variable: CLICKHOUSE_ALLOW_DROP (default false)
- Environment variable: CLICKHOUSE_MCP_QUERY_TIMEOUT (default 30)
- The upstream registry signals required auth or secrets.

## Tools
Not captured

## Resources
Not captured

## Prompts
Not captured

## Metadata
- Owner: io.github.ClickHouse
- Version: 0.4.1
- Runtime: Pypi, Oci
- Transports: STDIO
- License: Not captured
- Language: Not captured
- Stars: Not captured
- Updated: Jul 17, 2026
- Source: https://registry.modelcontextprotocol.io