Backend: Add database migration safety checks in CI #196
Description
Goal
Reduce risk from unsafe schema changes.
Scope
- Add CI checks for irreversible/locking migrations
- Flag long-running operations and missing indexes
- Document safe migration patterns
Acceptance Criteria
- CI surfaces risky migration patterns
- Migration guide includes rollback expectations
- New migrations follow documented standards