postgres
Postgres
Most production Postgres trouble is not a slow query but the machinery around it: a migration that takes a lock for ten minutes, a pool that leaks session settings, one forgotten open transaction that stops vacuum for the whole database, a column type chosen once and paid for forever. Query correctness is the sql-patterns skill; query speed and index design are the performance-and-caching skill's QUERIES.md; row-level security is the secure-coding skill's TENANCY.md and, on Supabase, the supabase skill.
Apply only the routes and checks for the selected job. Read a linked skill's named file from its installed folder when available, or from the linked source. Report an unavailable required reference instead of inventing it. [skill-authoring, DISTRIBUTION.md#composing-skills]
| The job | Read |
|---|---|
| Tables, keys, column types, constraints, names, partitioning | SCHEMA.md |
| Migrations that don't lock, fail halfway or break deploys: indexes, constraints, columns, backfills | MIGRATIONS.md |
| Connections, poolers and their limits, timeouts, transactions, locks, deadlocks, upserts, batches | CONNECTIONS.md |
| MVCC, vacuum, wraparound, memory, WAL and checkpoints, storage, backups, replication | OPERATIONS.md |
| The queries that audit a database: slow statements, unused and duplicate indexes, bloat, missing FK indexes, dead rows, connections, lag | MONITORING.md |
| PlanetScale Postgres targets and pooling, current Insights/inspection surfaces, query-pattern API and extension availability | PLANETSCALE.md |