What can you do with this server?

The ClickHouse MCP Server allows interaction with a ClickHouse cluster to execute SQL queries and manage database objects. * Execute SQL Queries: Run run_select_query to execute read-only SQL queries on the ClickHouse cluster. * List Databases: Use list_databases to fetch all databases in the cluster. * List Tables: Use list_tables to retrieve tables within a specific database, with optional filtering.

Which integrations are available for this server?

Allows querying and interacting with ClickHouse databases, providing tools for executing SQL select queries, listing databases, and viewing tables within a database.

How do I use ClickHouse MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@ClickHouse MCP Server show me the top 10 customers by total sales" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

ClickHouse MCP Server

Migrated to https://github.com/ClickHouse/mcp-clickhouse

An MCP server for ClickHouse.

Features

Tools

run_select_query
- Execute SQL queries on your ClickHouse cluster.
- Input: sql (string): The SQL query to execute.
- All ClickHouse queries are run with readonly = 1 to ensure they are safe.
list_databases
- List all databases on your ClickHouse cluster.
list_tables
- List all tables in a database.
- Input: database (string): The name of the database.

Related MCP server: mcp-clickup

Configuration

Note: This is a temporary configuration process that will be significantly improved once the package is published.

Run uv sync to install the dependencies. To install uv follow the instructions here. Then do source .venv/bin/activate.
Setup the .env.production file with the ClickHouse credentials.

CLICKHOUSE_HOST=<CLICKHOUSE_HOST>
CLICKHOUSE_PORT=<CLICKHOUSE_PORT>
CLICKHOUSE_USER=<CLICKHOUSE_USER>
CLICKHOUSE_PASSWORD=<CLICKHOUSE_PASSWORD>

Run fastmcp install mcp_clickhouse/mcp_server.py -f .env.production to install the server.
Restart Claude Desktop.

Development

In test-services directory run docker compose up -d to start the ClickHouse cluster.
Add the following variables to a .env file in the root of the repository.

CLICKHOUSE_HOST=localhost
CLICKHOUSE_PORT=8123
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=clickhouse

Run uv sync to install the dependencies. To install uv follow the instructions here. Then do source .venv/bin/activate.
For easy testing, you can run fastmcp dev mcp_clickhouse/mcp_server.py to start the MCP server.