Database Migration Helper
Generate safe, reversible database migrations with zero-downtime strategies
What You Can Do
Transform schema and data changes into production-ready migration packages that protect data integrity and minimize downtime. You can handle column additions, renames, type conversions, and backfills using proven patterns like expand-contract and shadow tables. The skill generates explicit rollback scripts, validation checklists, and phased execution plans that keep applications stable throughout the migration.
Features
Examines current database structure and application code to identify migration risks and compatibility issues
Selects appropriate patterns (expand-contract, shadow tables, feature flags) for your specific change type
Generates SQL with explicit rollback procedures, allowing safe testing and rapid recovery if issues arise
Creates validation queries and checksums to verify data correctness before, during, and after migration
Breaks large migrations into testable stages with rollback triggers and success criteria
Ensures application code continues working during staged schema rollout
Provides step-by-step procedures and triggers for rolling back if migration fails
Identifies downtime windows, locking scenarios, and performance implications per database platform
Example Output
For adding a non-nullable column with computed data:
Migration Phase 1: Expand
- ALTER TABLE users ADD COLUMN account_tier VARCHAR(50) DEFAULT 'standard'
- Rollback: ALTER TABLE users DROP COLUMN account_tier
Migration Phase 2: Backfill
- UPDATE users SET account_tier = CASE WHEN subscription_id IS NOT NULL THEN 'premium' ELSE 'standard' END WHERE account_tier = 'standard'
- Validation: SELECT COUNT(*) FROM users WHERE account_tier IS NULL (should be 0)
- Rollback: UPDATE users SET account_tier = 'standard'
Migration Phase 3: Contract
- ALTER TABLE users ALTER COLUMN account_tier DROP DEFAULT, SET NOT NULL
- Rollback: ALTER TABLE users ALTER COLUMN account_tier SET DEFAULT 'standard'
For renaming a column safely:
Phase 1: Shadow Column
- CREATE TRIGGER sync_old_to_new AFTER INSERT/UPDATE on users
FOR EACH ROW SET NEW.email_address = NEW.contact_email
Phase 2: Dual Write (app code changes)
- Application writes to both contact_email and email_address
- Validation queries verify 100% matching data
Phase 3: Retire Old Column
- DROP TRIGGER sync_old_to_new
- ALTER TABLE users DROP COLUMN contact_email
What's Included
- SKILL.md: Complete migration planning framework with risk analysis checklist
- Migration Pattern Templates: Expand-contract, shadow tables, and feature flag patterns with SQL examples
- Rollback Procedure Checklist: Step-by-step validation and recovery guides
- Pre-Flight Analysis Worksheet: Questions to assess schema, application impact, and downtime tolerance
- Phased Execution Timeline: Template for breaking migrations into stages with success criteria and rollback triggers
Who It's For
- Database Administrators managing production schema changes and operational safety
- Backend Engineers responsible for coordinating code deployments with schema migrations
- Site Reliability Engineers planning zero-downtime operations and disaster recovery
- Technical Architects designing migration strategies for large-scale systems
- DevOps Engineers automating safe database change workflows
Best For
- Large table column additions, renames, or type changes on production systems
- Data backfill and normalization with validation and rollback safeguards
- Multi-phase migrations requiring application code coordination
- Generating rollback procedures and testing migration reversibility
- Assessing downtime impact and selecting appropriate zero-downtime patterns
You might also like
This skill enables you to automatically audit your websites against compliance standards and detect deviations from expected baselines. You can track regulatory requirements, identify policy violations, and generate compliance reports with actionable remediation steps. Monitor multiple sites simultaneously and maintain detailed audit trails for compliance documentation.
Analyze chemical processes systematically to identify hazards, assess risks, and generate safety recommendations. You can perform HAZOP analyses, evaluate compliance with industry standards, conduct root-cause analysis of incidents, and develop emergency response procedures. The skill guides you through structured safety reviews that reduce the likelihood of accidents and regulatory violations.
You'll develop systematic approaches to injectable formulation design, from API selection through sterilization strategy. Claude helps you troubleshoot failed batches by analyzing root causes, recommends regulatory pathways (505(b)(2), ANDA, NDA), and provides science-backed solutions for stability, compatibility, and manufacturability challenges.
You can conduct comprehensive hazard analyses for chemical processes using industry-standard methodologies like HAZOP and LOPA. The skill helps you assess risks quantitatively, identify control gaps, design engineered safeguards, and generate formal documentation for regulatory compliance and process safety management.
Claude analyzes your code diffs and generates standardized commit messages that follow the Conventional Commits specification. The skill automatically determines the correct commit type, scope, and description based on the changes you've made, ensuring your messages are parseable by automation tools while remaining human-readable for code reviewers.
You can transform raw text into structured, labeled datasets for machine learning, analysis, and research. This skill performs named entity recognition, sentiment classification, part-of-speech tagging, and dependency parsing—generating consistent, validated annotations at scale. Use it to prepare corpora, extract entities, classify documents, or perform linguistic analysis without manual annotation.
This skill automates the creation of production-ready deployment validation checklists, infrastructure-as-code templates, and incident response runbooks tailored to your ML stack. You get comprehensive pre-deployment checks covering model validation, data pipeline integrity, infrastructure readiness, and monitoring setup—all customized for your specific models and cloud provider. The skill generates executable runbooks that teams can follow during incidents, including rollback procedures, failover strategies, and diagnostic commands.
Rapidly analyze firmware logs and diagnose hardware issues that cause device failures, connectivity problems, and performance degradation. You'll identify root causes from stack traces, crash dumps, and sensor data, then generate specific optimization recommendations. This skill transforms raw device logs into actionable debugging plans that reduce time-to-resolution from hours to minutes.