pg_migrate: PostgreSQL Migration Tool
pg_migrate is a lightweight command-line utility designed to streamline the management of PostgreSQL database schemas, views, triggers, and functions through structured migrations. It supports recursive directory traversal to execute SQL migration files, ensuring that both forward and backward migrations are seamlessly handled for efficient database version control.
Features
Recursive directory traversal for automatic detection and execution of migration files suffixed with -up.sql and -down.sql.
Support for simulating migrations with the -p flag, allowing users to preview actions before committing changes.
Transactional migrations that abort on failure, ensuring database integrity and consistency.
Provisioning feature to create a tracking table for migration history, enabling easy monitoring of applied migrations.
Compatible with amd64 Linux and macOS, providing flexibility for diverse development environments.