Zero-downtime migrations
Migrate your schema changes with no database locking or breaking changes.
Learn MoreMultiple schema versions
Support multiple schema versions simultaneously so there are no hiccups in your application.
Learn MoreA 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
How to perform Postgres schema changes in production with zero downtime
By Alex Francoeur
• February 2, 2024
Schema migrations are a pain. In this workshop we review the problem space and tools available to make reversible schema changes in production with zero downtime.
How pgroll works under the hood
By Andrew Farries
• November 30, 2023
Learn how pgroll implements zero-downtime schema changes by exploring an example.
Introducing pgroll: zero-downtime, reversible, schema migrations for Postgres
By Carlos Pérez-Aradros Herce
• October 3, 2023
We are excited to ship the first version of pgroll, a command line tool that offers safe and reversible schema migrations for PostgreSQL
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.
- 10 database branches
- High availability
- 15 GB data storage
- 15 GB search engine storage
- 2 GB file attachments
- 250 AI queries per month
- 10 database branches
- High availability
- 15 GB data storage
- 15 GB search engine storage
- 2 GB file attachments
- 250 AI queries per month
