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.
