ClickHouse MCP Server

MCP server by ClickHouse

OfficialLocal
Official page

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.

Install or connect
uv run --with mcp-clickhouse --python 3.10 mcp-clickhouse

What 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.

Tools it exposes include
run_querylist_databaseslist_tablesrun_chdb_select_query

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.