AgentSkillsCN

migration-helper

分析GORM模型的变更，预估由此产生的Schema（DDL）差异，并提出安全的迁移步骤，同时提供验证指导。

SKILL.md
--- frontmatter
name: migration-helper
description: Analyze GORM model changes, estimate resulting schema (DDL) differences, and propose safe migration steps with verification guidance.
license: MIT
metadata:
  mode: diagnostics
  purpose: migration

Migration Helper

When to Use

  • •A model change (field add/remove/type change) or migration code is proposed and you need a safe rollout plan.

Rules

  • •Start with a non-destructive assessment and clearly call out destructive operations (drops, type narrows, index changes).
  • •Recommend backups, staging verification, and zero-downtime considerations for risky changes.

Project-Specific Paths

  • •Core migration: database/migrate/
  • •Example app migration: example2/internal/database/migrate/
  • •Core models: database/model/ (Auth, TwoFA, TwoFABackup, TempEmail)

Workflow

  1. •Locate migration entrypoints in the paths above.
  2. •Map model edits to likely DDL changes and affected queries.
  3. •Recommend migration steps and verification commands (local + staging).

Output

  • •Affected models: path:line entries.
  • •Schema updates: likely DDL changes and risk level (low/medium/high).
  • •Verification: steps and test commands.

Examples

  • •"Adding a Role field to Auth model - what migration is needed?"
  • •"Changing IDAuth from uint64 to uint32 - what are the risks?"

Related Skills

  • •db-infra-mocks, test-runner, patch-applier