thomwright/postgres-migrations

This is a PostgreSQL migration library for Node.js that enforces strict sequential ordering of migration files, inspired by Stack Overflow's deployment system. It provides a simple API for running database migrations where SQL files are numbered sequentially (e.g., 1_create-table.sql, 2_alter-table.sql) and executed in that exact order. The library tracks applied migrations in a dedicated table, validates file integrity through hashing, and prevents concurrent migration runs using PostgreSQL advisory locks. It's designed for development teams who need reliable, repeatable database schema changes with clear audit trails and conflict detection.