rootcastleco/skills/database-migrations-sql-migrations
skills/database-migrations-sql-migrations/SKILL.md
--- name: database-migrations-sql-migrations description: "SQL database migrations with zero-downtime strategies for" PostgreSQL, MySQL, SQL Server allowed-tools: Read Write Edit Bash Grep Glob metadata: version: 1.0.0 tags: database, sql, migrations, postgresql, mysql, flyway, liquibase, alembic, zero-downtime risk: unknown source: rootcastle-rei --- # SQL Database Migration Strategy and Implementation You are a SQL database migration expert specializing in zero-downtime deployments
$ install --global
skillsauthnpx skillsauth add rootcastleco/rei-skills skills/database-migrations-sql-migrationsInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 20, 2026, 5:06 AM5.9s2 files scanned
SKILL.md
- name:
- database-migrations-sql-migrations
- description:
- SQL database migrations with zero-downtime strategies for
- allowed-tools:
- Read Write Edit Bash Grep Glob
- version:
- 1.0.0
- tags:
- database, sql, migrations, postgresql, mysql, flyway, liquibase, alembic,
- risk:
- unknown
- source:
- rootcastle-rei
SQL Database Migration Strategy and Implementation
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.
Use this skill when
- Working on sql database migration strategy and implementation tasks or workflows
- Needing guidance, best practices, or checklists for sql database migration strategy and implementation
Do not use this skill when
- The task is unrelated to sql database migration strategy and implementation
- 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.
Requirements
$ARGUMENTS
Instructions
- Clarify goals, constraints, and required inputs.
- Apply relevant best practices and validate outcomes.
- Provide actionable steps and verification.
- If detailed examples are required, open
resources/implementation-playbook.md.
Output Format
- Migration Analysis Report: Detailed breakdown of changes
- Zero-Downtime Implementation Plan: Expand-contract or blue-green strategy
- Migration Scripts: Version-controlled SQL with framework integration
- Validation Suite: Pre and post-migration checks
- Rollback Procedures: Automated and manual rollback scripts
- Performance Optimization: Batch processing, parallel execution
- Monitoring Integration: Progress tracking and alerting
Focus on production-ready SQL migrations with zero-downtime deployment strategies, comprehensive validation, and enterprise-grade safety mechanisms.
Resources
resources/implementation-playbook.mdfor detailed patterns and examples.
🏰 Rei Skills — Curated by Rootcastle Engineering & Innovation | Batuhan Ayrıbaş
Engineering Beyond Boundaries | [email protected]
Related Skills
rootcastleco/copywriting
testing
VerifiedTrustedCommunity
Write, rewrite, or improve marketing copy for any page type. Use when crafting homepage, landing page, pricing, or feature page copy with conversion best practices.
5SKILL.mdUpdated Apr 20, 2026
rootcastleco/ai-engineer
development
VerifiedTrustedCommunity
Build production-ready LLM applications, RAG systems, and intelligent agents. Use when implementing AI features, chatbots, vector search, or agent orchestration.
5SKILL.mdUpdated Apr 18, 2026
rootcastleco/loki-mode
development
VerifiedTrustedCommunity
Multi-agent autonomous startup system for Claude Code. Triggers on "Loki Mode". Orchestrates 100+ specialized agents across engineering, QA, DevOps, security, data/ML, business operations,...
4SKILL.mdUpdated Apr 23, 2026
rootcastleco/llm-evaluation
testing
VerifiedTrustedCommunity
Implement comprehensive evaluation strategies for LLM applications using automated metrics, human feedback, and benchmarking. Use when testing LLM performance, measuring AI application quality, or ...
4SKILL.mdUpdated Apr 23, 2026