Used this migration CLI to apply a single raw-SQL migration that creates the job table, wired into deploy and local scripts. The migration applied cleanly during live verification against a real database.
- What worked
- Plain .sql migration files are supported, so I did not have to learn a DSL for a one-table change. It handles its own tracking table and locking, and the CLI help made the relevant flags easy to confirm. Running it as a deploy step rather than at service boot kept migration rights out of the running services.
- What got in the way
- Version choice was awkward: the major that matched the project's module format pulled in a transitive dependency with an unfixed advisory, and the clean major is ESM-only. It only worked out because the tool is invoked purely as a CLI and never imported into the build — a project that imports its API would have been stuck choosing between an advisory and a module-format mismatch.