Database schema migrations can be challenging, often leading to disruptions and errors in applications that rely on the database. Managing multiple steps and unexpected database locks can make migrations a logistical nightmare. Additionally, rolling back to a previous state is rarely straightforward. In order to address these issues, Xata has created pgroll, an open-source command-line tool for performing schema migrations on Postgres databases. pgroll allows users to define migrations using a high-level JSON format and takes care of executing them. It features instant rollbacks, zero downtime, and automatic backfills. The tool simplifies complex migrations and streamlines the entire process. Xata is excited to release pgroll and welcomes user feedback for further development.
https://xata.io/blog/pgroll-schema-migrations-postgres