Laravel Migration Safety Review SKILL.md skillA

Laravel Migration Safety Review 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/Laravel Migration Safety Review@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/laravel-migration-safety/SKILL.md
Versions recorded
4
Latest version
v0.1.0, committed Jul 14, 2026
First version recorded
Jun 29, 2026
Size
3,354 bytes
Repository stars
7
License
MIT

Reviews Laravel migrations for destructive operations, change() dropping modifiers, locking index creation on large tables (PostgreSQL), and asymmetric down().

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: migration の破壊的・ロック誘発操作をチェックリスト型で検査する

## Goal / 目的

- `change()` による修飾子の意図しない消失(公式: 保持したい修飾子をすべて再指定しないと消える)を検出する。
- 破壊的操作(dropColumn 等)と、大規模テーブルでのロック誘発 index 追加を検出する。

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

- データモデル設計の妥当性(`data-model-db-design` のスコープ)。
- アプリ側クエリ効率(`laravel-eloquent-nplus1` のスコープ)。

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

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

- [ ] 差分に `database/migrations/` 配下の追加変更が含まれている
- [ ] diff コンテキストが利用可能である

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

## False-positive guards / 抑制条件

- 新規テーブル作成(`Schema::create`)内の index 追加はロック問題がないため指摘しない。
- `down()` の非対称は、データ変換系 migration で完全な逆操作が不可能なケースが正当(コメントで明示があれば許容)。
- `dropColumn` が「別 PR で deprecate 済みカラムの計画的削除」と明示されている場合は指摘しない。

## Rule / ルール

- `change()` 時は保持したい修飾子(`unsigned` / `default` / `comment` / `nullable` 等)をすべて再指定する。
- `dropColumn` / `Schema::drop` 等の破壊的操作は影響とロールバック不能性を確認する(本番 `--force` 実行に注意)。
- PostgreSQL の大規模テーブルへの index 追加は `->online()`(`CREATE INDEX CONCURRENTLY`)を検討する。併せてトランザクション外実行が必要な副作用も指摘する。
- `down()` は `up()` の逆操作として整合させる。

## Evidence / 根拠の取り方
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add s977043/river-review/Laravel Migration Safety Review@sha256:b842cfb2693cb878

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_o6a5ltjiazc75yqk.svg)](https://markdownregistry.com/a/art_o6a5ltjiazc75yqk)

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 3,354 BA view · diff
v0.1.02026-07-01 3696771 3,341 BA view · diff
v0.1.02026-06-29 45e66bc 3,374 BA view · diff
v0.1.02026-06-29 b988700 3,390 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 (3354 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_o6a5ltjiazc75yqk
GET https://markdownregistry.com/api/v1/resolve?ref=s977043/river-review/Laravel Migration Safety Review
GET https://markdownregistry.com/api/v1/blob/b842cfb2693cb878ce0e650911f876fdc0ac09197c2ffa5b924d128f02c9b3f7

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.