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/)