Database Migration
Use when the user asks about schema migrations, Flyway, Liquibase, Alembic, Prisma Migrate, zero-downtime expand/contract changes, AWS DMS, heterogeneous database moves, or schema drift. Produces safe migration scripts, rollout order and validation. Not for whole-workload cloud migration (use cloud-migration).
Install
npx skills add j4flmao/agent-skills --skill database-migrationgit clone --depth 1 https://github.com/j4flmao/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/devops/database-migration ~/.claude/skills/database-migrationPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Database Migration
## Purpose
Plan and execute database migrations including schema changes, cross-engine migration, zero-downtime deployments, and rollback strategies.
## Agent Protocol
### Trigger
"database migration", "schema migration", "Flyway", "Liquibase", "Alembic", "AWS DMS", "gh-ost", "zero-downtime migration".
### Input Context
Source/target engines and versions, data size, write rate, downtime tolerance, migration tool already in use.
### Output Artifact
Migration scripts and step-by-step plan with rollback. No file unless requested.
### Response Format
```
Type: {schema change|engine migration} {online|offline}
Tool: {Flyway|Liquibase|Alembic|gh-ost|pt-osc|DMS|...}
Steps: {expand -> migrate -> contract}
Rollback: {plan}
Script: {SQL/config}
```
## Architecture Decision Trees
### Online vs Offline Migration
| Factor | Offline | Online (CDC) |
|---|---|---|
| Downtime | Hours (full lock) | Minutes or zero |
| Complexity | Low | High |
| Data volume | Any | Any |
| Consistency | Guaranteed (locked) | Eventual (CDC catch-up) |
| Rollback | Snapshot restore | Reverse CDC |
| Tooling | pg_dump/mysqldump | DMS, Debezium, GoldenGate |
| Best for | <50GB, maintenance window | Large DBs, 24/7 apps |
### Schema Migration Tool Comparison
| Tool | Language | Versioning | Rollback | CI/CD | Best For |
|---|---|---|---|---|---|
| Flyway | Java/SQL | Sequential files | Undo (limited) | Excellent | Java shops, simple |Details
- Skill name
database-migration- Repository
- j4flmao/agent-skills
- Path
skills/devops/database-migration/SKILL.md- License
- MIT
- Repo updated
- 17 November 2026
FAQ
What does the Database Migration skill do?
Use when the user asks about schema migrations, Flyway, Liquibase, Alembic, Prisma Migrate, zero-downtime expand/contract changes, AWS DMS, heterogeneous database moves, or schema drift. Produces safe migration scripts, rollout order and validation. Not for whole-workload cloud migration (use cloud-migration).
How do I install the Database Migration skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add j4flmao/agent-skills --skill database-migration. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Database Migration popular?
It lives in j4flmao/agent-skills, which has 45 GitHub stars and 6 forks.
Related skills
Agent Observability
45j4flmao/agent-skills
Use when the user asks about agent observability, tracing agent reasoning, debugging an agent loop, OpenTelemetry GenAI spans for LLM calls, LLM cost tracking per agent, agent audit logs or hallucination/eval monitoring in production. Produces instrumentation config, trace schema, dashboards, alerts and cost attribution. Not for generic service tracing without LLMs (use devops-opentelemetry).
AI Agent Architectures
45j4flmao/agent-skills
Use when the user asks to build an AI agent, design an agent that calls tools and keeps memory, write an agent system prompt or pick an agent framework (Claude Agent SDK, OpenAI Agents SDK, LangGraph). Produces an architecture brief covering loop, tools, memory, guardrails and evals, routing depth to child skills. Not for workflow patterns (use ai-agentic-workflows).
AI Agent Core Loop
45j4flmao/agent-skills
Use when the user asks about the agent loop, ReAct vs plan-and-solve, re-planning, Reflexion, an agent stuck in a loop, max iterations or termination conditions. Produces a loop spec or patch with state, success predicate, caps and no-progress detection. Not for overall agent design (use ai-agent-architectures) or tool schemas (use tool-calling-principles).
Firebase
45j4flmao/agent-skills
Use when the user asks about Firebase, Firestore data modeling, Firestore security rules, Firebase Auth, Cloud Functions for Firebase, Firebase Admin SDK, App Check or emulators. Produces Firebase backend code and rules. Not for Supabase/Postgres (use supabase) or push messaging on devices (use mobile-push-notifications).
Database Internals Mechanics
45j4flmao/agent-skills
Use when the user asks to explain MVCC and the write-ahead log (WAL), B-tree vs LSM tree, compaction, write amplification, storage engines, isolation levels, write skew, serializable snapshot isolation or vacuum bloat. Produces an engine explanation turned into concrete engine, key and isolation choices. Not for PostgreSQL ops tuning (use data-relational-database).
Nodejs Drizzle
45j4flmao/agent-skills
Use when the user asks about Drizzle ORM, drizzle-kit migrations, Drizzle schema, relational queries (db.query), prepared statements or Drizzle with Neon/Turso. Produces Drizzle schemas, queries and migrations. Not for Prisma (use nodejs-prisma).
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.