AgentSkillsCN

migration-workflow

使用幂等 SQL、RLS 检查与类型重新生成技术，创建、验证并应用 Supabase 迁移脚本。当用户提及迁移、数据库差异、模式变更，或类型生成时，可使用此技能。

SKILL.md
--- frontmatter
name: migration-workflow
description: Create, validate, and apply Supabase migrations with idempotent SQL, RLS checks, and types regeneration. Use when the user mentions migrations, db diff, schema changes, or type generation.

Migration Workflow

Quick Start

  1. •Identify schema change intent and target tables.
  2. •Create a new migration using the documented workflow.
  3. •Validate idempotency and RLS policy coverage.
  4. •Apply migration to hosted Supabase.
  5. •Regenerate types and verify.

Steps

  • •Follow docs/DATABASE_PIPELINE.md and docs/supabase_branching.md for the approved flow.
  • •Prefer repo scripts when available:
    • •scripts/apply-single-migration.mjs
    • •scripts/apply-remote-migrations.mjs
  • •Ensure migration SQL uses IF NOT EXISTS and is safe to re‑run.
  • •After applying: regenerate types in src/lib/generated/database.types.ts.

Checks

  • •RLS enabled on new tables.
  • •Policies tested or verified.
  • •No Docker‑dependent Supabase commands.