Zero-downtime schema migrations
Schema migrations in production are scary. With Xata, they don’t have to be.
Automatic column backfilling
Define how your data gets backfilled with SQL statements during the migration.
Learn MoreBuilt on open source
Schema migrations use pgroll, an open source command-line tool created by Xata, for Postgres databases.
Learn MoreDiff your changes
Just like your developer workflow, test your database schema changes in a branch and see a diff of the two.
Stay in control
With simple JSON based migration scripts and your schema history, stay in control of the changes made to your database.
Integrated developer workflow
Schema migrations plug right into your CI/CD development workflow and deploy previews.
Explore more resources
Schema changes and the power of expand-contract with pgroll
By Andrew Farries
• November 13, 2024
A pgconf EU talk recap covering how the expand-contract pattern and pgroll enable zero-downtime schema changes and rollbacks.
pgroll 0.7.0 update
By Andrew Farries
• October 23, 2024
Learn about the latest changes in pgroll in the 0.7.0 release as we continue developing it into a leading open-source schema migration tool for Postgres.
pgroll 0.6.0 update
By Andrew Farries
• July 19, 2024
Learn about the latest changes in pgroll in the 0.6.0 release as we continue to build and turn it into a first-class open-source schema migration tool for Postgres.
Learn by example
Try out a sample app
Built with Next.js, Chakra UI, and Xata, the sample app will help you learn how to query, paginate and search records with a heavy focus on file attachments.
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.
- Single team member
- 10 database branches
- High availability
- 15 GB data storage
- Single team member
- 10 database branches
- High availability
- 15 GB data storage
Copyright © 2024 Xatabase Inc.
All rights reserved.