What PostgreSQL versions does this MCP server support?

The server connects to any PostgreSQL instance via standard host/port/user/password credentials. Compatibility depends on your PostgreSQL version; consult the hosted documentation at https://mcp.tigerdata.com/docs for version-specific guidance.

Do I need an OpenAI API key to use this server?

Yes. The OPENAI_API_KEY environment variable is required for text embeddings, which power natural-language queries against your database and documentation. You'll incur OpenAI API costs for embedding requests.

Can I use this server with a remote PostgreSQL database?

Yes. Set PGHOST, PGPORT, PGUSER, PGPASSWORD, and PGDATABASE to point to any accessible PostgreSQL instance. Ensure your network allows outbound connections to your database and to OpenAI's API.

What happens if I don't set the DB_SCHEMA environment variable?

The DB_SCHEMA variable is optional. If not set, the server will likely query across all schemas in your database. Set it to restrict queries to a specific schema if needed.

How does this differ from just asking ChatGPT about PostgreSQL?

This server combines live access to your actual database schema with embeddings-based retrieval of Postgres best practices and ecosystem documentation. You get answers tailored to your real data and production-ready guidance, not generic examples.

MCP ServerHTTPOfficialv0.5.0

Timescale Pg Aiguide MCP Server

Query PostgreSQL databases with natural language and retrieve best practices from comprehensive Postgres documentation. Built for developers who want AI-assisted database exploration and guidance without writing SQL.

io.github.timescale/pg-aiguide

Open in Agent Studio Scan security View source

Hosted URL

https://mcp.tigerdata.com/docs

Transport

HTTP

Auth

12 required env vars

What the Timescale Pg Aiguide MCP server does

How models use it and what it is built for.

Connect to Timescale 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 Timescale Pg Aiguide.

Source repository

Example prompts for Timescale Pg Aiguide

Paste any of these into Agent Studio after connecting Timescale Pg Aiguide.

Show me the schema for the users table and suggest indexes based on query patterns
What are the best practices for connection pooling in production PostgreSQL?
Query my database to find tables with missing primary keys
Explain how to optimize this slow query and what Postgres ecosystem tools might help

Timescale Pg Aiguide MCP server — FAQ

Common questions about connecting and running Timescale Pg Aiguide.

What PostgreSQL versions does this MCP server support?
The server connects to any PostgreSQL instance via standard host/port/user/password credentials. Compatibility depends on your PostgreSQL version; consult the hosted documentation at https://mcp.tigerdata.com/docs for version-specific guidance.
Do I need an OpenAI API key to use this server?
Yes. The OPENAI_API_KEY environment variable is required for text embeddings, which power natural-language queries against your database and documentation. You'll incur OpenAI API costs for embedding requests.
Can I use this server with a remote PostgreSQL database?
Yes. Set PGHOST, PGPORT, PGUSER, PGPASSWORD, and PGDATABASE to point to any accessible PostgreSQL instance. Ensure your network allows outbound connections to your database and to OpenAI's API.
What happens if I don't set the DB_SCHEMA environment variable?
The DB_SCHEMA variable is optional. If not set, the server will likely query across all schemas in your database. Set it to restrict queries to a specific schema if needed.
How does this differ from just asking ChatGPT about PostgreSQL?
This server combines live access to your actual database schema with embeddings-based retrieval of Postgres best practices and ecosystem documentation. You get answers tailored to your real data and production-ready guidance, not generic examples.

Run Timescale Pg Aiguide across 60+ AI models, side-by-side

Connect Timescale Pg Aiguide to Claude, GPT, Gemini, DeepSeek and 60+ AI models in MCP Agent Studio. Compare answers side-by-side, save reusable agent presets, share runs — all in your browser, no install required.

Open Agent Studio