Skip to content
mcp/harbor
Gemini CLI

sw-postgres-mcp for Gemini CLI

io.github.jpka/sw-postgres-mcp

Safe-write Postgres MCP server with preview-before-execute writes and rollback safety.

client:Gemini CLI transport:stdio runtime:npm

Install sw-postgres-mcp 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": {
    "sw-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "sw-postgres-mcp"
      ],
      "env": {
        "DATABASE_URL_READONLY": "<DATABASE_URL_READONLY>",
        "DATABASE_URL_WRITER": "<DATABASE_URL_WRITER>"
      }
    }
  }
}

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

sw-postgres-mcp in other clients

sw-postgres-mcp MCP server