How do I install pg-aiguide?

Pick a client above and copy the generated config. Cursor and VS Code also have a deep link when the server can run locally or remotely.

Is pg-aiguide official?

No. Registry-listed is not the same as vendor-official. Read the methodology for the difference.

How is the trust score calculated?

This listing scores 48 (Fair). The formula is published on the methodology page.

MCPpedia

pg-aiguide MCP Server | MCPpedia

pg-aiguide MCP Server

Name: pg-aiguide MCP Server
Author: timescale

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Tools Versions Alternatives

RegistryRemotetimescale

48Fair

Install

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "timescale-pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide@0.6.1"
      ],
      "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"
      }
    }
  }
}

Install guide

Related servers

Codebase Memory

77Good

Codebase knowledge graph for AI agents — 162 languages, sub-ms queries, 99% fewer tokens.

Registrydeusdata46.7K stars

Astria

71Good

Turn any codebase into a queryable knowledge graph — offline-first, zero API keys.

Environment

Name	Required	Notes
OPENAI_API_KEY	Yes	Your API key for text embeddings via OpenAI Secret.
PGHOST	Yes	PostgreSQL host to connect to Secret.
PGPORT	Yes	PostgreSQL port to connect to Secret.
PGUSER	Yes	PostgreSQL user to connect as Secret.
PGPASSWORD	Yes	PostgreSQL password to connect with Secret.
PGDATABASE	Yes	PostgreSQL database to connect to Secret.
DB_SCHEMA	No	PostgreSQL database schema to use Secret.
OPENAI_API_KEY	Yes	Your API key for text embeddings via OpenAI Secret.
PGHOST	Yes	PostgreSQL host to connect to Secret.
PGPORT	Yes	PostgreSQL port to connect to Secret.
PGUSER	Yes	PostgreSQL user to connect as Secret.
PGPASSWORD	Yes	PostgreSQL password to connect with Secret.
PGDATABASE	Yes	PostgreSQL database to connect to Secret.
DB_SCHEMA	No	PostgreSQL database schema to use Secret.

pg-aiguide MCP Server

Install

Related servers

Codebase Memory

Astria

Environment

Tools

About

FAQ

Reviews

doc-scraper

Elfsight AI Chatbot

Supabase

mcp-ssh-manager