postgres-schema-design
Design PostgreSQL tables, names, relations, history, work-item and cursor tables, retention, and locking. Use when writing or reviewing a migration, a table, column, or foreign key, or any code that takes a row lock (FOR UPDATE) or an advisory lock, serializes concurrent writers, or enforces a cap, limit, or last-one guard under concurrency.
Pinned to revision 8cad1e4eb680, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/postgres-schema-design/SKILL.md
- skills/postgres-schema-design/references/naming.md
- skills/postgres-schema-design/references/relations.md
- skills/postgres-schema-design/references/table-shapes.md
Every link opens the file at its source, pinned to the revision this page describes.