Skip to content
mcp/harbor
Gemini CLI

pgops for Gemini CLI

io.github.arzharch/pgops-mcp

Safe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers

client:Gemini CLI transport:stdio runtime:pypi

Install pgops 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": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<PGOPS_READONLY_DSN>",
        "PGOPS_READ_ONLY": "<PGOPS_READ_ONLY>",
        "PGOPS_APPROVAL_MODE": "<PGOPS_APPROVAL_MODE>",
        "PGOPS_AUDIT_LOG": "<PGOPS_AUDIT_LOG>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<PGOPS_DEFAULT_TIMEOUT_MS>",
        "PGOPS_MAX_TIMEOUT_MS": "<PGOPS_MAX_TIMEOUT_MS>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<PGOPS_DEFAULT_ROW_LIMIT>"
      }
    }
  }
}

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

pgops in other clients

pgops MCP server