mcpField
D
database-migrations-sql-migrations

database-migrations-sql-migrations

github.com/sickn33Data & databases48.7k436 installsUpdated today
Repository

About database-migrations-sql-migrations

A skill for planning and implementing SQL database migrations, aimed at teams changing production schemas while protecting data integrity and limiting downtime. It covers migration plans, validation, rollback, and performance considerations for PostgreSQL, MySQL, and SQL Server.

Key features

  1. 01Plan zero-downtime migrations
  2. 02Design rollback procedures
  3. 03Create version-controlled SQL scripts
  4. 04Validate before and after migrations
  5. 05Optimize batch processing and execution

Use cases

  1. 01Planning production schema changes
  2. 02Preparing rollback for critical migrations
  3. 03Migrating large datasets
  4. 04Checking integrity before and after migration

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations

After installing, type/database-migrations-sql-migrationsin Claude Code to confirm it loaded.

Bundled filesresources/implementation-playbook.md

Details

From the project README

SQL Database Migration Strategy and Implementation

Overview

You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.

When to Use This Skill

  • Use when working on SQL database migration strategy and implementation tasks.
  • Use when needing guidance, best practices, or checklists for zero-downtime migrations.
  • Use when designing rollback procedures for critical schema changes.

Do Not Use This Skill When

  • The task is unrelated to SQL database migration strategy.
  • You need a different domain or tool outside this scope.

Context

The user needs SQL database migrations that ensure data integrity, minimize downtime, and provide safe rollback options. Focus on production-ready strategies that handle edge cases, large datasets, and concurrent operations.

Instructions

  • Clarify goals, constraints, and required inputs.
  • Apply relevant best practices and validate outcomes.
  • Provide actionable steps and verification.
  • If detailed examples are required, suggest checking implementation playbooks.

Output Format

  1. Migration Analysis Report: Detailed breakdown of changes
  2. Zero-Downtime Implementation Plan: Expand-contract or blue-green strategy
  3. Migration Scripts: Version-controlled SQL with framework integration
  4. Validation Suite: Pre and post-migration checks
  5. Rollback Procedures: Automated and manual rollback scripts
  6. Performance Optimization: Batch processing, parallel execution
  7. Monitoring Integration: Progress tracking and alerting

Resources

  • Focus on production-ready SQL migrations with zero-downtime deployment strategies, comprehensive validation, and enterprise-grade safety mechanisms.

Limitations

  • Use this skill only when the task clearly matches the scope described above.
  • Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
  • Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.

Comments

Markdown supported