ClickHouse
io.github.alyiox/mcp-clickhousex
About ClickHouse
ClickHouse is an MCP server published by the GitHub account alyiox. Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.
It runs on your own machine: your AI client starts it from the PyPI package mcp-clickhousex at version 0.11.0.
It asks for one secret: MCP_CLICKHOUSE_DSN. Give it a key with the least access that still works.
Version 0.11.0 was published on 20 September 2026, and the source code is public, so you can read it before installing.
Written from the registry entry. 9 automated checks on the registry entry and the package code: 7 pass, 0 warn, 0 fail, 2 info. How we check.
What it asks for
| Variable | Required | Secret | Description |
|---|---|---|---|
MCP_CLICKHOUSE_DSN | No | Yes | 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. |
Checks
| Check | Result | Detail |
|---|---|---|
| Source repository linked | Pass | https://github.com/alyiox/mcp-clickhousex |
| Version pinned | Pass | Every package has an explicit version |
| Secrets requested | Info | Asks for 1 secret: MCP_CLICKHOUSE_DSN |
| Known package registry | Pass | All packages come from npm, PyPI, OCI, NuGet or MCPB |
| Namespace ownership | Info | Name verified via GitHub account alyiox |
| Registry text aimed at the AI | Pass | Description and settings contain no hidden characters or instructions to the AI |
| Install scripts | Pass | mcp-clickhousex 0.11.0 has no setup.py; nothing runs at install |
| Code red flags | Pass | Read 22 files in mcp-clickhousex 0.11.0: no obfuscation, encoded execution, credential reads or data-collection endpoints found |
| Text aimed at the AI | Pass | No hidden characters or instructions to the AI in 22 files, including comments and the README |
Popularity & health: 59 / 100
Worked out from public numbers and our own checks, not from user reviews or ratings. It says how used and how looked-after a server is, not whether it is safe.
0 forks, 0 merged pull requests. Sources: GitHub, npm, PyPI (pypistats.org) and Hacker News (Algolia), fetched 2026-10-31.
What people say
No Hacker News threads link to its source code.
Look further: search Reddit, search Hacker News, read its GitHub issues. These are not reviews we checked.
Facts
| Registry name | io.github.alyiox/mcp-clickhousex |
|---|---|
| Publisher | GitHub account alyiox |
| How the name is verified | Name verified via GitHub account alyiox. The registry ties the name prefix to that account or domain; it does not check the code. |
| Type | Local: runs on your machine from a package |
| Packages | pypi mcp-clickhousex 0.11.0 (stdio) |
| Version | 0.11.0 |
| Published | |
| Last updated | |
| Source repository | https://github.com/alyiox/mcp-clickhousex |
| Website | None linked |
| Category | Databases & data (assigned by keyword rule, not by hand) |
Related servers in Databases & data
- SqlServerMcp4/4MCP server for SQL Server: schema inspection, safe read-only…
- nifi-clickhouse-kafka-mcp7/7Read-only Apache NiFi, ClickHouse and Kafka access with OIDC, audit…
- Universal DB (read-only)4/4Read-only, guarded SQL access for AI agents: PostgreSQL, MySQL,…
- mcp-clickhouse7/7ClickHouse query & management for AI agents — SQL-classified…
- ClickHouse7/7Official ClickHouse MCP server for querying and exploring…
- LightShip3/3Governed access to production AI-agent traces in an existing…