postgres-migrations

What problem does it solve?

This Skill addresses the complexities and risks associated with modifying PostgreSQL database schemas in production environments, ensuring data integrity and minimizing downtime.

Core Features & Use Cases

• Safe Schema Changes: Provides patterns for adding, removing, or renaming columns and constraints with minimal locking.
• Idempotent Migrations: Offers strategies for creating migration scripts that can be run multiple times without adverse effects.
• Use Case: Safely add a new email column to your users table, backfill existing data, and add a NOT NULL constraint without locking the table for an extended period.

Quick Start

Use the postgres-migrations skill to safely add a nullable 'phone' column to the 'users' table.