Schema migrations in production are scary. With Xata, they don’t have to be.
Define how your data gets backfilled with SQL statements during the migration.
Learn MoreSchema migrations use pgroll, an open source command-line tool created by Xata, for Postgres databases.
Learn MoreJust like your developer workflow, test your database schema changes in a branch and see a diff of the two.
With simple JSON based migration scripts and your schema history, stay in control of the changes made to your database.
Schema migrations plug right into your CI/CD development workflow and deploy previews.
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.
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
By Tudor Golubenco
• June 29, 2023
Table locking, downtime risks, long running migrations, manual steps, difficult rollbacks. Is there a better way?
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.
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.
Copyright © 2025 Xatabase Inc.
All rights reserved.