pg-aiguide

Why we included this project

AI coding assistants routinely produce Postgres code that is a few versions out of date, skipping constraints and indexes that a careful developer would add. pg-aiguide fixes that by handing agents curated, version-aware Postgres knowledge, so tools like Claude Code, Cursor, and Codex draw on real best practices rather than stale training data. You can use it as agent skills, a public MCP server, or a Claude Code plugin, whichever fits the workflow your team already has. The semantic search across the official PostgreSQL manual keeps generated code current as PG releases change, and the opinionated skills give agents concrete, consistent patterns for schema design, constraints, and indexing. Teams doing serious Postgres work with AI-assisted coding will find it a simple way to get better SQL out of their tools.