ClickHouse

latest · 0.6.0

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

GitHub: ClickHouse/mcp-clickhouse
Homepage: clickhouse.com
PyPI: mcp-clickhouse
MCP registry: io.github.clickhouse/mcp-clickhouse

Install

Needs env vars: CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD — replace the <placeholders> with your values.

claude mcp add io-github-clickhouse-mcp-clickhouse --env CLICKHOUSE_HOST=<CLICKHOUSE_HOST> --env CLICKHOUSE_USER=<CLICKHOUSE_USER> --env CLICKHOUSE_PASSWORD=<CLICKHOUSE_PASSWORD> -- uvx mcp-clickhouse

/mcp confirms it's connected.

Install

Or add it manually in ~/.cursor/mcp.json:

{
  "mcpServers": {
    "io-github-clickhouse-mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

In claude_desktop_config.json (Settings → Developer → Edit Config), then restart:

{
  "mcpServers": {
    "io-github-clickhouse-mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Config entry, any MCP client:

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

Community score

Community75/ 100

from web signals · no reviews yet · 4 mentions · 13 reactions (community v3)

Mentions (reaction sentiment)100/100 · 20% of the weight
Web signals (ecosystem baseline)69/100 · 80% of the weight

Used it? Rate v0.6.0

No reviews yet — be the first.

What the web says

Ecosystem baseline69/ 100

Objective public usage & activity (formula v3) — the community score's web-signals input, and its own sort.

GitHubsource ↗

GitHub stars · 26 days ago: ★ 879
Last commit · 26 days ago: 3 days ago
Issue close rate · 26 days ago: 94%
Release cadence · 26 days ago: about every 44 days
Latest release · 26 days ago: v0.7.0
License · 26 days ago: Apache-2.0

Packages

No package-registry data collected yet.

Listed on

Glama · 7 days ago: Listed · Glama quality score 4.2 ↗

Mentions

Quotes12

A new JSON data type for ClickHouse ↗
Hacker News · @markhneedham · 382 points
ClickHouse gets lazier and faster: Introducing lazy materialization ↗
Hacker News · @tbragin · 366 points
Andy Pavlo joins ClickHouse to establish ClickHouse Labs ↗
Hacker News · @nikolay_sivko · 340 points
Ten years of ClickHouse in open source ↗
Hacker News · @saisrirampur · 329 points
Show HN: ClickHouse-local – a small tool for serverless data analytics ↗
Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: <a href="https://github.com/Clic…
Hacker News · @zX41ZdbW · 289 points
Grafana MCP plus Clickhouse really making it easy to put dashboards together these days huh... Here's a quick overview of the AT Proto ecosystem over the past 24 hours. ↗
Bluesky · @jaz.sh · 99 likes
Claude Code with Opus 4.5 with access to the Grafana MCP and Clickhouse MCP in my personal monorepo so it can browse the schemas to design queries and dashboards. It also looks at my other dashboards to inherit best practices. The Grafana M… ↗
Bluesky · @jaz.sh · 8 likes
Add Claude Code Plugin / Marketplace ↗
To aide distribution, it would help to enable your MCP server to be installed to Claude Code via the plugin system. See Docker's example - the key being the marketplace.json file. This tells Claude that you have "plugins", and how to instal…
GitHub issue · @joesaunderson · 5 reactions · 100% positive
Another Humans of the Data Sphere is out, with issue 10! In this issue people are talking fsyncs, tips for running ClickHouse at scale, the problems with MCP and more. Plus I dig up a classic paper from 1962. www.hotds.dev/p/humans-of-... ↗
Bluesky · @vanlightly.bsky.social · 5 likes
the minimum ClickHouse version requirements? ↗
Got DB::Exception: Missing columns: 'total_bytes_uncompressed' while processing query
GitHub issue · @XUJiahua · 4 reactions · 100% positive
Heads-up: 3 patched fastmcp CVEs (+ 1 transitive diskcache RCE) flagged in scans of mcp-clickhouse==0.3.0 ↗
Filing as awareness — no specific ask from you, just FYI in case it's useful for prioritising a fastmcp bump. Findings A container image vulnerability scan (AWS Inspector / ECR) on mcp-clickhouse==0.3.0 (which resolves to fastmcp==2.14.7 an…
GitHub issue · @abel-workera · 2 reactions · 100% positive
Latest Docker image (mcp/clickhouse:latest) fails with "Illegal instruction (core dumped)" due to over-optimized build ↗
Hello, I encountered an immediate crash when trying to run the mcp/clickhouse:latest Docker image (https://hub.docker.com/r/mcp/clickhouse) on a standard x86_64 server. 1. Observed Behavior: The container immediately exits with Exit Code 13…
GitHub issue · @Ecauchy · 2 reactions · 100% positive

Docs & livenesssource ↗

Namespace · 20 days ago: Registry-verified
Listing completeness · 20 days ago: 100%

Version history1

0.6.02026-09-03

Badge for your README

Shows this page's community score and its sample, kept current, and links readers here to review.

[![rateme12 community score](https://api.rateme12.com/servers/0c3a87fe-8b0d-4fdc-aa53-2aab518a7835/badge.svg)](https://rateme12.com/servers/0c3a87fe-8b0d-4fdc-aa53-2aab518a7835)

Details

Transport: stdio
Status: listed
Source: Imported from the MCP registry
Repository: source ↗
Homepage: site ↗