SkillsAdd

smithery/nakamura-shuta

migration-best-practices

データベースマイグレーションのベストプラクティス。 スキーマ変更時に自動適用される。

Installation

$ npx skills add smithery/nakamura-shuta --skill migration-best-practices
View on skills.sh ↗ Website ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

cloudflare-one-migrations Similar name
cloudflare/skills

Assess and plan migrations from existing VPN, SWG, or SASE platforms to Cloudflare One, includi…

48K installs
sanity-migration Similar name
sanity-io/agent-toolkit

Plans, implements, and reviews migrations from other CMSes and content systems into Sanity.

16.1K installs
claude-opus-4-5-migration Similar name
anthropics/claude-code

Migrate prompts and code from Claude Sonnet 4.0, Sonnet 4.5, or Opus 4.1 to Opus 4.5. Use when …

10.7K installs
winui3-migration-guide Similar name
github/awesome-copilot

UWP-to-WinUI 3 migration reference. Maps legacy UWP APIs to correct Windows App SDK equivalents…

5.7K installs
react-native-brownfield-migration Similar name
callstackincubator/agent-skills

Implements an accepted incremental brownfield migration from native iOS or Android to React Nat…

4.1K installs
issue-fields-migration Similar name
github/awesome-copilot

Bulk-migrate metadata to GitHub issue fields from two sources: repo labels (e.g. priority label…

1.9K installs
More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 923 B
  • docs SUMMARY.md 157 B

History

  1. First recorded snapshot · 0 installs

SKILL.md

Database Migration Best Practices

命名規則

  • ファイル名: YYYYMMDDHHMMSS_description.sql
  • 例: 20250121120000adduser_email.sql

マイグレーションルール

UP Migration（適用）

  • 必ずトランザクション内で実行
  • カラム追加はNOT NULL制約に注意（デフォルト値を設定）
  • インデックス作成は大規模テーブルでは段階的に

DOWN Migration（ロールバック）

  • すべてのUPに対応するDOWNを必ず用意
  • データ損失の可能性がある変更は警告コメント必須

禁止事項

  • 既存マイグレーションファイルの変更禁止
  • 本番環境で直接DDL実行禁止
  • カラム削除前にデータ確認必須