SKILL32backend-data
Evolving PostgreSQL Schemas Safely
Plans compatibility-first PostgreSQL changes across DDL, backfills, validation, application rollout, and cleanup.
Primary benefit
Turns risky production schema changes into staged operations with explicit lock, rewrite, compatibility, and rollback considerations.When to use
Use when changing a PostgreSQL schema that already contains production data or serves live traffic, especially for columns, constraints, indexes, types, backfills, renames, or destructive cleanup.
When not to use
Do not use for disposable local schemas with no retained data, compatibility window, or production traffic.
Use cases
Add a required column to a large live table
Plan a rename or type migration without breaking rolling application deploys
Example prompts
Use evolving-postgres-schemas-safely to design an expand-migrate-contract plan for this production migration.Install this skill
Choose the command for your operating system and run it from the repository root.
Bash
./install.sh --skill evolving-postgres-schemas-safelyPowerShell
./install.ps1 --skill evolving-postgres-schemas-safelyChatGPT
Download Skill ZIPCompatibility
- Surfaces
- ChatGPT · Codex · Claude Code
- Operating systems
- Linux · macOS · Windows
- Install modes
- PluginFilesystem
Dependencies
Part of systems
Curated systems that canonically include this method.