NestDaddy

ClickHouse

io.github.alyiox/mcp-clickhousex · v0.11.0

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

Connect Runs on your machine

Terminal
claude mcp add mcp-clickhousex -e MCP_CLICKHOUSE_DSN=<MCP_CLICKHOUSE_DSN> -- uvx mcp-clickhousex==0.11.0
claude_desktop_config.json
{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex==0.11.0"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<MCP_CLICKHOUSE_DSN>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex==0.11.0"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<MCP_CLICKHOUSE_DSN>"
      }
    }
  }
}
.vscode/mcp.json
{
  "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

NameDescription
MCP_CLICKHOUSE_DSN
Optional, 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 published20 Sep 2026
Last updated20 Sep 2026
Registry nameio.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.