mcpbeat Sign in

ClickHouse MCP Server

local only

ClickHouse runs on your own machine — the client starts it, so there is no endpoint to ping. 127 installs a week from pypi. Last commit 18 Sep 2026.

Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.

Installs per day peak 87 · avg 28 · -43% w/w
a month agotoday
127
Installs / week
pypi · mcp-clickhousex
0
Stars
0 open issues
18 Sep 2026
Last commit
0 releases in 90 days
MIT
License
Python

What the code does

We read the source, 21 h ago · rules 3dff92dd89df

Evidence

Things with no honest explanation: a promise that contradicts the code, code that runs at install time while hiding what it does, data leaving the machine.

Name looks like a popular package mcp-clickhouse
mcp-clickhousex похож на mcp-clickhouse
Capabilities

What this server is able to do. For an MCP server this is often the job itself — a terminal server runs commands because that is what it is for. Listed so you know what you are plugging in, not as an accusation.

File ships in the package but is absent from the source [пакет] src/mcp_clickhousex/cluster_properties.py:1, [пакет] src/mcp_clickhousex/metadata.py:1
этот файл ставится пользователю, но в репозитории его нет

Is this your server and something here is wrong? Tell us — corrections are free and do not require a plan.

We found things in this code

Code changes quietly between releases, and nobody reads the diff of a dependency. We do, on every release — watch ClickHouse and you get told the day something new turns up.

Three servers free · no card

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.

run in your terminal
claude mcp add mcp-clickhousex -- uvx mcp-clickhousex
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "mcp-clickhousex": {
      "args": [
        "mcp-clickhousex"
      ],
      "command": "uvx"
    }
  }
}
~/.codex/config.toml
[mcp_servers.mcp-clickhousex]
command = "uvx"
args = ["mcp-clickhousex"]
.cursor/mcp.json
{
  "mcpServers": {
    "mcp-clickhousex": {
      "args": [
        "mcp-clickhousex"
      ],
      "command": "uvx"
    }
  }
}
.vscode/mcp.json
{
  "mcpServers": {
    "mcp-clickhousex": {
      "args": [
        "mcp-clickhousex"
      ],
      "command": "uvx"
    }
  }
}

This one needs environment variables set before it will start: MCP_CLICKHOUSE_DSN (Optional shortcut DSN for the default profile, for example http://user:password@host:8123/database. For multiple profiles, use ~/.config/mcp-clickhousex/config.json or MCP_CLICKHOUSE_PROFILES_<NAME>_DSN.). The author declared them in the registry entry; get the values from the project itself.

Alternatives to ClickHouse

same job, measured the same way
SqlServerMcp
by nithish1206

MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis

local only
MySQL MCP
by gistrec

MCP server for one MySQL database: schema, read-only queries and guarded writes.

27 installs/wk local only
1C OData MCP
by alexgrebeshok-coder

Read-only MCP server for 1C:Enterprise via OData with metadata and query builder tools.

35 installs/wk local only
Read Only Local Mysql MCP Server
by hove

MCP server for read-only MySQL database queries in Claude Desktop

264 installs/wk local only
C
Read Only Mysql MCP Server
by hove

MCP server for read-only MySQL database queries in Claude Desktop

local only
Read Only Local Postgres MCP Server
by hove

MCP server for read-only PostgreSQL database queries in Claude Desktop

159 installs/wk local only
MCP Clickhouse
by infoinlet-marketplace

Read-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health.

29 installs/wk local only
SEO Tools: Yandex.Webmaster
by antohins

MCP server for Yandex.Webmaster search queries (read-only).

77 installs/wk local only

ClickHouse — questions

Answers built from our own checks of this server.

Why is there no uptime for ClickHouse?
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 pypi package mcp-clickhousex was installed 127 times last week.
How do I connect 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 mcp-clickhousex straight from pypi; nothing to host, nothing to sign up for.
How many people use ClickHouse?
The pypi package mcp-clickhousex was installed 127 times in the last week. Week over week that is -43%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.
Is ClickHouse open source?
Yes — it is published under the MIT licence, written in Python and 0 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.