ClickHouse MCP Server

Provides AI assistants with a secure and structured way to explore and analyze ClickHouse databases.

Local serverstdioPython★ 8

What is the ClickHouse MCP Server?

Provides AI assistants with a secure and structured way to explore and analyze ClickHouse databases.

What it actually does

This server provides AI assistants with a secure and structured way to explore and analyze databases. It enables them to list tables, read data, and execute SQL queries through a controlled interface, ensuring responsible database access.

Configuration

  • Python with uv package manager - ClickHouse installation - MCP server dependencies

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Configuration

  • Python with uv package manager - ClickHouse installation - MCP server dependencies
VariableDescriptionRequired
CLICKHOUSE_HOSTEndpoint or connection string the server talks to.Optional
CLICKHOUSE_PORTConfiguration value read at startup.Optional
CLICKHOUSE_USERConfiguration value read at startup.Optional
CLICKHOUSE_PASSWORDConfiguration value read at startup.Optional
CLICKHOUSE_DATABASEConfiguration value read at startup.Optional

Frequently asked questions

You'll need Python with the `uv` package manager, a ClickHouse installation, and the MCP server dependencies. See the project's README for a complete list.