mcp-clickhousex

Read-only MCP server for ClickHouse: SELECT queries, EXPLAIN plan/pipeline/syntax analysis, and a snapshot mode that spills large results to a CSV resource. Read-only is enforced by the engine — every client carries readonly=1, so writes, external table functions and query-level SETTINGS are refused. Multi-cluster profiles; ships on PyPI.

Installation

{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "npx",
      "args": [
        "mcp-clickhousex"
      ]
    }
  }
}

Related servers