database-migrations-sql-migrations

This skill provides expert-level guidance and tooling for SQL database migrations, focusing on zero-downtime deployments and maintaining data integrity. It's designed for PostgreSQL, MySQL, and SQL Server environments, offering comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.

The skill leverages best practices for handling edge cases, large datasets, and concurrent operations. It provides actionable steps and verification methods to ensure production-ready strategies. Detailed examples and implementation playbooks are available for reference.

The output includes migration analysis reports, implementation plans, version-controlled SQL scripts, validation suites, rollback procedures, performance optimizations, and monitoring integration, all geared towards enterprise-grade safety and reliability.

What It Does

Provides SQL database migration strategies and implementation, focusing on zero-downtime deployments, data integrity, and rollback procedures for PostgreSQL, MySQL, and SQL Server.

When To Use

When working on SQL database migration tasks requiring zero-downtime, data integrity, or rollback capabilities for PostgreSQL, MySQL, or SQL Server.

Installation

Copy SKILL.md to your skills directory