ClickHouse MCP Server

by alyioxio.github.alyiox/mcp-clickhousexv0.11.0

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

0Pythonstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active18d ago

Install ClickHouse MCP server

claude mcp add clickhousex -e MCP_CLICKHOUSE_DSN='<mcp-clickhouse-dsn>' -- uvx mcp-clickhousex

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

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

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

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "clickhousex": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<mcp-clickhouse-dsn>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

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

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
MCP_CLICKHOUSE_DSN	—	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.

Freshness

Active — last maintenance signal 18d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-09-22 · 18d ago · GitHub
Latest release
no data · GitHub
Package published
no data · npm/PyPI
Registry entry updated
2026-09-20 · 20d ago · official registry · v0.11.0

FAQ

›How do I install the ClickHouse MCP server in Claude Code?

Run: claude mcp add clickhousex -e MCP_CLICKHOUSE_DSN='<mcp-clickhouse-dsn>' -- uvx mcp-clickhousex. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does ClickHouse require an API key?

Yes. It expects MCP_CLICKHOUSE_DSN, of which 1 is a secret.

›Can I use ClickHouse as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is ClickHouse in the official MCP registry?

Yes, as io.github.alyiox/mcp-clickhousex.