Agent skill

Database Migrations

PostgreSQL、MySQL、一般的なORM（Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate）全体のスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。

MITAuto-check passedDatabases

Install Database Migrations

skills CLI

$ npx skills add affaan-m/ECC --skill database-migrations -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC database-migrations --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .claude/skills && cp -r skills-src/docs/ja-JP/skills/database-migrations .claude/skills/database-migrations && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "database-migrations" agent skill from https://github.com/affaan-m/ECC/tree/main/docs/ja-JP/skills/database-migrations into .claude/skills/database-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migrations", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/affaan-m/ECC/tree/main/docs/ja-JP/skills/database-migrations

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add affaan-m/ECC --skill database-migrations -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC database-migrations --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .agents/skills && cp -r skills-src/docs/ja-JP/skills/database-migrations .agents/skills/database-migrations && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "database-migrations" agent skill from https://github.com/affaan-m/ECC/tree/main/docs/ja-JP/skills/database-migrations into .agents/skills/database-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migrations", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add affaan-m/ECC --skill database-migrations -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC database-migrations --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/docs/ja-JP/skills/database-migrations .cursor/skills/database-migrations && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "database-migrations" agent skill from https://github.com/affaan-m/ECC/tree/main/docs/ja-JP/skills/database-migrations into .cursor/skills/database-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migrations", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/affaan-m/ECC.git --path docs/ja-JP/skills/database-migrations

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add affaan-m/ECC --skill database-migrations -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC database-migrations --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/docs/ja-JP/skills/database-migrations .gemini/skills/database-migrations && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "database-migrations" agent skill from https://github.com/affaan-m/ECC/tree/main/docs/ja-JP/skills/database-migrations into .gemini/skills/database-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migrations", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install affaan-m/ECC database-migrations

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add affaan-m/ECC --skill database-migrations -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .github/skills && cp -r skills-src/docs/ja-JP/skills/database-migrations .github/skills/database-migrations && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "database-migrations" agent skill from https://github.com/affaan-m/ECC/tree/main/docs/ja-JP/skills/database-migrations into .github/skills/database-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migrations", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add affaan-m/ECC --skill database-migrations -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC database-migrations --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/docs/ja-JP/skills/database-migrations .opencode/skills/database-migrations && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "database-migrations" agent skill from https://github.com/affaan-m/ECC/tree/main/docs/ja-JP/skills/database-migrations into .opencode/skills/database-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migrations", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: database-migrations
GitHub stars: 276k
Token cost: ~335 tokens
SKILL.md length: 39 words
Files: 1
Skills in repo: 673
Repo updated: Oct 5, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

Works in 5 steps: すべての変更はマイグレーション — 本番環境データベースを手動で変更しない → マイグレーションは本番環境で前方のみ —… → スキーマとデータマイグレーションは分離 —… → …
Tasks that involve ORMs and data access
SKILL.md covers アクティベーション時期, コア原則, マイグレーション安全チェックリスト and PostgreSQL パターン
Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Database Migrations is an agent skill from affaan-m/ECC. PostgreSQL、MySQL、一般的なORM（Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate）全体のスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。

Its SKILL.md is about 340 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering ORMs and data access, Database migrations and Backend development. It works with PostgreSQL, MySQL, Django and Go. The repository describes itself as: The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond. The licence is MIT.

When your agent uses it

Tasks that involve ORMs and data access
Tasks that involve Database migrations
Tasks that involve Backend development

Example prompts

“/database-migrations”

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

すべての変更はマイグレーション — 本番環境データベースを手動で変更しない
マイグレーションは本番環境で前方のみ — ロールバックは新しい前向きマイグレーション使用
スキーマとデータマイグレーションは分離 — 1つのマイグレーションでDDLとDMLを混ぜない
本番環境サイズのデータに対してマイグレーションをテスト — 100行で機能するマイグレーション10M上でロックされる場合がある
マイグレーションは展開後は不変 — 本番環境で実行されたマイグレーションを編集しない

What it can do on your machine

Read from SKILL.md and the folder at commit ef648e0. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are sql).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Database Migrations loads about 335 tokens when it runs. Until then it costs about 42 tokens; SKILL.md has 39 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~42
When it runs · the whole SKILL.md, loaded when a task matches: ~335

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from affaan-m/ECC at commit ef648e0, republished under its MIT licence (© affaan-m). 39 words, ~335 tokens.

