Db Migration

DB Migration Skill

Workflow

For any schema change request:

1. Propose a short plan before editing (tables/columns affected, migration type).
2. Generate migration file with up/down (or forward/rollback).
3. Update models (ORM entities, types, relationships).
4. Update schema docs (schema notes, ERD, or README).
5. Add basic test/seed (smoke test, seed data for new fields).

Migration File

• Use project convention (e.g. YYYYMMDDHHMMSS_description.sql or framework migrations).
• Include up (apply) and down (rollback) steps.
• Add a rollback note in comments or docs describing how to revert.

Model Updates