PG Aiguide MCP Server

by timescaleio.github.timescale/pg-aiguidev0.6.1

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

1.9kNode.jsstdioremoteofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active2d ago

Install PG Aiguide MCP server

claude mcp add pg-aiguide -e OPENAI_API_KEY='<openai-api-key>' -e PGHOST='<pghost>' -e PGPORT='<pgport>' -e PGUSER='<pguser>' -e PGPASSWORD='<pgpassword>' -e PGDATABASE='<pgdatabase>' -e DB_SCHEMA='<db-schema>' -- npx -y @tigerdata/pg-aiguide

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<openai-api-key>",
        "PGHOST": "<pghost>",
        "PGPORT": "<pgport>",
        "PGUSER": "<pguser>",
        "PGPASSWORD": "<pgpassword>",
        "PGDATABASE": "<pgdatabase>",
        "DB_SCHEMA": "<db-schema>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<openai-api-key>",
        "PGHOST": "<pghost>",
        "PGPORT": "<pgport>",
        "PGUSER": "<pguser>",
        "PGPASSWORD": "<pgpassword>",
        "PGDATABASE": "<pgdatabase>",
        "DB_SCHEMA": "<db-schema>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "pg-aiguide": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<openai-api-key>",
        "PGHOST": "<pghost>",
        "PGPORT": "<pgport>",
        "PGUSER": "<pguser>",
        "PGPASSWORD": "<pgpassword>",
        "PGDATABASE": "<pgdatabase>",
        "DB_SCHEMA": "<db-schema>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<openai-api-key>",
        "PGHOST": "<pghost>",
        "PGPORT": "<pgport>",
        "PGUSER": "<pguser>",
        "PGPASSWORD": "<pgpassword>",
        "PGDATABASE": "<pgdatabase>",
        "DB_SCHEMA": "<db-schema>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

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

Remote endpoints

streamable-httphttps://mcp.tigerdata.com/docs

Freshness

Active — last maintenance signal 2d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-10-07 · 2d ago · GitHub
Latest release
2026-09-04 · 35d ago · GitHub · v0.6.1
Package published
no data · npm/PyPI
Registry entry updated
2026-09-04 · 35d ago · official registry · v0.6.1

FAQ

›How do I install the PG Aiguide MCP server in Claude Code?

Run: claude mcp add pg-aiguide -e OPENAI_API_KEY='<openai-api-key>' -e PGHOST='<pghost>' -e PGPORT='<pgport>' -e PGUSER='<pguser>' -e PGPASSWORD='<pgpassword>' -e PGDATABASE='<pgdatabase>' -e DB_SCHEMA='<db-schema>' -- npx -y @tigerdata/pg-aiguide. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does PG Aiguide require an API key?

Yes. It expects OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DB_SCHEMA, of which 7 are secrets.

›Can I use PG Aiguide as a remote (hosted) MCP server?

Yes — it offers both a hosted endpoint and a local stdio package.

›Is PG Aiguide in the official MCP registry?

Yes, as io.github.timescale/pg-aiguide.