MCP Clickhouse MCP Server

by dockndevai Your server? Claim it

local only

MCP Clickhouse runs on your own machine — the client starts it, so there is no endpoint to ping. 95 installs a week from npm. Last commit 12 Oct 2026.

ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.

Installs per day peak 169 · avg 21 · -62% w/w

a month agotoday

Installs / week

npm · @dockndevai/mcp-clickhouse

Stars

2 open issues

12 Oct 2026

Last commit

8 releases in 90 days

MIT

License

TypeScript

Nothing serious here today

Today is the operative word: we check MCP Clickhouse every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

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

~/Library/Application Support/Claude/claude_desktop_config.json

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

~/.codex/config.toml

[mcp_servers.mcp-clickhouse]
command = "npx"
args = ["-y", "@dockndevai/mcp-clickhouse"]

.cursor/mcp.json

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

.vscode/mcp.json

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

This one needs environment variables set before it will start: CLICKHOUSE_URL (ClickHouse HTTP endpoint.), CLICKHOUSE_USER (ClickHouse user (prefer a read-only user).), CLICKHOUSE_PASSWORD (ClickHouse password.), CLICKHOUSE_MODE (Access mode: read-only | read-write | admin.). The author declared them in the registry entry; get the values from the project itself.

Alternatives to MCP Clickhouse

same job, measured the same way

Universal DB (read-only)

by alghanim

Read-only, guarded SQL access for AI agents: PostgreSQL, MySQL, ClickHouse, Oracle, SQL Server, Db2

local only

MCP Mysql

by infoinlet-marketplace

Read-only MySQL/MariaDB for AI agents — query, list/describe tables, health. SQL-guarded.

33 installs/wk local only

MCP Mongodb

by infoinlet-marketplace

Read-only MongoDB for AI agents — find, aggregate (no write stages), count, stats.

27 installs/wk local only

Mysql

by codechap

MCP server for MySQL/MariaDB — pooled async queries with destructive-query safety

local only

MCP Notion

by infoinlet-marketplace

Notion for AI agents — search, read pages/blocks, query databases, create pages.

24 installs/wk local only

Berth

by seayniclabs

Database management — query, schema inspection, migrations for PostgreSQL, MySQL, SQLite.

128 installs/wk local only

sqlglass

by s-curvelabs

SQL Server / Azure SQL for agents: real schema, lint, read-only runs, plans, write previews.

66 installs/wk local only

A2db

by agentic-eng

Safe, read-only database access for AI agents. 5 databases, batch queries, SQLGlot.

127 installs/wk local only

MCP Clickhouse — questions

Answers built from our own checks of this server.

Why is there no uptime for MCP Clickhouse?

MCP Clickhouse runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the npm package @dockndevai/mcp-clickhouse was installed 95 times last week.

How do I connect MCP Clickhouse?

Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls @dockndevai/mcp-clickhouse straight from npm; nothing to host, nothing to sign up for.

How many people use MCP Clickhouse?

The npm package @dockndevai/mcp-clickhouse was installed 95 times in the last week. Week over week that is -62%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is MCP Clickhouse open source?

Yes — it is published under the MIT licence, written in TypeScript, 3 stars on GitHub and 2 open issues. The source link is on this page, so you can read exactly what it does with your data before you connect it.