Skip to content

borghei/Claude-Skills / engineering/migration-architect

migration-architect

Verified

Plans zero-downtime migrations with compatibility validation, rollback strategies, and phased execution plans. Use when migrating databases, APIs, infrastructure, or services between platforms or versions.

expected_outputs/schema_compatibility_report.txt

View on GitHub
================================================================================
COMPATIBILITY ANALYSIS REPORT
================================================================================
Analysis Date: 2026-02-16T13:47:27.050459
Overall Compatibility: POTENTIALLY_INCOMPATIBLE

SUMMARY
----------------------------------------
Breaking Changes: 0
Potentially Breaking: 4
Non-Breaking Changes: 0
Additive Changes: 0
Total Issues Found: 4

RISK ASSESSMENT
----------------------------------------
Overall Risk: medium
Deployment Risk: safe_independent_deployment
Rollback Complexity: low
Testing Requirements: ['integration_testing', 'regression_testing', 'data_migration_testing']

POTENTIALLY BREAKING ISSUES
----------------------------------------
• New check constraint 'phone IS NULL OR LENGTH(phone) >= 10' added to table 'users'
  Field: tables.users.constraints.check
  Impact: New check constraint may reject existing data
  Migration: Validate existing data complies with new constraint
  Affected Operations: INSERT, UPDATE

• New check constraint 'bio IS NULL OR LENGTH(bio) <= 2000' added to table 'user_profiles'
  Field: tables.user_profiles.constraints.check
  Impact: New check constraint may reject existing data
  Migration: Validate existing data complies with new constraint
  Affected Operations: INSERT, UPDATE

• New check constraint 'language IN ('en', 'es', 'fr', 'de', 'it', 'pt', 'ru', 'ja', 'ko', 'zh')' added to table 'user_profiles'
  Field: tables.user_profiles.constraints.check
  Impact: New check constraint may reject existing data
  Migration: Validate existing data complies with new constraint
  Affected Operations: INSERT, UPDATE

• New check constraint 'session_type IN ('web', 'mobile', 'api', 'admin')' added to table 'user_sessions'
  Field: tables.user_sessions.constraints.check
  Impact: New check constraint may reject existing data
  Migration: Validate existing data complies with new constraint
  Affected Operations: INSERT, UPDATE

SUGGESTED MIGRATION SCRIPTS
----------------------------------------
1. Create new table user_preferences
   Type: sql
   Script:
     CREATE TABLE user_preferences (
       id bigint NOT NULL,
       user_id bigint NOT NULL,
       preference_key varchar NOT NULL,
       preference_value json,
       created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
       updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
     );

2. Add column email_verified_at to table users
   Type: sql
   Script:
     ALTER TABLE users ADD COLUMN email_verified_at timestamp;

3. Add column phone_verified_at to table users
   Type: sql
   Script:
     ALTER TABLE users ADD COLUMN phone_verified_at timestamp;

4. Add column two_factor_enabled to table users
   Type: sql
   Script:
     ALTER TABLE users ADD COLUMN two_factor_enabled boolean NOT NULL DEFAULT False;

5. Add column last_login_at to table users
   Type: sql
   Script:
     ALTER TABLE users ADD COLUMN last_login_at timestamp;

6. Add check constraint to users
   Type: sql
   Script:
     ALTER TABLE users ADD CONSTRAINT check_users CHECK (phone IS NULL OR LENGTH(phone) >= 10);

7. Add column timezone to table user_profiles
   Type: sql
   Script:
     ALTER TABLE user_profiles ADD COLUMN timezone varchar DEFAULT UTC;

8. Add column language to table user_profiles
   Type: sql
   Script:
     ALTER TABLE user_profiles ADD COLUMN language varchar NOT NULL DEFAULT en;

9. Add check constraint to user_profiles
   Type: sql
   Script:
     ALTER TABLE user_profiles ADD CONSTRAINT check_user_profiles CHECK (bio IS NULL OR LENGTH(bio) <= 2000);

10. Add check constraint to user_profiles
   Type: sql
   Script:
     ALTER TABLE user_profiles ADD CONSTRAINT check_user_profiles CHECK (language IN ('en', 'es', 'fr', 'de', 'it', 'pt', 'ru', 'ja', 'ko', 'zh'));

11. Add column session_type to table user_sessions
   Type: sql
   Script:
     ALTER TABLE user_sessions ADD COLUMN session_type varchar NOT NULL DEFAULT web;

12. Add column is_mobile to table user_sessions
   Type: sql
   Script:
     ALTER TABLE user_sessions ADD COLUMN is_mobile boolean NOT NULL DEFAULT False;

13. Add check constraint to user_sessions
   Type: sql
   Script:
     ALTER TABLE user_sessions ADD CONSTRAINT check_user_sessions CHECK (session_type IN ('web', 'mobile', 'api', 'admin'));

RECOMMENDATIONS
----------------------------------------
1. Conduct thorough testing with realistic data volumes
2. Implement monitoring for migration success metrics
3. Test all migration scripts in staging environment
4. Implement migration progress monitoring
5. Create detailed communication plan for stakeholders
6. Implement feature flags for gradual rollout
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 322kUpdated Claude CodeCodexVerifiedInstall
xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release.Stars: 118kUpdated Claude CodeCodexVerifiedInstall