Migration Safety Review (framework-agnostic) SKILL.md skillA

Migration Safety Review (framework-agnostic) from s977043/river-review is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add s977043/river-review/Migration Safety Review (framework-agnostic)@v0.1.0

Pins v0.1.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
s977043/river-review
Path
skills/upstream/migration-safety/SKILL.md
Versions recorded
4
Latest version
v0.1.0, committed Jul 14, 2026
First version recorded
Jun 29, 2026
Size
5,471 bytes
Repository stars
7
License
MIT

スキーマ/データ移行の安全性を framework 非依存で審査する。破壊的スキーマ変更・ロック誘発・backfill・ロールバック可逆性・expand-contract の段階適用を、prisma / typeorm / Rails / Django / Alembic / 生 SQL などに横断適用する。.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

## Pattern declaration

Primary pattern: Reviewer
Secondary patterns: Inversion
Why: 移行の破壊的・ロック誘発・不可逆操作をチェックリスト型で検査するが、移行を含まない差分では実行を止めるゲートが必要。

## Goal / 目的

- ORM やフレームワークに依存せず、スキーマ/データ移行に共通する**運用事故**(データ損失・本番ロック・ロールバック不能・反復不能)を検出する。
- 特定フレームワーク固有の深い規約(例: Laravel `change()` の修飾子消失)は専用 skill に委ね、本 skill は**横断的な安全性**に集中する。

## Non-goals / 扱わないこと

- データモデル設計の妥当性(正規化・関連設計)は `data-model-db-design` のスコープ。
- フレームワーク固有の細則(Laravel 固有は `laravel-migration-safety`)。
- アプリ側のクエリ効率(N+1 等)。

## Pre-execution Gate / 実行前ゲート

このスキルは以下の条件がすべて満たされない限り `NO_REVIEW` を返す。

- [ ] 差分にスキーマ/データ移行(migrations ディレクトリ・`schema.prisma`・`*.sql`・`ALTER`/`CREATE`/`DROP` を含む変更)が含まれている
- [ ] diff コンテキストが利用可能である

ゲート不成立時の出力: `NO_REVIEW: migration-safety — 移行の変更なし`

## False-positive guards / 抑制条件

- 新規テーブル作成内の index/制約追加は既存行へのロックが無いため指摘しない。
- 不可逆な down/rollback は、データ変換系移行で完全な逆操作が原理的に不可能なケースが正当(コメントで明示があれば許容)。
- 破壊的操作が「別 PR で deprecate 済み/expand-contract の contract フェーズ」と明示されている場合は指摘しない。
- 小規模テーブルが diff/文脈から確実な場合はロック懸念を断定しない(`questions` で確認)。

## Rule / ルール

横断的に以下を確認する(該当するもののみ):

1. **破壊的スキーマ変更**: カラム/テーブル/制約の DROP、型の縮小変換(例: `text`→`varchar(n)`)、リネームは、データ損失と後方互換を確認する。
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add s977043/river-review/Migration Safety Review (framework-agnostic)@sha256:37b22848753e86c1

The line at the top of this page pins the label v0.1.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_serv3wioognd2zep.svg)](https://markdownregistry.com/a/art_serv3wioognd2zep)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 4 versions of this file, between Jun 29, 2026 and Jul 14, 2026, about one every 5 days.

versioncommittedcommitsizeaudit
v0.1.0 latest2026-07-14 3a84021 5,471 BA view · diff
v0.1.02026-07-01 3696771 5,458 BA view · diff
v0.1.02026-06-29 45e66bc 5,490 BA view · diff
v0.1.02026-06-29 b988700 5,506 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (5471 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

s977043/river-review · 7 stars · license MIT · pushed 2026-11-08 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_serv3wioognd2zep
GET https://markdownregistry.com/api/v1/resolve?ref=s977043/river-review/Migration Safety Review (framework-agnostic)
GET https://markdownregistry.com/api/v1/blob/37b22848753e86c12a892c97d9355046e6387f75baeac017cd730be766910881

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from s977043/river-review

ask-codex SKILL.md skill
s977043/river-review · .claude/skills/ask-codex/SKILL.md · Get a second opinion or independent review from Codex (OpenAI) via the local Codex CLI. Use when the user wants Codex…
git:20260724.d54eafd · audit A · 7 stars
river-review-discipline SKILL.md skill
s977043/river-review · .claude/skills/river-review-discipline/SKILL.md · AI 駆動開発のレビュー品質を安定化させるレビュー規律。レビュー対象を分類し、要件・設計・差分・検証・報告を分けて見て、根拠に基づき approved / needs_revision / blocked / rejected…
git:20260707.9c35a5d · audit A · 7 stars
skill-creator SKILL.md skill
s977043/river-review · .claude/skills/skill-creator/SKILL.md · Design a new Claude Code skill from a concrete use case and produce a repo-ready skill package. Use when the user asks…
git:20261004.95d1f7a · audit A · 7 stars
skill-ops-planner SKILL.md skill
s977043/river-review · .claude/skills/skill-ops-planner/SKILL.md · Create an operating policy and roadmap for a live portfolio of Claude Code skills. Use when the user asks to organize…
git:20260321.857d5ca · audit A · 7 stars
skill-optimizer SKILL.md skill
s977043/river-review · .claude/skills/skill-optimizer/SKILL.md · Evaluate and improve an existing Claude Code skill using explicit success criteria and small controlled changes. Use…
git:20261004.95d1f7a · audit A · 7 stars
AGENTS.md@.codex AGENTS.md file
s977043/river-review · .codex/AGENTS.md
git:20260923.5650e78 · audit A · 7 stars
AGENTS.md AGENTS.md file
s977043/river-review · AGENTS.md
git:20261008.d74129b · audit B · 7 stars
CLAUDE.md CLAUDE.md file
s977043/river-review · CLAUDE.md
git:20261016.787c99c · audit A · 7 stars
Sample Architecture Consistency Review SKILL.md skill
s977043/river-review · examples/skills/architecture-sample/SKILL.md · Checks design/ADR docs for consistency and missing decisions.
v0.1.0 · audit A · 7 stars
Sample Code Quality Pass SKILL.md skill
s977043/river-review · examples/skills/code-quality-sample/SKILL.md · Checks common code quality and maintainability risks.
v0.1.0 · audit A · 7 stars
Sample Test Coverage Review SKILL.md skill
s977043/river-review · examples/skills/test-review-sample/SKILL.md · Evaluates downstream tests for coverage and edge cases.
v0.1.0 · audit A · 7 stars
adversarial-review SKILL.md skill
s977043/river-review · plugin-dist/river-review/skills/agent-skills/adversarial-review/SKILL.md · 敵対的分析手法を統合したレビューの entry skill。認知バイアス対策の3手法 (Pre-mortem / War Game / Logic Torturing)と、宣言・主張と実態の乖離を突く claim-vs-actual…
v0.1.0 · audit A · 7 stars

Every file in s977043/river-review

Browse by kind, by grade A, or by owner.