# Migration Directory

This directory is the canonical location for SQL migrations.

- Use `npm run db:migrate` to apply pending migrations.
- Use `npm run db:migrate:status` to view applied/pending migrations.
- Use `npm run db:migrate:verify` to fail when pending migrations exist.
- Use `npm run db:migrate:new -- <migration-name>` to create a new migration file.

Do not place new canonical migrations under `backend/migrations`.

## Stale baseline
- `stale-files.json` lists canonical SQL files intentionally treated as stale.
- Files listed there are skipped by migration commands by default.
- Add only genuinely new migration files when schema changes are required.