Skip to content
Development
Skill

/database-migrations

Plan additive, zero-downtime schema migrations with rollout, backfill, and rollback awareness. Use when renaming columns, backfilling data, or shipping risky database changes.

BOOST
@hoangnguyen0403hoangnguyen0403@hoangnguyen0403
From plugin
agent-skills-standard
583200 skills21 agents33 commands1 MCP

Claude Code

$ npx -y skills add hoangnguyen0403/agent-skills-standard --skill database-migrations --agent claude-code

SKILL.md

database-migrations.SKILL.md
name: database-migrations
description: Plan additive, zero-downtime schema migrations with rollout, backfill, and rollback awareness. Use when renaming columns, backfilling data, or shipping risky database changes.
metadata:
  triggers:
    files:
    - '**/migrations/*.sql'
    - 'prisma/schema.prisma'
    - '**/*.entity.ts'
    keywords:
    - migration
    - backfill
    - rollout
    - rename column
    - zero downtime

Database Migrations

**Priority: P0 (CRITICAL)**

Use expand -> backfill -> contract for risky changes.

Rules

  • Ship additive schema first.
  • Backfill with resumable logic and visibility.
  • Flip reads/writes only after new shape is populated.
  • Drop old columns or indexes in a later safe step.

Verify

  • [ ] Migration can run without taking the app offline.
  • [ ] Backfill ownership, batching, and monitoring are defined.
  • [ ] Rollback or pause strategy exists.
  • [ ] Old and new code paths can coexist during rollout.

Anti-Patterns

  • **No destructive one-shot rename**: expand and migrate first.
  • **No hidden backfill**: long data moves need explicit plan and observability.
  • **No app deploy coupling by accident**: schema and code rollout order must be clear.

References

  • [Framework Map](../references/framework-map.md)
  • [Migration Safety Checklist](references/migration-safety-checklist.md)
Read it on GitHub ↗
Stats
TypeScriptAngularBashGoJavaGitHubAnthropicMCPJiraiOSAndroidFlutter
583
Stars
163
Forks
Active
Maintenance
TypeScript
Language
MIT
License
Last commit
Created

Repo: hoangnguyen0403/agent-skills-standard

In this plugin
200 skills33 commands21 agents1 MCP
See everything inside
@hoangnguyen0403
Ships withagent-skills-standard

The portable standards layer for AI coding agents. Sync once, then work in your own runtime.

583200 skills21 agents1 MCP
Get the whole plugin

Stars on GitHub

Momentum

stars in total
583
Star history of hoangnguyen0403/agent-skills-standard on GitHub, a chart by star-history.com
See what's trending this week

Other skills on agent-skills-standard.

See all 200 skills in agent-skills-standard

More skills from other plugins.

brainstorming
Auto-invoked

brainstorming

You MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or…

superpowers12d311k
@obra@obraInstall Skill
ask-matt

ask-matt

Ask which skill or flow fits your situation. A router over the skills in this repo.

skills10d309k
@mattpocock@mattpocockInstall Skill
accessibility
Auto-invoked

accessibility

Design, implement, and audit accessible UI to WCAG 2.2 Level AA across Web, iOS, and Android — semantic ARIA roles and labels,…

ecc12d293k
@affaan-m@affaan-mInstall Skill
compiler-commit

compiler-commit

Use when you want to verify compiler changes and commit with the correct convention. Runs tests, lint, and format, then commits…

react1d252k
@facebook@facebookInstall Skill

Questions about database-migrations.

Which coding agents can use database-migrations?
database-migrations installs in Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, OpenCode and Windsurf with the skills CLI, using each agent's flag shown on this page. Flowy's auto-invocation, which fires a skill when your prompt matches, runs in Claude Code only.