Skip to content

davidbirchall/squad-skills-data

v0.1.0

Data engineering skills distinct from general backend work: SQL conventions, data modelling, database migrations, query optimisation, data integrity, search indexing, and data import and export.

database-migrations

Safe schema migrations for PostgreSQL - versioned forward-only migrations, one change per migration, expand/contract for zero-downtime deploys, batched backfills, lock awareness (concurrent index creation, NOT NULL and default adds), reversible vs roll-forward policy, testing on production-sized data, ordering and conflicts in teams, seed vs migration data, never editing applied migrations, and Prisma migrate workflow notes. Load when changing a schema, writing a migration, planning a backfill, adding indexes or constraints to live tables, or resolving migration conflicts.

Read SKILL.md at the source

Pinned to revision c74eff4a9f08, so it is the text this page describes rather than whatever the author pushed since.

Files

Every link opens the file at its source, pinned to the revision this page describes.