Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.
Connect Runs on your machine
claude mcp add mcp-clickhousex -e MCP_CLICKHOUSE_DSN=<MCP_CLICKHOUSE_DSN> -- uvx mcp-clickhousex==0.11.0
{
"mcpServers": {
"mcp-clickhousex": {
"command": "uvx",
"args": [
"mcp-clickhousex==0.11.0"
],
"env": {
"MCP_CLICKHOUSE_DSN": "<MCP_CLICKHOUSE_DSN>"
}
}
}
}
{
"mcpServers": {
"mcp-clickhousex": {
"command": "uvx",
"args": [
"mcp-clickhousex==0.11.0"
],
"env": {
"MCP_CLICKHOUSE_DSN": "<MCP_CLICKHOUSE_DSN>"
}
}
}
}
{
"servers": {
"mcp-clickhousex": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-clickhousex==0.11.0"
],
"env": {
"MCP_CLICKHOUSE_DSN": "<MCP_CLICKHOUSE_DSN>"
}
}
}
}
Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
MCP_CLICKHOUSE_DSNOptional, secret | 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. |
Details
| Package | [email protected] (PYPI, stdio) |
| First published | 20 Sep 2026 |
| Last updated | 20 Sep 2026 |
| Registry name | io.github.alyiox/mcp-clickhousex |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.
