Postgres Patterns

PostgreSQL working reference for index selection, data types, row-level security, cursor pagination, queue processing, anti-pattern detection queries, server configuration, replica routing, alert thresholds, backups, and erasure. Use when you say "which index does this query need", "why is this query slow", "write an RLS policy for this table", "should this be numeric or float", or "find our unindexed foreign keys". Not for applying a schema change safely, use `database-migrations`.

Lukk17 Updated 1 repo stars

File contents

Lukk17/agent-standards commit b9522ceabc

Frequently asked questions

npx get-skill add lukk17/postgres-patterns