Lets an AI assistant query many databases through prebuilt or custom SQL tools.
ClickHouse MCP Server
MCP server by ClickHouse
ClickHouse MCP Server at a glance
ClickHouse MCP Server is an official MCP server from ClickHouse. It lets an AI assistant list ClickHouse databases and tables and run SQL queries.
- Connects to
- Data and databases
- Hosting
- Local · stdio, Streamable HTTP and SSE
- Sign-in
- Database user and password
- Price
- Free
- Works with
- Claude Desktop
- Best for
- Analysts and engineers using ClickHouse
- Checked
- October 3, 2026 on official sources
How to install ClickHouse MCP Server
Add the command below as a new MCP server in your AI app’s settings or MCP config file. Sign-in: Database user and password.
uv run --with mcp-clickhouse --python 3.10 mcp-clickhouseWhat ClickHouse MCP Server can do
It connects an AI assistant to a ClickHouse cluster so it can browse databases and tables and run SQL. It can also query data with the embedded chDB engine when that option is turned on.
Best for: analysts and engineers using ClickHouse
Pros
- Read-only by default
- Optional embedded chDB engine
- Simple small tool set
Cons
- Few tools beyond SQL
- Setup uses environment variables
ClickHouse MCP Server FAQ
Is ClickHouse MCP Server free?
Yes. It is free and open source under Apache-2.0.
How do I connect ClickHouse MCP Server?
Run uv run –with mcp-clickhouse –python 3.10 mcp-clickhouse and set CLICKHOUSE_HOST, CLICKHOUSE_USER and CLICKHOUSE_PASSWORD.
What can ClickHouse MCP Server do?
It can list databases and tables and run SQL queries on ClickHouse or the embedded chDB engine.