pg-aiguide

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

HTTP v0.3.1

Connection Configuration

Add this to your AI agent's MCP config file to connect.

Run in your terminal:

claude mcp add io.github.timescale--pg-aiguide --transport http https://mcp.tigerdata.com/docs

Transport

HTTP

Authentication

None

Version

v0.3.1

Server Name

io.github.timescale/pg-aiguide

Last Updated

Feb 23, 2026

How to install and connect this MCP server.

Environment variables you must provide when running this server.

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