PostgreSQL Database Engineering

Choose the smallest PostgreSQL workflow that matches the request.

Route the task

• Read modeling.md for tables, keys, constraints, normalization, tenancy, and lifecycle modeling.
• Read query-review.md for SQL correctness, indexes, transactions, locks, and review output.
• Read performance.md for EXPLAIN, statistics, plan shapes, realistic data, pooling, and measurement.
• Read migrations-and-operations.md for online changes, backfills, rollback, maintenance, backup, and recovery.

Load only the references needed for the selected task.

Common process