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
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.
This skill helps you systematically assess integration needs across your systems, design architecture patterns that scale with your organization, and identify technical and operational risks before implementation. You'll receive architecture recommendations aligned to your business constraints, clear integration roadmaps, and risk mitigation strategies that reduce deployment surprises. Get structured decision records suitable for architecture review boards and engineering teams.
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 helps you systematically analyze service mesh architectures, identify inter-service communication failures, and design optimal routing and security policies. You'll receive step-by-step troubleshooting guidance tailored to your mesh platform (Istio, Linkerd, Consul), configuration validation reports, and architectural recommendations that reduce latency, improve observability, and tighten security posture.
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.
Build scalable internal developer platform architectures that reduce cognitive load and standardize workflows for your development organization. Document golden paths that guide developers through common tasks like onboarding, deployment, and troubleshooting. Map platform capabilities, integrations, and service topology to align with your engineering scale and technical strategy.
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.