pgroll
A command-line tool for performing zero-downtime, reversible schema migrations in PostgreSQL.
What is pgroll?
pgroll is an open-source command-line tool that enables safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously. It ensures client applications continue working during database updates by applying changes without locking and allowing both old and new schemas to operate concurrently, even with breaking changes. This approach eliminates migration risks and simplifies application rollouts with instant rollback capabilities.
Database administrators and backend developers managing PostgreSQL databases who need to perform schema migrations without downtime or risk of breaking existing applications. It is particularly valuable for teams running production services that require continuous availability.
Developers choose pgroll over traditional migration tools because it guarantees zero-downtime migrations and instant rollbacks by maintaining simultaneous schema versions using PostgreSQL views. Its unique selling point is the ability to handle breaking changes safely without locking the database, working with existing schemas and automatically backfilling columns as needed.
Overview
PostgreSQL zero-downtime migrations made easy
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
