Database Migration Patterns

What it does

This skill provides guidance and recommendations for applying established database migration patterns. It helps users understand common challenges in evolving database schemas, suggesting proven solutions like shadow tables, blue/green deployments, and strangler fig application architectures to minimize downtime and risk during changes. The skill aims to facilitate smoother transitions when modifying databases.

When to use it

• You're planning a significant schema change for an existing production database.
• Downtime needs to be minimized during a database upgrade or migration.
• You want to understand different strategies for rolling out new database features incrementally.
• You’re facing challenges with data consistency and rollback capabilities during database updates.

Key capabilities

• Provides descriptions of common database migration patterns.
• Offers recommendations based on specific change scenarios.
• Explains the trade-offs associated with different approaches.
• Suggests strategies for minimizing downtime and risk.

Example prompts

• "What are some good options for migrating a large table schema with minimal downtime?"
• "Explain the strangler fig pattern in the context of database migrations."
• "I need to add a new index to my production database; what's the safest way to do it?"

Tips & gotchas

The skill assumes some familiarity with database concepts and terminology. While it provides guidance, implementing these patterns often requires careful planning and execution by experienced database administrators or developers.