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
Postgres Cafe: Exploring pgroll for zero-downtime schema changes
By Gulcin Yildirim Jelinek
• December 18, 2024
Discover how pgroll helps teams manage schema changes with ease in our new Postgres Cafe blog and video series.
pgroll 0.8.0 update
By Andrew Farries
• December 9, 2024
Learn about the latest changes in pgroll in the v0.8.0 release as we add new CLI commands, expand what's possible with multi-column keys and constraints and add performance benchmarks.
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.
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.