pgroll
No phone app
5.1No. 28 of 32
in Database Migration Tools
in Database Migration Tools
- Recognised40% of the score20
- Phone app26% of the score0
- Documented20% of the score37
- Free plan14% of the score30
- Free plan
- Yes
- Runs on
- Linux, Mac, self-hosted, Windows
Summary
pgroll is ranked #28 of 32 in database migration tools on Samsung Mobile US Press. It runs on Linux, macOS, Self-hosted, Windows. There is a free plan.
pgroll plans and pricing
All plansCompared on database migration tools
- Rollback support
- Yespgroll.com
- Self-hosted option
- Yespgroll.com
- Migration format
- mixedpgroll.com
Facts
- Purpose
- pgroll is an open-source command-line tool for safe, reversible PostgreSQL schema migrations that keep multiple schema versions available simultaneously.github.com · 4 Oct 2026
- Downtime
- The project describes migrations as zero-downtime and says changes are applied without locking the database.github.com · 4 Oct 2026
- Backfills
- pgroll automatically backfills columns when needed.github.com · 4 Oct 2026
- Rollbacks
- An active migration can be rolled back to the previous schema version.github.com · 4 Oct 2026
- Migration workflow
- pgroll uses an expand/contract workflow, keeping old and new schema versions accessible during client application rollout.github.com · 4 Oct 2026
- How it works
- It creates virtual schemas using views over physical tables and uses triggers to propagate writes between old and new columns during breaking changes.github.com · 4 Oct 2026
- Database compatibility
- pgroll supports PostgreSQL versions 14 and later and says it works with any PostgreSQL service, including RDS and Aurora.github.com · 4 Oct 2026
- PostgreSQL 14 limitation
- On PostgreSQL 14, row-level security policies are not respected by pgroll's versioned views, so the documentation says pgroll is likely a poor choice when using RLS on that version.github.com · 4 Oct 2026
- Platforms
- Prebuilt binaries are available for Linux, macOS, and Windows; installation is also documented through Homebrew and from source.github.com · 4 Oct 2026
- ORM integration
- pgroll can convert SQL migration statements generated by ORMs; its guide includes examples for Alembic, Django, and Drizzle.github.com · 4 Oct 2026
- ORM limitation
- The ORM guide says generated migrations need manual up and down data migrations, and SQL statements may need manual consolidation into fewer pgroll operations.github.com · 4 Oct 2026
- Client configuration
- Client applications select a schema version by setting PostgreSQL's search_path when connecting.github.com · 4 Oct 2026
- Support
- The project directs users to GitHub Issues, GitHub Discussions, and its Discord server for questions, issues, and feedback.github.com · 4 Oct 2026
- License
- The repository identifies the project as licensed under Apache License 2.0.github.com · 4 Oct 2026
Best pgroll alternatives
See all 12Where it ranks on Samsung Mobile US Press
- Best Database Migration Tools in 2026#28 of 32
- Best Database Testing Tools in 2026#25 of 26
Is pgroll yours?
Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.
Sources
- github.com/xataio/pgroll· checked 4 Oct 2026
- github.com/xataio/pgroll/blob/main/docs/getting-st· checked 4 Oct 2026
- github.com/xataio/pgroll/blob/main/docs/guides/orm· checked 4 Oct 2026
- github.com/xataio/pgroll/blob/main/docs/guides/cli· checked 4 Oct 2026



