Submit Log in

ClickHouse

by ClickHouse

v0.4.1

Repository Docs

Databases & Data

databaseanalyticsolapsql

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.

Open your agent's MCP configuration file.
Merge the snippet below into it, filling in the environment variables with your own values.
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": ""
      }
    }
  }
}

Claude Code

Add the server with a single CLI command.

claude mcp add clickhouse -e CLICKHOUSE_HOST=localhost -e CLICKHOUSE_USER=default -e CLICKHOUSE_PASSWORD= -- uvx mcp-clickhouse

Claude Desktop

Add the server to claude_desktop_config.json (Settings → Developer → Edit Config).

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_USER": "default",
        "CLICKHOUSE_PASSWORD": ""
      }
    }
  }
}

Cursor

{
  "command": "uvx",
  "args": [
    "mcp-clickhouse"
  ],
  "env": {
    "CLICKHOUSE_HOST": "localhost",
    "CLICKHOUSE_USER": "default",
    "CLICKHOUSE_PASSWORD": ""
  }
}

Windsurf

{
  "command": "uvx",
  "args": [
    "mcp-clickhouse"
  ],
  "env": {
    "CLICKHOUSE_HOST": "localhost",
    "CLICKHOUSE_USER": "default",
    "CLICKHOUSE_PASSWORD": ""
  }
}

VS Code

{
  "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: deja-vu

by Vladislav Shulcz

New

Indexes the coding-agent sessions already sitting on your disk — months of history from before you installed it — and serves them back over MCP. 3.5 GB searched in ~1.5 ms, no LLM, no embeddings.

Developer ToolsDatabases & Data

MCP: Weaviate MCP Server

by Weaviate

New

Weaviate's MCP server, built into the database itself — hybrid search, schema inspection, tenant listing and batch upserts at /v1/mcp, scoped by RBAC.

Databases & Data

MCP: MCP Toolbox for Databases

by Google

New

Google's open-source MCP server for enterprise databases — one binary that fronts AlloyDB, BigQuery, Spanner, Postgres, MySQL, Oracle, MongoDB, Snowflake and more.

Databases & DataCloud & Infrastructure

MCP: DBHub

by Bytebase

Featured

A universal database MCP server — one integration for PostgreSQL, MySQL, SQL Server, SQLite, and MariaDB.

Databases & Data

Browse all MCP servers →