Schema changes 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 changes 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 changes plug right into your CI/CD development workflow and deploy previews.
By Noémi Ványi
• May 9, 2025
pgroll v0.12 includes usability improvements like verbose mode and idempotent migrate command.
By Noémi Ványi
• April 8, 2025
pgroll v0.11 includes support for YAML migration files, a fix for the bookkeeping of pgroll, and smaller usability improvements.
By Andrew Farries, Noémi Ványi
• February 28, 2025
pgroll v0.10 includes one breaking change, a new subcommand to convert SQL statements into pgroll operations and improvements to adding default values to existing tables.