ClickHouse MCP Server

Stabledatabase

★170 starsPythonClickHouse

About

Overview

The ClickHouse MCP Server enables AI agents to interact with ClickHouse, the open-source columnar database optimized for analytics. It provides tools for executing queries, listing databases and tables, and inspecting schemas. Ideal for real-time analytics, log analysis, and high-volume data processing scenarios.

Capabilities

Tools & Capabilities

⚡query

Execute a ClickHouse SQL query

⚡list_databases

List all databases

⚡list_tables

List tables in a database

⚡describe_table

Get the schema of a table

Setup

Installation

bash

Install

pip install mcp-clickhouse

Examples

Example Usage

javascript

Usage

{
  "mcpServers": {
    "clickhouse": {
      "command": "python",
      "args": ["-m", "mcp_clickhouse"],
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_PORT": "8123"
      }
    }
  }
}

Quick Info

AuthorClickHouse

LanguagePython

StatusStable

Stars★ 170

Last UpdatedFeb 12, 2026