HomeDatabases & Data › mcp-clickhouse

mcp-clickhouse

ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.

TypeScript Local macOSWindowsLinux
★ 2 stars Last pushed 2026-09-18 License: MIT

Topics: Databases

Connect

Review any command before running it. Package names and URLs come from the server's own registry entry.

Package (npm 0.2.2)

npx -y @dockndevai/[email protected]

Or add to your MCP client config:

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/[email protected]"
      ],
      "env": {
        "CLICKHOUSE_URL": "<YOUR_VALUE>",
        "CLICKHOUSE_USER": "<YOUR_VALUE>",
        "CLICKHOUSE_PASSWORD": "<YOUR_VALUE>",
        "CLICKHOUSE_MODE": "<YOUR_VALUE>"
      }
    }
  }
}
  • CLICKHOUSE_URL — ClickHouse HTTP endpoint.
  • CLICKHOUSE_USER — ClickHouse user (prefer a read-only user).
  • CLICKHOUSE_PASSWORD secret — ClickHouse password.
  • CLICKHOUSE_MODE — Access mode: read-only | read-write | admin.

Related servers

Listed in punkpeye/awesome-mcp-servers (MIT)

Data from the Official MCP Registry