ClickHouse MCP Server

@dubin555

Repository

Basic information

About ClickHouse MCP Server

No overview available yet

ClickHouse MCP Server 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

ClickHouse MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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.

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

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.

Comments

More Databases MCP servers

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K