Safe Database Migration Patterns
affaan-m/ECC
Rules and examples for safe, reversible schema changes in production: zero-downtime column and index changes, large data backfills and ORM migration workflows.
Safely run database schema migrations. An agent skill from agulli/atlas-agents.
$ npx skills add agulli/atlas-agents --skill database-migration -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install agulli/atlas-agents database-migration --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/agulli/atlas-agents.git skills-src && mkdir -p .claude/skills && cp -r skills-src/ch09_agent_skills/skills/database-migration .claude/skills/database-migration && rm -rf skills-srcUse ~/.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/
Install the "database-migration" agent skill from https://github.com/agulli/atlas-agents/tree/main/ch09_agent_skills/skills/database-migration into .claude/skills/database-migration/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migration", 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 install https://github.com/agulli/atlas-agents/tree/main/ch09_agent_skills/skills/database-migrationType 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.
$ npx skills add agulli/atlas-agents --skill database-migration -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install agulli/atlas-agents database-migration --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/agulli/atlas-agents.git skills-src && mkdir -p .agents/skills && cp -r skills-src/ch09_agent_skills/skills/database-migration .agents/skills/database-migration && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "database-migration" agent skill from https://github.com/agulli/atlas-agents/tree/main/ch09_agent_skills/skills/database-migration into .agents/skills/database-migration/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migration", 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.
$ npx skills add agulli/atlas-agents --skill database-migration -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install agulli/atlas-agents database-migration --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/agulli/atlas-agents.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/ch09_agent_skills/skills/database-migration .cursor/skills/database-migration && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "database-migration" agent skill from https://github.com/agulli/atlas-agents/tree/main/ch09_agent_skills/skills/database-migration into .cursor/skills/database-migration/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migration", 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 https://github.com/agulli/atlas-agents.git --path ch09_agent_skills/skills/database-migration--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add agulli/atlas-agents --skill database-migration -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install agulli/atlas-agents database-migration --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/agulli/atlas-agents.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/ch09_agent_skills/skills/database-migration .gemini/skills/database-migration && rm -rf skills-srcUse ~/.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/
Install the "database-migration" agent skill from https://github.com/agulli/atlas-agents/tree/main/ch09_agent_skills/skills/database-migration into .gemini/skills/database-migration/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migration", 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.
$ gh skill install agulli/atlas-agents database-migrationInstalls 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).
$ npx skills add agulli/atlas-agents --skill database-migration -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/agulli/atlas-agents.git skills-src && mkdir -p .github/skills && cp -r skills-src/ch09_agent_skills/skills/database-migration .github/skills/database-migration && rm -rf skills-srcUse ~/.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/
Install the "database-migration" agent skill from https://github.com/agulli/atlas-agents/tree/main/ch09_agent_skills/skills/database-migration into .github/skills/database-migration/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migration", 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.
$ npx skills add agulli/atlas-agents --skill database-migration -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install agulli/atlas-agents database-migration --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/agulli/atlas-agents.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/ch09_agent_skills/skills/database-migration .opencode/skills/database-migration && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "database-migration" agent skill from https://github.com/agulli/atlas-agents/tree/main/ch09_agent_skills/skills/database-migration into .opencode/skills/database-migration/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-migration", 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.
database-migrationSafely run database schema migrations. An agent skill from agulli/atlas-agents.
Database Migration is an agent skill from agulli/atlas-agents. Safely run database schema migrations. Use when asked to update database schema, add columns, create tables, run alembic, or apply Django migrations.
Its SKILL.md is about 700 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts. Compatibility notes: Requires python 3.10+ and one of alembic, django, or prisma
It sits in Databases, covering Database migrations, Database schema design and Backend development. It works with Django and Prisma. The licence is MIT.
6 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 2b21998. It shows what the files ask for, not the result of running them.
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.
Shell commands in SKILL.md call:
pythonnpxFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md. Its commands use npx, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Requires python 3.10+ and one of alembic, django, or prisma
From compatibility in the SKILL.md frontmatter.
Database Migration loads about 702 tokens when it runs. Until then it costs about 42 tokens; SKILL.md has 317 words of instructions outside code blocks.
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.
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.
The full file from agulli/atlas-agents at commit 2b21998, republished under its MIT licence (© agulli). 317 words, ~702 tokens.
.claude/skills/database-migration/SKILL.md (or your agent's skills folder).Before executing any migration, you must have clear answers to all of the following. If any is missing or ambiguous, STOP and ask. Do not infer from filenames, branch names, or previous conversation context.
An agent that guesses the environment and gets it wrong has just migrated the wrong database. Ask first.
Identify the migration tool. Check the project for:
alembic.ini → Alembic (SQLAlchemy)manage.py → Django migrationsprisma/schema.prisma → Prisma
If none are found, ask the user which tool to use. Do not guess.Generate the migration.
alembic revision --autogenerate -m "description"python manage.py makemigrationsnpx prisma migrate dev --name descriptionReview the generated migration file. Read the entire file. Check for:
Dry run. If the tool supports it:
alembic upgrade head --sql (generates SQL without executing)python manage.py sqlmigrate <app> <migration_number>Apply the migration only after reviewing the dry run output.
Verify. Query the database schema directly to confirm the change took effect:
-- PostgreSQL
SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'target_table';
-- SQLite
PRAGMA table_info(target_table);| Excuse | Rebuttal |
|---|---|
| "It's just an ADD COLUMN, I'll skip the review" | Schema locks can occur even on simple additions. Always review. |
| "The autogenerated migration looks correct" | Autogenerate guesses. It sometimes generates DROP + CREATE instead of ALTER. Read the file. |
| "I'll just run it — we can roll back" | Not all migrations are reversible. Dropping a column destroys data permanently. |
© agulli, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in ch09_agent_skills/skills/database-migration of agulli/atlas-agents.
Open the folder on GitHubat commit 2b21998
Database Migration 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Database Migration this skillagulli/atlas-agents | 578 | — | ~702 | Automated safety check: Pass | MIT | |
| Safe Database Migration Patternsaffaan-m/ECC | 274k | — | ~3.3k | Automated safety check: Pass | MIT | |
| Database Migrationsaffaan-m/ECC | 274k | 4 repos | ~3k | Automated safety check: Pass | MIT | |
| Database Migrationsaffaan-m/ECC | 274k | 3 repos | ~1.9k | Automated safety check: Pass | MIT | |
| Database Migrationsaffaan-m/ECC | 274k | 1 repos | ~2.4k | Automated safety check: Pass | MIT | |
| Database Migrationsaffaan-m/ECC | 274k | — | ~335 | Automated safety check: Pass | MIT |
affaan-m/ECC
Rules and examples for safe, reversible schema changes in production: zero-downtime column and index changes, large data backfills and ORM migration workflows.
affaan-m/ECC
Safe, reversible database migration patterns: forward-only production changes, expand-contract zero-downtime renames, concurrent indexes, batched backfills, and per-tool workflows for PostgreSQL…
affaan-m/ECC
数据库迁移最佳实践,涵盖模式变更、数据迁移、回滚以及零停机部署,适用于PostgreSQL、MySQL及常用ORM(Prisma、Drizzle、Django、TypeORM、golang-migrate)。
affaan-m/ECC
Şema değişiklikleri, veri migration'ları, rollback'ler ve PostgreSQL, MySQL ve yaygın ORM'ler (Prisma, Drizzle, Django, TypeORM, golang-migrate) arasında sıfır kesinti deployment'ları için…
affaan-m/ECC
PostgreSQL、MySQL、一般的なORM(Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate)全体のスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。
laolaoshiren/claude-code-skills-zh
数据库迁移助手 - Schema 对比、迁移脚本生成
agulli/atlas-agents
Design or review REST and GraphQL API interfaces. An agent skill from agulli/atlas-agents.
agulli/atlas-agents
Design, build, or debug data processing pipelines. An agent skill from agulli/atlas-agents.
agulli/atlas-agents
Execute a structured deployment to staging or production. An agent skill from agulli/atlas-agents.
agulli/atlas-agents
Write or update technical documentation for code, APIs, or systems.
agulli/atlas-agents
Create well-structured git commits with conventional commit messages.
agulli/atlas-agents
Profile and optimize application performance. An agent skill from agulli/atlas-agents.
Categories
Safely run database schema migrations. An agent skill from agulli/atlas-agents. Database Migration is an agent skill from agulli/atlas-agents. Safely run database schema migrations.
Database Migration fits situations like: asked to update database schema; apply Django migrations.
Run `npx skills add agulli/atlas-agents --skill database-migration -a claude-code`. Or copy the skill folder (ch09_agent_skills/skills/database-migration in agulli/atlas-agents) into .claude/skills/database-migration in your project. Claude Code loads it when a task matches its description.
Run `npx skills add agulli/atlas-agents --skill database-migration -a codex`. Or copy the skill folder (ch09_agent_skills/skills/database-migration in agulli/atlas-agents) into .agents/skills/database-migration in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add agulli/atlas-agents --skill database-migration -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-migration, .gemini/skills/database-migration, .github/skills/database-migration and .opencode/skills/database-migration in your project.
Going by SKILL.md and its folder, Database Migration needs the command-line tools its instructions call (python and npx). Our summary lists: Python 3; Node.js. Compatibility (from SKILL.md): Requires python 3.10+ and one of alembic, django, or prisma.
SKILL.md contains no URLs. Its commands use npx, which can reach the network depending on how they are called. This is read from the text; nothing was executed.
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.
Database Migration is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
About 702 tokens (SKILL.md is roughly 2.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Database Migration: Safe Database Migration Patterns (affaan-m/ECC, 274k stars), Database Migrations (affaan-m/ECC, 274k stars), Database Migrations (affaan-m/ECC, 274k stars) and Database Migrations (affaan-m/ECC, 274k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
agulli (a GitHub user) maintains it in agulli/atlas-agents, which has 578 GitHub stars. The repository holds 12 skills in this directory. The repository was last updated on July 17, 2026.
Source: agulli/atlas-agents on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.