timescale/pg-aiguide

1,698 stars · Last commit 2026-04-23

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

Debugging Documentation Design & UI DevOps & Infra Productivity AI & Prompting Data & ML

README preview

# 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 as:

- **Agent Skills** via `npx skills` — works with Claude Code, Cursor, Codex, Gemini CLI, and 40+ other agents
- 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:

View full repository on GitHub →