PluginBench
MCP Server

io.github.timescale/pg-aiguide MCP Server

io.github.timescale/pg-aiguide

RepositoryRegistry

What is the io.github.timescale/pg-aiguide MCP server?

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

How to install io.github.timescale/pg-aiguide

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • 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

Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.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>",
        "DB_SCHEMA": "<YOUR_DB_SCHEMA>"
      }
    }
  }
}
Cursor
~/.cursor/mcp.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>",
        "DB_SCHEMA": "<YOUR_DB_SCHEMA>"
      }
    }
  }
}
Windsurf
~/.codeium/windsurf/mcp_config.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>",
        "DB_SCHEMA": "<YOUR_DB_SCHEMA>"
      }
    }
  }
}
VS Code
.vscode/mcp.json
{
  "servers": {
    "pg-aiguide": {
      "type": "stdio",
      "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>",
        "DB_SCHEMA": "<YOUR_DB_SCHEMA>"
      }
    }
  }
}
Claude Code
claude mcp add pg-aiguide --env OPENAI_API_KEY=<YOUR_OPENAI_API_KEY> --env PGHOST=<YOUR_PGHOST> --env PGPORT=<YOUR_PGPORT> --env PGUSER=<YOUR_PGUSER> --env PGPASSWORD=<YOUR_PGPASSWORD> --env PGDATABASE=<YOUR_PGDATABASE> --env DB_SCHEMA=<YOUR_DB_SCHEMA> -- npx -y @tigerdata/pg-aiguide

Related MCP servers

Tiger MCP

Provides programmatic access to Tiger Cloud services, databases, and documentation.

View repository →

io.github.timescale/tiger-skills

Provider agnostic skills implementation, with skills sourced from local paths or GitHub repositories

View repository →