Home › Databases & Data › pg-aiguide

pg-aiguide

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Python Remote

★ 1,884 stars Last pushed 2026-11-11 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 Responded, but not as an MCP endpoint

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/[email protected]

Or add to your MCP client config:

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/[email protected]"
      ],
      "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 -e OPENAI_API_KEY=<YOUR_VALUE> -e PGHOST=<YOUR_VALUE> -e PGPORT=<YOUR_VALUE> -e PGUSER=<YOUR_VALUE> -e PGPASSWORD=<YOUR_VALUE> -e PGDATABASE=<YOUR_VALUE> -e DB_SCHEMA=<YOUR_VALUE> ghcr.io/timescale/pg-aiguide:0.6.1

Or add to your MCP client config:

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