{"id":"6f5331ea-e489-4bee-9532-ebf0ab3d2311","shortId":"ZPNhLL","kind":"skill","title":"pgroll PostgreSQL Zero-Downtime Schema Migration","tagline":"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.","description":"# pgroll PostgreSQL Zero-Downtime Schema Migration\n\npgroll 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.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- go install github.com/xataio/pgroll@latest\n- brew tap xataio/pgroll\n- brew install pgroll\n\nRequirements and caveats from upstream:\n- Note: requires [Go 1.24](https://golang.org/doc/install) or later.\n\nBasic usage or getting-started notes:\n- [Usage](#usage)\n- ### Binaries\n- Binaries are available for Linux, macOS & Windows, check our [Releases](https://github.com/xataio/pgroll/releases).\n\n- Source: https://github.com/xataio/pgroll\n- Extracted from upstream docs: https://raw.githubusercontent.com/xataio/pgroll/HEAD/README.md\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/pgroll-postgresql-zero-downtime-schema-migration/)","tags":["pgroll","postgresql","zero","downtime","schema","migration","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list"],"capabilities":["skill","source-agentskillexchange","skill-pgroll-postgresql-zero-downtime-schema-migration","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/pgroll-postgresql-zero-downtime-schema-migration","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,060 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:11:43.439Z","embedding":null,"createdAt":"2026-05-18T13:18:20.185Z","updatedAt":"2026-05-18T19:11:43.439Z","lastSeenAt":"2026-05-18T19:11:43.439Z","tsv":"'/doc/install)':135 '/skills/pgroll-postgresql-zero-downtime-schema-migration/)':178 '/xataio/pgroll':164 '/xataio/pgroll/head/readme.md':171 '/xataio/pgroll/releases).':160 '/xataio/pgroll@latest':117 '1.24':132 'agent':173 'agentskillexchange.com':177 'agentskillexchange.com/skills/pgroll-postgresql-zero-downtime-schema-migration/)':176 'automat':46,96 'avail':150 'backfil':47,97 'basic':138 'binari':147,148 'brew':118,121 'caveat':126 'check':155 'cli':14,64 'contract':34,84 'doc':168 'downtim':5,22,55,72 'environ':112 'exchang':175 'expand':32,82 'expand-and-contract':31,81 'extract':165 'get':142 'getting-start':141 'github.com':116,159,163 'github.com/xataio/pgroll':162 'github.com/xataio/pgroll/releases).':158 'github.com/xataio/pgroll@latest':115 'go':113,131 'golang.org':134 'golang.org/doc/install)':133 'instal':101,105,114,122 'instant':49,99 'keep':37,87 'later':137 'linux':152 'maco':153 'match':110 'migrat':7,25,57,75 'new':40,90 'note':129,144 'old':38,88 'open':12,62 'open-sourc':11,61 'path':108 'pattern':35,85 'perform':19,69 'pgroll':1,8,51,58,123 'postgresql':2,27,52,77 'raw.githubusercontent.com':170 'raw.githubusercontent.com/xataio/pgroll/head/readme.md':169 'releas':157 'requir':124,130 'revers':23,73 'rollback':50,100 'run':43,93 'schema':6,24,41,56,74,91 'setup':107 'simultan':44,94 'skill':174 'skill-pgroll-postgresql-zero-downtime-schema-migration' 'sourc':13,63,161,172 'source-agentskillexchange' 'start':143 'tap':119 'tool':15,65 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'upstream':104,128,167 'usag':139,145,146 'use':29,79,102 'version':42,92 'window':154 'xata':17,67 'xataio/pgroll':120 'zero':4,21,54,71 'zero-downtim':3,20,53,70","prices":[{"id":"a5e66dfe-d937-4ef1-b134-6706a2d08bf9","listingId":"6f5331ea-e489-4bee-9532-ebf0ab3d2311","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:18:20.185Z"}],"sources":[{"listingId":"6f5331ea-e489-4bee-9532-ebf0ab3d2311","source":"github","sourceId":"agentskillexchange/skills/pgroll-postgresql-zero-downtime-schema-migration","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/pgroll-postgresql-zero-downtime-schema-migration","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:20.185Z","lastSeenAt":"2026-05-18T19:11:43.439Z"}],"details":{"listingId":"6f5331ea-e489-4bee-9532-ebf0ab3d2311","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"pgroll-postgresql-zero-downtime-schema-migration","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"0dc2310a20b7d86fc4c884b804d2b0acbf549926","skill_md_path":"skills/pgroll-postgresql-zero-downtime-schema-migration/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/pgroll-postgresql-zero-downtime-schema-migration"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"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."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/pgroll-postgresql-zero-downtime-schema-migration"},"updatedAt":"2026-05-18T19:11:43.439Z"}}