Download SKILL.mdSave it as .claude/skills/database-migrations/SKILL.md (or your agent's skills folder).

name: database-migrations
description: PostgreSQL、MySQL、一般的なORM（Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate）全体のスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。
origin: ECC

データベースマイグレーションパターン

本番環境システム用の安全で可逆的なデータベーススキーマ変更。

アクティベーション時期

データベーステーブルの作成または変更
列またはインデックスの追加/削除
データマイグレーション（バックフィル、変換）の実行
ゼロダウンタイムスキーマ変更を計画
新しいプロジェクト用のマイグレーションツール設定

コア原則

すべての変更はマイグレーション — 本番環境データベースを手動で変更しない
マイグレーションは本番環境で前方のみ — ロールバックは新しい前向きマイグレーション使用
スキーマとデータマイグレーションは分離 — 1つのマイグレーションでDDLとDMLを混ぜない
本番環境サイズのデータに対してマイグレーションをテスト — 100行で機能するマイグレーション10M上でロックされる場合がある
マイグレーションは展開後は不変 — 本番環境で実行されたマイグレーションを編集しない

マイグレーション安全チェックリスト

マイグレーションを適用する前に：

マイグレーションはUPとDOWNの両方を持つ（または明示的に不可逆としてマーク）
大型テーブルの完全テーブルロックなし（並行操作使用）
新しい列はデフォルトまたはnullable（デフォルトなしでNOT NULLを追加しない）
インデックスは並行して作成（既存テーブルのCREATE TABLEでインライン化しない）
データバックフィルはスキーマ変更から分離したマイグレーション
本番環境データのコピーに対してテスト
ロールバック計画を文書化

PostgreSQL パターン

列を安全に追加

sql

-- GOOD: Nullable列、ロックなし
ALTER TABLE users ADD COLUMN avatar_url TEXT;

-- GOOD: デフォルト付きの列（Postgres 11+は即座、書き直しなし）
ALTER TABLE users ADD COLUMN is_active BOOLEAN NOT NULL DEFAULT true;

-- BAD: 既存テーブルのデフォルトなしで NOT NULL（完全書き直し必須）
ALTER TABLE users ADD COLUMN is_active BOOLEAN NOT NULL;

詳細についてはドキュメントを参照してください。

Files

Just SKILL.md in docs/ja-JP/skills/database-migrations of affaan-m/ECC.

Open the folder on GitHubat commit ef648e0

Compare with similar skills

Database Migrations next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Database Migrations compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Database Migrations this skillaffaan-m/ECC	276k	—	~335	Automated safety check: Pass	MIT	4 days ago
Database Migrationsxu-xiang/everything-claude-code-zh	2k	—	~1.7k	Automated safety check: Pass	MIT	7 mo ago
Database Expertcin12211/orca-q	224	—	~2.8k	Automated safety check: Pass	MIT	18 days ago
DB Review312362115/claude	107	—	~1.8k	Automated safety check: Pass	MIT	4 mo ago
SQL Database Assistantalirezarezvani/claude-skills	28k	—	~4k	Automated safety check: Pass	MIT	1 mo ago
Dsqlawslabs/agent-plugins	915	—	~6.9k	Automated safety check: Pass	Apache-2.0	today

Similar skills

Database Migrations
xu-xiang/everything-claude-code-zh
跨 PostgreSQL、MySQL 及常用 ORM（Prisma、Drizzle、Django、TypeORM、golang-migrate）的模式变更（schema changes）、数据迁移、回滚及零停机部署（zero-downtime deployments）的数据库迁移最佳实践。
2k GitHub stars~1.7k tokensUpdated 7 mo ago
DatabasesAuto-check passed
Database Expert
cin12211/orca-q
Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.
224 GitHub stars~2.8k tokensUpdated 18 days ago
DatabasesAuto-check passed
DB Review
312362115/claude
数据库代码审查 + Migration 安全检查. An agent skill from 312362115/claude.
107 GitHub stars~1.8k tokensUpdated 4 mo ago
DatabasesAuto-check passed
SQL Database Assistant
alirezarezvani/claude-skills
A skill your agent uses when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or…
28k GitHub stars~4k tokensUpdated 1 mo ago
DatabasesAuto-check passed
Dsql
awslabs/agent-plugins
Official
Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed…
915 GitHub stars~6.9k tokensUpdated today
DatabasesAuto-check passed
DB Migrator
laolaoshiren/claude-code-skills-zh
数据库迁移助手 - Schema 对比、迁移脚本生成
879 GitHub stars~677 tokensUpdated 4 days ago
DatabasesAuto-check passed

Questions about Database Migrations

What does Database Migrations do?

PostgreSQL、MySQL、一般的なORM（Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate）全体のスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。. Database Migrations is an agent skill from affaan-m/ECC.

When should I use Database Migrations?

Database Migrations fits situations like: tasks that involve ORMs and data access; tasks that involve Database migrations; tasks that involve Backend development.

How do I install Database Migrations in Claude Code?

Run `npx skills add affaan-m/ECC --skill database-migrations -a claude-code`. Or copy the skill folder (docs/ja-JP/skills/database-migrations in affaan-m/ECC) into .claude/skills/database-migrations in your project. Claude Code loads it when a task matches its description.

How do I install Database Migrations in Codex?

Run `npx skills add affaan-m/ECC --skill database-migrations -a codex`. Or copy the skill folder (docs/ja-JP/skills/database-migrations in affaan-m/ECC) into .agents/skills/database-migrations in your project. Codex loads it when a task matches its description.

Can I use Database Migrations in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add affaan-m/ECC --skill database-migrations -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-migrations, .gemini/skills/database-migrations, .github/skills/database-migrations and .opencode/skills/database-migrations in your project.

What does Database Migrations need to run?

SKILL.md names no scripts, command-line tools or credentials: Database Migrations is instructions for the agent only.

Does Database Migrations access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Database Migrations safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Database Migrations use?

Database Migrations is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Database Migrations use?

About 335 tokens (SKILL.md is roughly 1.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Database Migrations?

Skills that share tags, products or a category with Database Migrations: Database Migrations (xu-xiang/everything-claude-code-zh, 2k stars), Database Expert (cin12211/orca-q, 224 stars), DB Review (312362115/claude, 107 stars) and SQL Database Assistant (alirezarezvani/claude-skills, 28k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Database Migrations?

affaan-m (a GitHub user) maintains it in affaan-m/ECC, which has 275,546 GitHub stars. The repository holds 673 skills in this directory. The repository was last updated on October 5, 2026.

Source: affaan-m/ECC on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Database Migrations

Install Database Migrations

Facts

At a glance

What it does

When your agent uses it

Example prompts

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

データベースマイグレーションパターン

アクティベーション時期

コア原則

マイグレーション安全チェックリスト

PostgreSQL パターン

列を安全に追加

Files

Compare with similar skills

Similar skills