migration-advisor

What problem does it solve?

This Skill provides guidance and best practices for performing safe, reversible database schema and data migrations across various database systems and ORMs, minimizing downtime and preventing data loss.

Core Features & Use Cases

• Schema Change Best Practices: Learn how to safely add/remove columns, create indexes, and rename tables without locking production databases.
• Data Migration Strategies: Implement batch processing and transactional safety for large data transformations.
• Zero-Downtime Deployments: Understand the expand-contract pattern for critical production changes.
• ORM Integration: Get specific advice for Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Quick Start

Provide guidance on how to safely add a new nullable column to a PostgreSQL table named 'users'.