Home › Databases & Data › pg-aiguide

pg-aiguide

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Python Remote

★ 1,850 stars Last pushed 2026-09-23 License: Apache-2.0

View repository →

Connect

Review any command before running it. Package names and URLs come from the server's own registry entry.

Remote (streamable-http)

https://mcp.tigerdata.com/docs Reachable (checked 2026-09-24)

Claude Code:

claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs

Or add to your MCP client config:

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

Package (npm 0.6.1)

npx -y @tigerdata/pg-aiguide@0.6.1

Or add to your MCP client config:

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide@0.6.1"
      ],
      "env": {
        "OPENAI_API_KEY": "<YOUR_VALUE>",
        "PGHOST": "<YOUR_VALUE>",
        "PGPORT": "<YOUR_VALUE>",
        "PGUSER": "<YOUR_VALUE>",
        "PGPASSWORD": "<YOUR_VALUE>",
        "PGDATABASE": "<YOUR_VALUE>",
        "DB_SCHEMA": "<YOUR_VALUE>"
      }
    }
  }
}

OPENAI_API_KEY required secret — Your API key for text embeddings via OpenAI
PGHOST required secret — PostgreSQL host to connect to
PGPORT required secret — PostgreSQL port to connect to
PGUSER required secret — PostgreSQL user to connect as
PGPASSWORD required secret — PostgreSQL password to connect with
PGDATABASE required secret — PostgreSQL database to connect to
DB_SCHEMA secret — PostgreSQL database schema to use

Package (oci)

docker run -i --rm ghcr.io/timescale/pg-aiguide:0.6.1

Or add to your MCP client config:

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/timescale/pg-aiguide:0.6.1"
      ],
      "env": {
        "OPENAI_API_KEY": "<YOUR_VALUE>",
        "PGHOST": "<YOUR_VALUE>",
        "PGPORT": "<YOUR_VALUE>",
        "PGUSER": "<YOUR_VALUE>",
        "PGPASSWORD": "<YOUR_VALUE>",
        "PGDATABASE": "<YOUR_VALUE>",
        "DB_SCHEMA": "<YOUR_VALUE>"
      }
    }
  }
}