CuratedMCP
Gemini CLI
npm

How to install pg-aiguide in Gemini CLI

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Indexed, not yet reviewed

We found pg-aiguide in the official MCP registry. Our automated check passed on Nov 1, 2026 (it confirms the server is published and reachable), but no one at CuratedMCP has reviewed its code, permissions or credentials handling. Check what it can access before you give it keys. Scan your machine free to see every MCP server you have installed.

Steps

  1. 1Install Node.js 18 or newer (for npx)
  2. 2Open ~/.gemini/settings.json (or .gemini/settings.json in your project)
  3. 3Add the entry below. If the file already has "mcpServers", add just the inner entry
  4. 4Restart Gemini CLI and run /mcp to confirm

Configuration

~/.gemini/settings.json
{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<your-openai-api-key>",
        "PGHOST": "<your-pghost>",
        "PGPORT": "<your-pgport>",
        "PGUSER": "<your-pguser>",
        "PGPASSWORD": "<your-pgpassword>",
        "PGDATABASE": "<your-pgdatabase>"
      }
    }
  }
}

Replace the values in angle brackets. Optional settings are listed below.

Environment variableRequiredWhat it is
OPENAI_API_KEYsecretYesYour API key for text embeddings via OpenAI
PGHOSTsecretYesPostgreSQL host to connect to
PGPORTsecretYesPostgreSQL port to connect to
PGUSERsecretYesPostgreSQL user to connect as
PGPASSWORDsecretYesPostgreSQL password to connect with
PGDATABASEsecretYesPostgreSQL database to connect to
DB_SCHEMAsecretNoPostgreSQL database schema to use

Install in other clients

About pg-aiguide: repo, license and check results →

Maintain pg-aiguide?

Claim this page to get a full CuratedMCP listing: edit your description, see listing analytics, and add our README badge. Listing is free, and a person checks every submission before it goes live. We'll pre-fill the form from the registry.

    How to install pg-aiguide MCP server in Gemini CLI | CuratedMCP