ClickHouse MCP Server

@dubin555

Repository

About ClickHouse MCP Server

No overview available yet

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is ClickHouse MCP Server?

A Model Context Protocol (MCP) server implementation for ClickHouse. It provides AI assistants with a secure and structured way to explore and analyze databases, allowing them to list tables, read data, and execute SQL queries through a controlled interface.

How to use ClickHouse MCP Server?

Configure via environment variables (CLICKHOUSE_HOST, CLICKHOUSE_PORT, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_DATABASE) or equivalent command-line arguments. Add the server to an MCP client (e.g., Cline extension in VS Code) using uv with the path to the server directory.

Key features of ClickHouse MCP Server?

List tables and read data from ClickHouse.
Execute SQL queries through a controlled interface.
Secure database access with user/password authentication.
Configurable via environment variables or command-line args.
Uses ClickHouse HTTP API on port 8123.

Use cases of ClickHouse MCP Server?

AI assistants answering business questions by querying ClickHouse.
Natural language exploration of database schemas and data.
Automated data analysis and reporting via conversational AI.
Safe read-only (or controlled write) database access for LLMs.

FAQ from ClickHouse MCP Server?

What are the prerequisites?

Python with the uv package manager, a running ClickHouse instance, and MCP server dependencies.

How do I configure the connection to ClickHouse?

Set the environment variables CLICKHOUSE_HOST, CLICKHOUSE_PORT, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, and CLICKHOUSE_DATABASE, or pass them as command-line arguments (--host, --port, etc.).

How do I integrate this server with an AI assistant?

Add the server configuration to your MCP client (e.g., the Cline extension in VS Code) using the provided JSON example with the uv command.

What transport protocol does the server use to connect to ClickHouse?

It connects to ClickHouse via HTTP on the default port 8123.

Is authentication supported?

Yes, the server supports ClickHouse user/password authentication via the CLICKHOUSE_USER and CLICKHOUSE_PASSWORD settings.

Frequently asked questions

What are the prerequisites?

Python with the `uv` package manager, a running ClickHouse instance, and MCP server dependencies.

How do I configure the connection to ClickHouse?

Set the environment variables `CLICKHOUSE_HOST`, `CLICKHOUSE_PORT`, `CLICKHOUSE_USER`, `CLICKHOUSE_PASSWORD`, and `CLICKHOUSE_DATABASE`, or pass them as command-line arguments (`--host`, `--port`, etc.).