Zero-downtime schema migrations

Schema migrations in production are scary. With Xata, they don’t have to be.

Start free

Branching

Test your changes in a branch first before migrating to production.

Learn More

Automatic column backfilling

Define how your data gets backfilled with SQL statements during the migration.

Learn More

Migration history

View all schema changes made since the creation of the database.

Learn More

Built on open source

Schema migrations use pgroll, an open source command-line tool created by Xata, for Postgres databases.

Learn More

Diff 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

Zero-downtime schema migrations in PostgreSQL

How to perform Postgres schema changes in production with zero downtime

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.

Introducing pgroll: zero-downtime, reversible, schema migrations for Postgres

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

Postgres schema changes are still a PITA

By Tudor Golubenco

• June 29, 2023

Table locking, downtime risks, long running migrations, manual steps, difficult rollbacks. Is there a better way?

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.

View source on GitHub

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.

Free plan includes