AgentSkillsCN

migration

对 Prisma Schema 的变更进行安全校验，并生成迁移报告。适用于修改 schema.prisma 文件、创建数据库迁移，或当用户询问迁移相关事宜时使用。

SKILL.md
--- frontmatter
name: migration
description: "Validate Prisma schema changes for safety and generate migration reports. Use when modifying schema.prisma, creating database migrations, or when the user asks about migrations."
event: schema-change
auto_trigger: true
version: "2.0.0"
last_updated: "2026-01-26"

# Inputs/Outputs
inputs:
  - schema_diff
  - existing_data
  - migration_history
output: migration_report
output_format: "Risk assessment + migration commands"

# Auto-Trigger Rules
auto_invoke:
  events:
    - "schema-change"
    - "prisma-schema-save"
  file_patterns:
    - "prisma/schema.prisma"
  conditions:
    - "schema.prisma modified"

# Validation
validation_rules:
  - "destructive changes require approval"
  - "required columns need defaults"
  - "data migration plan for type changes"

# Chaining
chain_after: []
chain_before: [schema-doc-sync]

# Agent Association
called_by: ["@DataArchitect", "@Backend"]
mcp_tools:
  - prisma-migrate-dev
  - activate_prisma_migration_tools

Migration Safety Skill

Purpose: Validate Prisma schema changes for safety and generate migration reports.

Trigger

When: prisma/schema.prisma is modified Context Needed: Schema diff, current database state MCP Tools: prisma-migrate-dev, activate_prisma_migration_tools

Risk Levels

ChangeRiskAction
Drop table🔴 CriticalBackup + approval
Drop column🔴 CriticalBackup + approval
Remove enum value🔴 CriticalCheck usage
Change column type🟠 HighValidate data
Make nullable→required🟠 HighCheck nulls
Add required column🟡 MediumDefault needed
Add optional column🟢 LowSafe
Add index🟢 LowSafe

Migration Checklist

  • • Descriptive migration name
  • • Backup before destructive changes
  • • Test on staging first
  • • Update related documentation

Commands

bash
# Generate migration
bunx prisma migrate dev --name [description]

# Check status
bunx prisma migrate status

# Apply to production
bunx prisma migrate deploy

Reference