database-migration-management

Manage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations in PostgreSQL and MySQL.

By aj-geddes · 482 installs

npx skills add aj-geddes/useful-ai-prompts --skill database-migration-management

Source repository · Upstream listing

Database Migration Management Table of Contents [Overview]( overview) [When to Use]( when to use) [Quick Start]( quick start) [Reference Guides]( reference guides) [Best Practices]( best practices) Overview Implement robust database migration systems with version control, rollback capabilities, and data transformation strategies. Includes migration frameworks and production deployment patterns. When to Use Schema versioning and evolution Data transformations and cleanup Adding/removing tables and columns Index creation and optimization Migration testing and validation Rollback planning and execution Multi environment deployments Quick Start Minimal working example: Reference Guides Detailed implementations in the references/ directory: Guide Contents [Adding Columns](references/adding columns.md) Adding Columns [Renaming Columns](references/renaming columns.md) Renaming Columns [Creating Indexes Non blocking](references/creating indexes non blocking.md) Creating Indexes Non blocking [Data Transformations](references/data transformations.md) Data Transformations [Table Structure Changes](references/table structure changes.md) Table Structure Changes Best Practices ✅ DO Follow established patterns and conventions Write clean, maintainable code Add appropriate documentation Test thoroughly before deploying ❌ DON'T Skip testing or validation Ignore error handling Hard code configuration values