pgroll PostgreSQL Zero-Downtime Schema Migration
pgroll is an open-source CLI tool by Xata that performs zero-downtime, reversible schema migrations for PostgreSQL. It uses the expand-and-contract pattern to keep old and new schema versions running simultaneously with automatic backfilling and instant rollback.
What it does
pgroll PostgreSQL Zero-Downtime Schema Migration
pgroll is an open-source CLI tool by Xata that performs zero-downtime, reversible schema migrations for PostgreSQL. It uses the expand-and-contract pattern to keep old and new schema versions running simultaneously with automatic backfilling and instant rollback.
Installation
Use the upstream install or setup path that matches your environment:
- go install github.com/xataio/pgroll@latest
- brew tap xataio/pgroll
- brew install pgroll
Requirements and caveats from upstream:
- Note: requires Go 1.24 or later.
Basic usage or getting-started notes:
-
Binaries
-
Binaries are available for Linux, macOS & Windows, check our Releases.
-
Source: https://github.com/xataio/pgroll
-
Extracted from upstream docs: https://raw.githubusercontent.com/xataio/pgroll/HEAD/README.md
Source
Capabilities
Install
Quality
deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,060 chars)