PostgreSQL Idioms and Best Practices

PostgreSQL rewards set-based thinking, explicit joins, and query plan awareness. Idiomatic PostgreSQL = readable, performant, migration-safe, secure.

Scope: PostgreSQL-specific patterns. For database design principles (normalization, naming, migration strategy), see @.agents/rules/database-design-principles.md. For deep-dive references on individual topics, see references/ in this skill directory.

Priority Guide