Other · Local MCP server

ClickHouse

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

What the MCP Registry states

The entry as published to the official MCP Registry (read 2026-10-04), latest version.

Registry name
io.github.alyiox/mcp-clickhousex
Version
0.11.0
Status
Active
Category
other
Transport
stdio (local process)
Package
PyPI
Published
2026-09-20
Updated
2026-09-20
Publisher
alyiox (GitHub) · 5 servers with pages here
Namespace
Namespace verified by the MCP Registry via GitHub (github.com/alyiox) · how
Listed under
ClickHouse MCP servers
Repository
github.com/alyiox/mcp-clickhousex
Source
Registry API entry

Packages

RegistryPackageVersionTransportEnvironment variables
PyPIruntime: uvxmcp-clickhousex0.11.0stdioMCP_CLICKHOUSE_DSN (secret)

How to connect ClickHouse

ClickHouse runs locally from a Python package published to PyPI: mcp-clickhousex version 0.11.0. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs Python; clients usually start it with uvx (from uv) or after pip install - the usual command is uvx mcp-clickhousex. It reads the environment variable MCP_CLICKHOUSE_DSN (secret); set it in the client's configuration for this server.

In the mcpServers JSON format that many desktop and editor MCP clients read, the entry looks like this (placeholders in angle brackets):

{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<secret>"
      }
    }
  }
}

Derived from the registry entry, not tested here. What the server does, and on what terms, is set by its publisher; check its repository or website before giving it access to your accounts or files. How to add an MCP server to an assistant · Before you connect

More from alyiox (GitHub)

All 5 →
ServerRunsEndpoint or package
Atlassian AttachmentsMCP server for downloading, uploading, and deleting Jira Cloud attachments by ID.Local · stdioPyPI: mcp-atlassian-attachments
Docs Ask (local docs RAG)Local RAG MCP for markdown documentation. Retrieval only; host synthesizes answers.Local · stdioPyPI: mcp-docs-ask
Microsoft SQL ServerRead-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.Local · stdioNuGet: Alyio.McpMssql
OpenAPI ServicesMCP server that fronts any OpenAPI service: discover operations from its spec and call them.Local · stdioPyPI: mcp-openapix

More other servers

All 8,395 →
ServerRunsEndpoint or package
ClearvoyanceAnonymous feedback from real people by voice or text, with an AI report. Flat price per campaign.Remote · HTTPLive check: ✓ handshakeclearvoyance.ai
CleatA real US mobile number that receives verification codes, by text or transcribed call.Remote & Local · HTTP, stdioLive check: ✓ handshakecleat.so
Clef MCPLocal MCP server for the Cloudflare Clef-Flash decision model: structured decisions, fully offline.Local · stdionpm: clef-mcp
ClickcastDrive a real Playwright browser: annotated screenshot + structured page state after every action.Local · stdioPyPI: clickcast
ClickupClickUp MCP - wraps the ClickUp REST API v2 (BYO API key)Remote · HTTPLive check: ✓ handshakegateway.pipeworx.io
Clickup MCPLightweight ClickUp MCP server - 37 tools, token-optimized (95% smaller responses)Local · stdionpm: @cavort-it-systems/clickup-mcp
ClickUp MCP ProThe most complete ClickUp MCP server - 161 tools + clickup_raw for the full v2/v3 API.Local · stdionpm: clickup-mcp-pro
Client CompassBehavioral intelligence for client-facing professionals. Know who you're walking into.Remote · HTTPLive check: ✓ handshakenumbru-mcp-server.numbru.workers.dev