pg-aiguide

AI-optimized PostgreSQL expertise for coding assistants

pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:

Semantic search across the official PostgreSQL manual (version-aware)
AI-optimized “skills” — curated, opinionated Postgres best practices used automatically by AI agents
Extension ecosystem docs, starting with TimescaleDB, with more coming soon

Use it either as:

a public MCP server that can be used with any AI coding agent, or
a Claude Code plugin optimized for use with Claude's native skill support.

⭐ Why pg-aiguide?

AI coding tools often generate Postgres code that is:

outdated
missing constraints and indexes
unaware of modern PG features
inconsistent with real-world best practices

pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.

See the difference

https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d

Video Transcript

Prompt given to Claude Code:

Please describe the schema you would create for an e-commerce website two times, first with the tiger mcp server disabled, then with the tiger mcp server enabled. For each time, write the schema to its own file in the current working directory. Then compare the two files and let me know which approach generated the better schema, using both qualitative and quantitative reasons. For this example, only use standard Postgres.

Result (summarized):

4× more constraints
55% more indexes (including partial/expression indexes)
PG17-recommended patterns
Modern features (GENERATED ALWAYS AS IDENTITY, NULLS NOT DISTINCT)
Cleaner naming & documentation

Conclusion: pg-aiguide produces more robust, performant, maintainable schemas.

🚀 Quickstart

pg-aiguide is available as a public MCP server:

https://mcp.tigerdata.com/docs

Manual MCP configuration using JSON

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

Or it can be used as a Claude Code Plugin:

claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide

Install by environment

One-click installs

Claude Code

This repo serves as a claude code marketplace plugin. To install, run:

claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide

This plugin uses the skills available in the skills directory as well as our publicly available MCP server endpoint hosted by TigerData for searching PostgreSQL documentation.

Codex

Run the following to add the MCP server to codex:

codex mcp add --url "https://mcp.tigerdata.com/docs" pg-aiguide

Cursor

One-click install:

Or add the following to .cursor/mcp.json

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
   

...

timescale/pg-aiguide

README

pg-aiguide

⭐ Why pg-aiguide?

See the difference

🚀 Quickstart

Install by environment

One-click installs

Publisher

Topics

Statistics