Skip to content
mcp/harbor
Gemini CLI

PostgreSQL (hardened, read-only) for Gemini CLI

io.github.eszetael/postgres-mcp-hardened

Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.

client:Gemini CLI transport:stdio runtime:npm

Install PostgreSQL (hardened, read-only) 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": {
    "postgres-mcp-hardened": {
      "command": "npx",
      "args": [
        "-y",
        "postgres-mcp-hardened"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>",
        "MCP_STATEMENT_TIMEOUT": "<MCP_STATEMENT_TIMEOUT>",
        "MCP_ALLOW_TABLES": "<MCP_ALLOW_TABLES>",
        "MCP_AUDIT_LOG": "<MCP_AUDIT_LOG>"
      }
    }
  }
}

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

PostgreSQL (hardened, read-only) in other clients

PostgreSQL (hardened, read-only) MCP server