pgroll

An open source PostgreSQL tool for zero-downtime, reversible schema migrations.

View on GitHub

Zero-downtime migrations

Migrate your schema changes with no database locking or breaking changes.

Learn More

Multiple schema versions

Support multiple schema versions simultaneously so there are no hiccups in your application.

Learn More

Instant rollback

Schema migrations are reliable and risk-free with instant rollbacks.

Learn More

Automatic column backfilling

Automatically backfill your data with a simple SQL statement.

Learn More

A new approach to schema migrations

pgroll offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously using the expand/contract workflow.

Zero interruption to your app & users

pgroll works by creating virtual schemas based on PostgreSQL views on top of the physical tables. This allows you to make changes to your database without impacting the application.

Postgres 14+ and multi-cloud

Existing schemas are supported in Postgres versions 14.0 or later and on any cloud or self managed version.

Explore more resources

Start free,
pay as you grow

Xata provides the best free plan in the industry. It is production ready by default and doesn't pause or cool-down. Take your time to build your business and upgrade when you're ready to scale.

Free plan includes