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
Rapidly analyze production incidents by correlating observability signals—logs, metrics, traces, and events—to identify the true root cause instead of symptoms. You'll reconstruct incident timelines, quantify impact scope, and generate both immediate remediation steps and long-term prevention measures.
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 submit your Solidity smart contracts for comprehensive security analysis, vulnerability detection, and gas optimization recommendations. Claude reviews your code against known attack vectors, design patterns, and best practices—identifying reentrancy risks, overflow/underflow issues, access control flaws, and inefficient operations. You receive actionable fix recommendations with explanations of the security implications and gas savings potential.
You can design end-to-end NGS pipelines tailored to your experiment type (WGS, WES, RNA-seq, targeted), troubleshoot pipeline failures by analyzing QC metrics and logs, and optimize performance by fine-tuning parameters and identifying bottlenecks. This skill handles the full workflow from raw sequencing data quality assessment through variant interpretation and annotation.
This skill guides you through designing Kalman filters for your specific state estimation and sensor fusion problems. You'll learn to diagnose filter divergence, tune covariance matrices (Q and R), and validate observability—turning mathematical theory into production-ready filters. The skill provides step-by-step workflows, diagnostic tools, and practical templates for common applications like GPS/IMU fusion, SLAM, and aircraft navigation.
You can rapidly identify root causes of training failures, data pipeline breakdowns, and model serving issues by analyzing logs, metrics, and infrastructure state. Claude examines your system events, resource utilization patterns, and error traces to pinpoint performance bottlenecks, data quality problems, and deployment misconfigurations—then recommends targeted remediation steps.
Diagnose and resolve computer vision model failures using a structured, multi-angle debugging framework. You'll systematically investigate root causes across model architecture, data quality, preprocessing, and inference stages—then receive targeted fixes to get your model back on track.
You can accelerate your entire antenna design workflow—from initial concept to optimized specifications—by leveraging Claude's knowledge of electromagnetic theory, antenna types, and design trade-offs. Claude helps you parameterize designs, identify optimal configurations for your frequency band and application, and prepare detailed briefs for simulation and manufacturing. You'll generate design reviews, impedance-matching solutions, and validation checklists without context-switching to multiple tools.