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
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.
Introducing multi-version schema migrations
By Andrew Farries
• July 16, 2024
Today's release of multi-version schema migrations addresses one of the most common pain points of application deployment - keeping your application code and database schema in sync. You can now present two versions of your schema, both old and new, to client applications.
Schema changes and the Postgres lock queue
By Andrew Farries
• June 18, 2024
Learn how schema changes can cause downtime by locking out reads and writes and how migration tools can avoid it by using lock timeouts, along with backoff and retry strategies.
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.
- 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
Copyright © 2024 Xatabase Inc.
All rights reserved.