MCP ServerHTTPOfficialv0.4.0

pg-aiguide MCP Server

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

io.github.timescale/pg-aiguide

Hosted URL

https://mcp.tigerdata.com/docs

Transport

HTTP

Auth

12 required env vars

Connect to pg-aiguide

Hosted endpoint — paste into any MCP client.

https://mcp.tigerdata.com/docs

Environment variables

Configuration this server reads at startup.

  • OPENAI_API_KEYRequiredSecret

    Your API key for text embeddings via OpenAI

  • PGHOSTRequiredSecret

    PostgreSQL host to connect to

  • PGPORTRequiredSecret

    PostgreSQL port to connect to

  • PGUSERRequiredSecret

    PostgreSQL user to connect as

  • PGPASSWORDRequiredSecret

    PostgreSQL password to connect with

  • PGDATABASERequiredSecret

    PostgreSQL database to connect to

  • OPENAI_API_KEYRequiredSecret

    Your API key for text embeddings via OpenAI

  • PGHOSTRequiredSecret

    PostgreSQL host to connect to

  • PGPORTRequiredSecret

    PostgreSQL port to connect to

  • PGUSERRequiredSecret

    PostgreSQL user to connect as

  • PGPASSWORDRequiredSecret

    PostgreSQL password to connect with

  • PGDATABASERequiredSecret

    PostgreSQL database to connect to

  • DB_SCHEMASecret

    PostgreSQL database schema to use

  • DB_SCHEMASecret

    PostgreSQL database schema to use

Resources

Where to find authoritative docs and source for pg-aiguide.

Try pg-aiguide with 30+ AI models

Open MCP Agent Studio and connect this server to Claude, GPT, Gemini, DeepSeek and more — no install required.

Open Agent Studio

Related servers

More on MCP Playground