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
npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a claude-codeWhat 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-code2Manually: put the files in place
~/.claude/skills/database-migrations-sql-migrations/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/database-migrations-sql-migrations/
1Skills CLI (Vercel)
npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a codex2Manually: put the files in place
.agents/skills/database-migrations-sql-migrations/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a cursor2Manually: put the files in place
.cursor/skills/database-migrations-sql-migrations/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install sickn33/agentic-awesome-skills skills/database-migrations-sql-migrations2Manually: put the files in place
.github/skills/database-migrations-sql-migrations/SKILL.md1Skills CLI (Vercel)
npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a gemini-cli2Platform CLI
gemini skills install https://github.com/sickn33/agentic-awesome-skills --path skills/database-migrations-sql-migrationsManually: put the files in place
.devin/skills/database-migrations-sql-migrations/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add sickn33/agentic-awesome-skills --skill database-migrations-sql-migrations -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
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