pg-aiguide
Version-aware PostgreSQL manual search and best-practice skills that help AI tools write better Postgres code.
Sources and review
Checked against public documentation on . Suitability guidance is our editorial judgment; this is not a performance benchmark or an endorsement.
Schema design and query writing where agents tend to skip constraints and indexes or use outdated features.
About pg-aiguide
pg-aiguide, from Timescale (TigerData), helps AI coding tools write better PostgreSQL. It offers semantic search across the official PostgreSQL manual by version, curated best-practice skills that agents apply automatically, and documentation for extensions starting with TimescaleDB. It ships as a public MCP server, as agent skills and as a Claude Code plugin.
pg-aiguide is listed in this index written primarily in Python, with 1.9k stars on GitHub. Its latest recorded repository push was in October 2026; that is not an ASE editorial review date.
Before connecting: access and data
This record's specific permissions have not been reviewed by ASE. Read the publisher's documentation before copying setup or connecting.
- List the accounts, files and services the enabled tools can read, change or execute. Check your actual credentials and discovered tools.
- Use narrowly scoped credentials and read-only mode where supported. Review proposed writes before approving them; a generated configuration does not apply these limits for you.
- Local launch is not local-only data processing. External services receive requests, and your client may pass tool results to its model provider. Check both destinations before sharing private data.
- Keep keys and browser session files out of shared config, repositories and screenshots. Know how to disconnect the server and separately revoke its credentials or account sessions.
Add pg-aiguide to your MCP client
A hosted server: point your client at its URL and complete its sign-in there. In Claude Desktop or claude.ai, add it under Settings → Connectors → Add custom connector instead.
Claude Code
claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docsCursor
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}VS Code
{
"servers": {
"pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}Codex
codex mcp add pg-aiguide --url https://mcp.tigerdata.com/docs