//
Search across all documentation pages
9 pages in this section.
Why this section's PostgreSQL rules exist, what separates a rule from a preference, and how to decide when a convention deserves review-time enforcement versus a mechanical CI gate.
Learn 25 essential PostgreSQL rules for schemas, queries, migrations, and operations. Improve database health and performance.
Learn SQL naming and style rules for PostgreSQL, including conventions for schemas, tables, columns, indexes, and constraints.
Learn PostgreSQL index and query rules to prevent production regressions. Understand how to use EXPLAIN, gate nested loops, and optimize API queries.
Implement PostgreSQL migration safety rules to prevent lock contention and unbounded blocking. Learn to configure timeouts and phased DDL for robust deployments.
Learn to enforce PostgreSQL security with least privilege, tenant isolation, and auditable access. Implement RLS and secure connection practices.
Automate PostgreSQL rule enforcement with linting, CI checks, and human review. Learn to implement SQLFluff, custom linters, and PR gate best practices.
A single-page roundup of every highlight bullet from the 8 pages in the PostgreSQL Rules section, grouped by source page so you can scan all 46 takeaways without opening each article individually.