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
{
"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