agentsclimarketplace

Database migration review

Skill dss-time/repo-doctor-skills/plugins/repo-doctor/skills/database-migration-review

Bilingual cross-platform AI Skills framework｜双语跨平台 AI Skills 工程框架

Install
npx -y skills add dss-time/repo-doctor-skills --skill database-migration-review

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Review a concrete database schema or data migration for reversibility, data safety, locking, backfill, replication, compatibility, zero-downtime rollout, validation, and rollback. Use for migration-specific risk; do not perform generic impact analysis, execute migrations, connect to production, or modify migration files. 审查具体数据库 Schema 或数据迁移的可逆性、数据安全、锁、回填、复制、兼容、零停机发布、验证和回滚。用于迁移专项风险；不替代通用影响分析，不执行迁移、不连接生产，也不修改迁移文件。

SKILL.md

3.8 KB, as published. Nobody here has run it

Database Migration Review（数据库迁移审查）

Use the section matching the user's language. 使用与用户输入语言一致的章节。

Database Migration Review

Review one concrete migration using repository evidence. Do not execute it or connect to any production system.

Boundary

  • Route generic blast radius to change-impact-analysis, implementation planning to safe-change-plan, and edits to safe-fix-implementation.
  • Do not infer engine behavior, table size, traffic, replication topology, or maintenance windows without evidence.
  • Keep migration, application, configuration, and data unchanged.

Workflow

  1. Identify database engine/version, migration framework, up/down operations, affected objects, application versions, deployment order, and available size or traffic evidence.
  2. Separate schema change, data migration/backfill, and application rollout phases.
  3. Check reversibility, destructive operations, defaults, nullability, casts, indexes, constraints, foreign keys, triggers, and compatibility windows.
  4. Assess locks, long transactions, backfill rate, disk growth, replication lag, retries, partial failure, and zero-downtime sequencing.
  5. Verify expand/migrate/contract ordering and old/new application compatibility.
  6. Recommend backup, dry run, sampling, checksums or invariants, canary/gray rollout, observability, stop conditions, and rollback.
  7. Report evidence, severity, impact, confidence, validation, and unknowns without executing or editing.

Output Contract

  1. Scope, engine, and rollout phases
  2. Evidence
  3. Findings with severity, impact, confidence, and phase
  4. Data-loss, locking, replication, and compatibility risks
  5. Backup, validation, canary, and rollback recommendations
  6. Deployment sequence and stop conditions
  7. Unknowns

数据库迁移审查

基于仓库证据审查一个具体迁移，不执行迁移，也不连接任何生产系统。

职责边界

  • 通用影响交给 change-impact-analysis，实施计划交给 safe-change-plan，修改交给 safe-fix-implementation。
  • 不得无证据推断数据库引擎行为、表大小、流量、复制拓扑或维护窗口。
  • 保持迁移、应用、配置和数据不变。

工作流程

  1. 识别数据库引擎/版本、迁移框架、up/down、受影响对象、应用版本、部署顺序及可用容量或流量证据。
  2. 分离 schema change、data migration/回填和 application rollout 阶段。
  3. 检查可逆性、破坏性操作、默认值、空值、类型转换、索引、约束、外键、触发器和兼容窗口。
  4. 评估锁、长事务、回填速率、磁盘增长、复制延迟、重试、部分失败和零停机顺序。
  5. 验证 expand/migrate/contract 顺序及新旧应用兼容性。
  6. 建议备份、dry run、抽样、校验和或不变量、灰度、可观察性、停止条件和回滚。
  7. 不执行或修改，报告证据、严重度、影响、置信度、验证和未知项。

输出契约

  1. 范围、引擎与发布阶段
  2. 证据
  3. 发现、严重度、影响、置信度和阶段
  4. 数据丢失、锁、复制和兼容风险
  5. 备份、验证、灰度和回滚建议
  6. 部署顺序与停止条件
  7. 未知项

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.