免费在 GitHub 公开

data-contract-migrations

Design and verify data contracts, schema changes, migrations, rollbacks, backfills, compatibility windows, tenant isolation, and API-to-database field mapping. Use when changing database schema, event payloads, persisted documents, analytics tables, multi-tenant data boundaries, or any user-visible data contract where silent fallback or undeclared fields would be dangerous.

中文简介正在准备中。当前显示原文说明。

majiayu000/spellbook

查看安装方法

包含的文件（2）

SKILL.md2.4 KB
agents/openai.yaml256 B

SKILL.md（原文）

安装前可以查看交给 AI 代理的指令内容。

Data Contract Migrations

Purpose

Use this skill when data shape changes can break reads, writes, reports, tenants, or integrations. The goal is an explicit compatibility and migration plan, not just a SQL diff.

Preflight

Gather these facts before proposing changes:

Current schema, models, serializers, API contracts, and persisted samples.
Writers and readers of each field.
Migration tool and rollback support.
Data volume, tenant boundaries, and backfill cost.
Required zero-downtime or maintenance-window constraints.
Existing tests or fixtures that prove compatibility.

If the current data does not contain a field, treat it as absent. Do not invent fallback fields.

Migration Design

Use expand-migrate-contract for production systems:

Expand: add nullable columns, new tables, new enum values, or versioned payloads without breaking old readers.
Dual-write or adapter: write both old and new forms when needed.
Backfill: migrate historical data with batching, checkpoints, and retry behavior.
Read switch: move readers to the new contract after verification.
Contract: remove old fields only after the compatibility window and rollback risk pass.

For small systems, a direct migration is acceptable only when downtime, rollback, and data loss risks are explicitly low.

Required Checks

Every plan must include:

Forward migration command.
Rollback or roll-forward recovery command.
Backfill idempotency and resume behavior.
Data validation query before and after.
Tenant isolation check when tenants exist.
API/serializer compatibility test.
Observability for migration progress and failure.

Output Shape

contract_change:
affected_readers_writers:
migration_strategy:
backfill_plan:
rollback_or_recovery:
tenant_and_security_checks:
verification_queries:
test_commands:
release_gate:

Raise errors for missing critical data rather than warning and falling back to incomplete output.

评价

还没有评价。欢迎分享你的使用感受。

无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

同一仓库的技能

agentsmd-optimize

免费

Audit and organize AI coding-agent instructions, including AGENTS.md, CLAUDE.md, skills, and agent definitions. Use when the user asks to diagnose conflicting instructions, excessive approval pauses, broad skill triggers, duplicate guidance, or broken instruction references, or to clean up that instruction set. Ordinary code review, Markdown editing, or application debugging alone does not trigger this workflow. Inspection stays read-only; apply changes when authorized.

中文简介正在准备中。当前显示原文说明。