Migrations

​

Branch sequence

​

Run

# from repo root
DATABASE_URL=postgres://... pnpm --filter @inviolet/db db:migrate

​

Verify

pnpm --filter @inviolet/db db:studio
# inspect feature_trials, classifier_integrations, classifier_corrections,
# classifier_overrides, mandate_dispenses.classification_evidence column

​

Rollback

​

Common pitfalls

• Running migrations against an uncommitted prod branch — always confirm git status is clean.
• Forgetting to apply to demo — demo seeds rely on the latest schema.
• Adding a NOT NULL column to a hot table without a backfill — use NULL → backfill → NOT NULL pattern instead.