Skip to content
ClickHouse

ClickHouseMCP Server

by ClickHouse
Added to Onei
v0.4.1
Repository Docs
Databases & Data

Summary

ClickHouse's official MCP server — run analytical SQL, explore schemas, and query local files with chDB.

Features

  • Run analytical SQL against ClickHouse from an AI client
  • List databases and inspect table schemas
  • Includes chDB for querying local files without a server

Installation

Set up this MCP server in your favorite AI agent — copy a ready-made configuration below.

Any MCP-compatible agent

Most agents (Claude, Cursor, Windsurf, VS Code, and more) read a standard mcpServers configuration.

  1. Open your agent's MCP configuration file.
  2. Merge the snippet below into it, filling in the environment variables with your own values.
  3. Restart the agent — the "ClickHouse" tools will be available.
{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_USER": "default",
        "CLICKHOUSE_PASSWORD": ""
      }
    }
  }
}

Description

ClickHouse's official MCP server lets an assistant query a ClickHouse instance directly, which turns "what happened to conversion last week" into a real query against real data rather than a guess.

What it provides
  • SQL execution against your ClickHouse cluster, with results returned in a form the model can reason about
  • Schema discovery — list databases and tables, inspect column types, and understand partitioning before writing a query
  • chDB support for running ClickHouse SQL over local files (Parquet, CSV, JSON) with no server at all, which is remarkably useful for ad-hoc analysis
  • ClickHouse Cloud compatibility alongside self-managed deployments
Practical notes

Queries execute with the permissions of the configured user, so point it at a read-only account unless you have a specific reason not to. Query limits and timeouts are configurable to prevent an over-enthusiastic assistant from running a scan across a billion rows.

Installed with uvx mcp-clickhouse and configured through environment variables for host, user, and password.

Related MCP Servers

MCP: Apache Doris MCP Server

by The Apache Software Foundation

Apache's official read-only MCP server for Doris — eight tool domains and 55 progressively disclosed children covering catalog, query, cluster, lineage and lakehouse.

Databases & Data

MCP: InfluxDB 3 MCP Server

by InfluxData

Featured

InfluxData's official MCP server for InfluxDB 3 — schema discovery, bounded SQL and InfluxQL queries, line-protocol writes and token administration across Core, Enterprise and Cloud.

Databases & Data
Browse all MCP servers →