Skip to main content
skill CX Codex

database-migrations-sql-migrations — Claude Code skill

database-migrations-sql-migrations — a skill for safe SQL database migrations with zero downtime. Generates migration scripts with rollback plans, data integrity checks, and strategies for PostgreSQL, MySQL, and SQL Server.

MIT 1 installs ★ 50,109 updated 2026-10-29

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a claude-code
Open on GitHub

What database-migrations-sql-migrations does

This skill guides you through designing and deploying schema changes that keep your database available during the process. It produces migration analysis reports, version-controlled scripts, validation suites for pre- and post-deployment, and rollback procedures for each stage.

Chooses between expand-contract or blue-green strategies based on your change type. Handles large datasets with batch processing and parallel execution. Includes monitoring hooks to track progress and surface issues early.

Note: this is a strategic tool that asks clarifying questions about your goals, database constraints, and environment. It does not replace testing in a production-like environment or expert sign-off before deploying to live systems.

What it helps with

  • design a zero-downtime schema migration plan
  • create automated rollback procedures for critical changes
  • validate data integrity before and after migration
  • optimize large-table migrations for performance
  • integrate monitoring and alerts into the migration process

Example prompts for the agent

  • Design a zero-downtime migration to add an index on a large PostgreSQL table
  • Plan a rollback strategy for renaming a column in MySQL without downtime
  • Build a validation suite to check data consistency before and after SQL Server migration

How to install database-migrations-sql-migrations

1Skills CLI (Vercel)

npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a claude-code

2Manually: put the files in place

~/.claude/skills/database-migrations-sql-migrations/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/database-migrations-sql-migrations/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about database-migrations-sql-migrations

How do I install database-migrations-sql-migrations in Claude Code?

Run npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a claude-code, then open ~/.claude/skills/database-migrations-sql-migrations/SKILL.md.

What does database-migrations-sql-migrations do?

Generates safe migration strategies with zero downtime. Creates migration scripts, rollback plans, data validation checks, and performance optimization recommendations for PostgreSQL, MySQL, and SQL Server.

Which SQL databases are supported?

The skill focuses on PostgreSQL, MySQL, and SQL Server. Each database's specific syntax and behavior are accounted for in migration plans.

Source text

SKILL.md · MIT
---
name: database-migrations-sql-migrations
description: "SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Focus on data integrity and rollback plans."
risk: critical
source: community
date_added: "2026-02-27"
---

# 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.

© sickn33 · MIT · sickn33/agentic-awesome-skills

Similar skills

All skills for DevOps and infrastructure →

From the same set187

The whole set →
security-scanning-security-hardening The security-scanning-security-hardening skill coordinates security reviews and remediation across an application, infrastructure, and CI/CD. Use it to structure a phased hardening effort. CX Codex +1 1installs hybrid-cloud-architect The hybrid-cloud-architect skill helps plan hybrid infrastructure across AWS, Azure, GCP, and private clouds. Use it for connectivity, workload placement, migrations, Kubernetes, and disaster recovery. CX Codex +1 1installs seo-content-planner seo-content-planner turns one topic into a sectioned article outline, a topic cluster map and a publishing calendar with keyword targets. CX Codex +1 1installs database-migrations-migration-observability database-migrations-migration-observability is a Claude Code skill for monitoring database migrations and CDC pipelines. Track migration errors, processed records, and replication lag with Prometheus metrics. CX Codex +1 1installs arm-cortex-expert arm-cortex-expert — a skill that helps write firmware and peripheral drivers for ARM Cortex-M boards: Teensy 4.x, STM32, nRF52, SAMD. You get a module you can build, not a fragment. CX Codex +1 ★ 50,109repo stars vexor Guides the agent when performing semantic file searches via the external Vexor CLI. Useful for querying codebases by meaning rather than exact strings. CX Codex +1 ★ 50,109repo stars vector-database-engineer vector-database-engineer picks a vector store and sets up embedding search for RAG, recommendations or similarity lookup. Comes in when recall and latency start to matter. CX Codex +1 ★ 50,109repo stars rag-implementation rag-implementation is a Claude Code skill that guides an eight-phase RAG implementation, from embedding selection to hybrid search and quality evaluation. CX Codex +1 ★ 50,109repo stars

Project sponsors

Companies that keep this analytics open