ClickHouse MCP Server

A Model Context Protocol server for ClickHouse. It lets an MCP-capable client (Claude Desktop, Claude Code, etc.) explore schemas, run analytical queries, and manage the database - with behaviour controlled entirely by flags. It runs locally over stdio via the published package.

People who work with clickhouse, olap and sql and want it reachable from Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-09-12 · ★ 2 · VERIFIED 2026-09-18

MIT · TypeScript servers · how we verify → /methodology

01 · Install ClickHouse

before you install - you'll need

Set CLICKHOUSE_MODE before connecting. CLICKHOUSE_URL, CLICKHOUSE_USER are optional or environment-specific per the README.

Claude Code

claude mcp add dockndevai-mcp-clickhouse -- npx -y @dockndevai/mcp-clickhouse

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "dockndevai-mcp-clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

repo age created 2026-08-23 - young repo, little track record yet

license MIT - declared in the repository

npm package @dockndevai/mcp-clickhouse - published under the repo owner's npm scope (@dockndevai)

registry namespace io.github.dockndevai is GitHub-verified and matches the repo owner

03 · What ClickHouse can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

Latest releases

v0.2.2 · 2026-09-12

v0.2.1 · 2026-09-09

v0.2.0 · 2026-09-09

04 · Who maintains ClickHouse

mcp-clickhouse is maintained by dockndevai. We track 15 MCP servers from dockndevai - 15 actively maintained, 13 combined GitHub stars, oldest repo from Aug 2026. Full record: all servers from dockndevai.

ossian-mcp Ask your own documents with citations, plus durable memory for agents. Safe by default. ★ 2

05 · Facts

repository: github.com/dockndevai/mcp-clickhouse
category: database - actively maintained as of 2026-09-18.
release cadence: 6 releases in the last 90 days (latest 2026-09-12)
registry: io.github.dockndevai/mcp-clickhouse (active, first published 2026-08-23 · 7 versions)
packages: npm:@dockndevai/mcp-clickhouse

06 · ClickHouse FAQ

What is ClickHouse?

Is ClickHouse still maintained?

Yes - as of 2026-09-18, its last commit was 2026-09-12 and it shipped 6 releases in the last 90 days. We re-verify nightly.

How do I install ClickHouse?

Run `npx -y @dockndevai/mcp-clickhouse`. The README documents 3 environment variables (CLICKHOUSE_URL, CLICKHOUSE_USER, CLICKHOUSE_MODE) to set first. Set CLICKHOUSE_MODE before connecting. CLICKHOUSE_URL, CLICKHOUSE_USER are optional or environment-specific per the README. You can also paste the ready-made client config above.

Does ClickHouse run locally?

Yes - it's a stdio server: it runs on your machine (via npx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to ClickHouse

Alternatives to ClickHouse

Maintained database servers if ClickHouse isn't the fit.

Pairs well with

Servers that cover what ClickHouse doesn't - only shown when the pairing reason fits the companion.

More database MCP servers · Open Food Facts · Postgres MCP · Metabase AI Assistant · Sql Server Rules · PostgreSQL (hardened, read-only)

More TypeScript MCP servers · Ossian MCP · Uxspot MCP · Conarium · Dollhouse MCP · Airtable · see all