用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/microwind/ai-skills --skill migration-validator命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
基于 SOC 职业分类
正在显示 SKILL.md
| name | migration-validator |
| description | Enhanced skill for migration-validator |
| license | MIT |
详细的分析和验证 迁移-validator.
核心原则: Bad 迁移 lock production, lose data, or cause downtime. 验证 迁移 before running.
始终:
触发短语:
Problem:
ALTER TABLE MODIFY COLUMN type on 1 billion row table (hours of table lock)
Consequence:
- Production database locked
- All queries blocked
- Downtime
Solution:
Use online schema migration tools or shadow migration
Problem:
ALTER TABLE DROP COLUMN without backing up data first
Consequence:
- Data lost forever
- No recovery possible
- Regulatory violations
Solution:
Backup first, verify before dropping
Problem:
Converting string column to integer without validation
Consequence:
- Non-numeric values can't convert
- Migration fails
- Partial data loss
Solution:
Validate data before conversion, create temp column
| 问题 | 解决方案 |
|---|---|
| "Not sure where to start" | 识别 the specific issue using the 常见问题 section above. |
| "性能 is poor" | Profile first to 识别 bottleneck before optimizing. |
| "Not sure about 最佳实践" | 检查 the 验证检查清单 to understand quality standards. |
❌ No backup before 迁移 ❌ Long-running 迁移 on live 表 ❌ No rollback plan ❌ Data conversion without validation ❌ Mixing multiple changes in one 迁移 ❌ No 测试 run on staging