PostgreSQL Expert Best Practices

Simple, pragmatic, opinionated. Only what matters for writing production-grade PostgreSQL queries.

When to Apply

Reference these guidelines when:

• Writing database migrations or schema changes
• Creating or modifying PostgreSQL tables and columns
• Adding indexes, constraints, or foreign keys
• Reviewing database schema for performance issues
• Refactoring existing database structures
• Optimizing query performance or database design

Rule Categories by Priority