xataio/pgroll

Health v2 · maintenance only

Adoption not part of the score

6560 stars · 154 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pgroll is an open-source command-line tool for safe, reversible, zero-downtime schema migrations on PostgreSQL. It serves multiple schema versions simultaneously so client applications keep working during migrations, with automatic backfills and instant rollbacks.

Use cases

• run zero-downtime schema migrations on postgres
• add a column to a large table without locking the database
• roll back a database schema change instantly
• migrate a production postgres schema while the app keeps running
• backfill column data automatically during a migration
• apply breaking schema changes safely to an existing database

When to choose

• you run PostgreSQL 14+ in production and need schema changes without downtime or locks
• you want reversible migrations with instant rollback capability
• you need old and new schema versions to coexist during application rollout
• you work with managed Postgres like RDS or Aurora and need a dependency-free single binary

When to avoid

• you use a database other than PostgreSQL
• you only need simple migrations on small databases where brief locks are acceptable
• you want a full ORM-integrated migration framework rather than a standalone CLI

Facets

cli-tool · maturity active

database deployment cli developer-tools databases developer-tools windows cli cross-platform postgresql schema-migrations zero-downtime database-migrations expand-contract backfill devops linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="xataio/pgroll")