Skip to content
Gemini CLI

mcp clickhouse for Gemini CLI

io.github.dockndevai/mcp-clickhouse

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

client:Gemini CLI transport:stdio runtime:npm

Install mcp clickhouse in Gemini CLI

~/.gemini/settings.json · windows: %USERPROFILE%\.gemini\settings.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_URL": "<CLICKHOUSE_URL>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_MODE": "<CLICKHOUSE_MODE>"
      }
    }
  }
}

Gemini expands $VAR and ${VAR} inside env values, so a secret can live in your shell rather than this file. Gemini CLI docs

mcp clickhouse in other clients