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

Envkit Releases

Env-Kit

EnvKit — free local development environment for Windows & macOS: nginx/Apache, multiple PHP versions, MySQL/MariaDB, PostgreSQL, Redis, MongoDB, Mailpit, Node.js, trusted .test HTTPS, and a built-in MCP server for AI-assistant control. A Laragon/XAMPP/Herd alternative.

621

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.