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