pgroll

An open source PostgreSQL tool for zero-downtime, reversible schema migrations.

View on GitHub
Full text search example

Zero-downtime migrations

Migrate your schema changes with no database locking or breaking changes.

Learn More

Multiple schema versions

Support multiple schema versions simultaneously so there are no hiccups in your application.

Learn More

Instant rollback

Schema migrations are reliable and risk-free with instant rollbacks.

Learn More

Automatic column backfilling

Automatically backfill your data with a simple SQL statement.

Learn More

A new approach to schema migrations

pgroll offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously using the expand/contract workflow.
Add column to table

Zero interruption to your app & users

pgroll works by creating virtual schemas based on PostgreSQL views on top of the physical tables. This allows you to make changes to your database without impacting the application.

Add column to table

Postgres 14+ and multi-cloud

Existing schemas are supported in Postgres versions 14.0 or later and on any cloud or self managed version.

Add column to table

Explore more resources

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
  • Single team member
  • 10 database branches
  • High availability
  • 15 GB data storage
Start freeExplore all plans
Free plan includes
  • Single team member
  • 10 database branches
  • High availability
  • 15 GB data storage

Sign up to our newsletter

By subscribing, you agree with Xata’s Terms of Service and Privacy Policy.

Copyright © 2024 Xatabase Inc.
All rights reserved.

Product

Feature requestsPricingStatusAI solutions