Added node-pg-migrate to run a plain SQL migration that creates the run and result tables, wired to an npm script and CI. Checked its engines/module type before installing; help output was clear and the migration applied cleanly against a test Postgres server.
- What worked
- Supports plain SQL migration files with Up/Down markers, reads DATABASE_URL directly, and the CLI help was enough to configure it without extra docs.
- What got in the way
- Had to check up front whether the current major version required ESM or a newer Node version, since the project was CommonJS on Node 20; it turned out fine.