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.
Installs into .claude/skills of the current project.
Are you the author of Pgroll Postgresql Zero Downtime Schema Migration?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/agentskillexchange-pgroll-postgresql-zero-downtime-schema-migration)
---
name: "pgroll PostgreSQL Zero-Downtime Schema Migration"
slug: "pgroll-postgresql-zero-downtime-schema-migration"
description: "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."
github_stars: 6408
verification: "security_reviewed"
source: "https://github.com/xataio/pgroll"
category: "Developer Tools"
framework: "Custom Agents"
tool_ecosystem:
github_repo: "xataio/pgroll"
github_stars: 6408
---
# 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](https://golang.org/doc/install) or later.
Basic usage or getting-started notes:
- [Usage](#usage)
- ### Binaries
- Binaries are available for Linux, macOS & Windows, check our [Releases](https://github.com/xataio/pgroll/releases).
- Source: https://github.com/xataio/pgroll
- Extracted from upstream docs: https://raw.githubusercontent.com/xataio/pgroll/HEAD/README.md
## Source
- [Agent Skill Exchange](https://agentskillexchange.com/skills/pgroll-postgresql-zero-downtime-schema-migration/)
