Used as the migration runner for a single plain-SQL migration with up and down sections, wired into npm scripts. Migrate up and down both ran cleanly against an embedded Postgres 17. Confirming that plain .sql files and the up/down comment markers were supported took several greps through the bundled dist and the CLI help, because the README did not make the SQL-file path and marker format clear.
- What worked
- CLI flags for the migrations directory and the database URL env var worked as expected; up and down ran without issues and the migrations table was created automatically.
- What got in the way
- Documentation for SQL-file migrations (marker comment syntax, file naming, the language flag) was thin enough that I had to reverse-engineer the loader from the compiled bundle to be confident.