We are releasing a series of Agent Skills for Postgres Best Practices to teach AI agents how to write better Postgres code. AI coding agents are good at writing code. They struggle with writing correct code for systems they don't understand.
Postgres is one of those systems. It has decades of features, edge cases, and performance characteristics that matter in production. An agent might generate a query that works but creates a full table scan. It might suggest an index that makes writes slower. It might miss Row Level Security entirely.
The Agent Skills we’re releasing today will help guide your coding agent of choice to generate high quality, correct code.
The repository contains rules across 8 categories, prioritized by impact:
Query Performance (Critical): Rules for writing efficient queries and avoiding full table scans
