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. 129 installs a week from pypi. Last commit 13 Oct 2026.

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

Installs per day peak 125 · avg 35 · -25% w/w
a month agotoday
129
Installs / week
pypi · mcp-clickhousex
1
Stars
0 open issues
13 Oct 2026
Last commit
from GitHub
MIT
License
Python

What the code does

We read the source, 4 d ago · rules 995398eba69f

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

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": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ]
    }
  }
}
~/.codex/config.toml
[mcp_servers.mcp-clickhousex]
command = "uvx"
args = ["mcp-clickhousex"]
.cursor/mcp.json
{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ]
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mcp-clickhousex": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ]
    }
  }
}

Optional settings from the registry entry, left out of the block above: 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).

Alternatives to ClickHouse

same job, measured the same way
Microsoft SQL Server
by alyiox

MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.

local only
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.

89 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.

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

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

199 installs/wk local only
R
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

143 installs/wk local only
AKKO MCP server for Trino
by ab2dridi

Read-only MCP server for Trino: queries run as the verified user, and Trino's own policies decide.

899 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 129 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 in the form 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 129 times in the last week. Week over week that is -25%. 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 1 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.