Skip to content
Gemini CLI

Postgres MCP for Gemini CLI

io.github.edelciomolina/postgres-mcp

PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.

client:Gemini CLI transport:stdio runtime:npm

Install 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": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "env": {
        "MCP_KEY_HOST": "<MCP_KEY_HOST>",
        "MCP_KEY_PORT": "<MCP_KEY_PORT>",
        "MCP_KEY_NAME": "<MCP_KEY_NAME>",
        "MCP_KEY_USER": "<MCP_KEY_USER>",
        "MCP_KEY_PASS": "<MCP_KEY_PASS>",
        "MCP_KEY_SSLMODE": "<MCP_KEY_SSLMODE>"
      }
    }
  }
}

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

Postgres MCP in other clients