database-migration-versioning-expert

database-migration-versioning-expert is a skill for Claude Code, Codex from roedyrustam/vibes-plug. It costs 43 tokens per session (1,247 once invoked), scanned A, original, MIT.

A guide to changing the structure of a production database while keeping applications and existing data working. It covers schema versioning, zero-downtime changes, data backfills, rollback plans, and migration tools such as Prisma, Drizzle, and Alembic.

In plain words
What is it for?
Use it to plan expand-and-contract changes, migrate large datasets, resolve migration-file conflicts, coordinate database changes with releases, and prepare rollback strategies.
Why use it?
It helps avoid outages, lost data, and deployment failures when tables or columns need to change.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it to plan expand-and-contract changes, migrate large datasets, resolve migration-file conflicts, coordinate database changes with releases, and prepare rollback strategies.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/roedyrustam/vibes-plug/database-migration-versioning-expert
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add roedyrustam/vibes-plug --skill database-migration-versioning-expert
Clone the repo
git clone --depth 1 https://github.com/roedyrustam/vibes-plug

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for database-migration-versioning-expert

README.md
[![agentmods](https://agentmods.dev/badge/skills/roedyrustam/vibes-plug/database-migration-versioning-expert.svg)](https://agentmods.dev/skills/roedyrustam/vibes-plug/database-migration-versioning-expert)
Your own site
<a href="https://agentmods.dev/skills/roedyrustam/vibes-plug/database-migration-versioning-expert"><img src="https://agentmods.dev/badge/skills/roedyrustam/vibes-plug/database-migration-versioning-expert.svg" alt="Measured on agentmods" height="20"></a>
Per session 43 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,247 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits
  • NVIDIA SkillSpector pass 7 Sept 2026
How audits are shown
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00043 $0.01247
Opus 5 $0.00022 $0.00624
Sonnet 5 $0.00009 $0.00249
Haiku 4.5 $0.00004 $0.00125

Measured 8d ago against content hash 4b86f37e3fd9, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-07, from the pricing page.

Security

Grade A, and why

database-migration-versioning-expert scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 8d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/database-migration-versioning-expert/SKILL.md · 91 lines

How it starts

The opening of the file, as written. The whole thing — 91 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Database Migration & Versioning Expert

English | Bahasa Indonesia


English

Description

A specialized skill focused strictly on the lifecycle of database schemas in production environments. While database-orm-expert handles queries and types, this skill covers the DevOps aspect of databases: zero-downtime schema migrations, backward-compatible release cycles, stateful data backfills, rollback mechanisms, and schema versioning strategies.

Trigger Conditions

  • When modifying an existing production database schema.
  • When planning a deployment that involves database changes (blue-green, canary).
  • When resolving merge conflicts in migration files (e.g., Prisma, Drizzle, Alembic).
  • When designing backfill scripts for massive data migrations.

Core Architectural Guidelines

1. Zero-Downtime Migration Pattern (Expand and Contract)

Never make breaking changes in a single deployment. Use the "Expand and Contract" pattern (Parallel Change):

  • Phase 1 (Expand): Add the new schema element (column, table) without removing the old one. Deploy the database change.
  • Phase 2 (Migrate): Update application code to write to both old and new elements, and read from the new element (with fallback). Deploy code.
  • Phase 3 (Backfill): Run a background script to backfill data from the old element to the new element for older records.
  • Phase 4 (Contract): Remove the old application code that writes to the old element. Deploy code.
  • Phase 5 (Cleanup): Drop the old schema element from the database.
2. Backward Compatibility Rules
  • Never DROP or RENAME a column/table in active use. Create a new one, migrate data, then drop the old one later.
  • Avoid changing constraints on existing data without carefully verifying that all data complies.
  • Add DEFAULT values to new NOT NULL columns, or make them nullable first, backfill, then enforce NOT NULL.
3. Migration Mechanics
  • Always use version-controlled, immutable migration scripts (e.g., 20260814_add_user_status.sql).
  • Never modify an already-applied migration file. If a mistake was made, create a new forward-migration to fix it.
  • Idempotency: Write scripts that can be safely run multiple times (e.g., CREATE TABLE IF NOT EXISTS, ADD COLUMN IF NOT EXISTS).

Read the full file on GitHub · 91 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 8d ago First seen · 91 lines · 43 tokens per session scan A 4b86f37e3fd9

Subscribe to this mod's changes

database-migration-versioning-expert is a skill published in the GitHub repository roedyrustam/vibes-plug (49 stars, last pushed today), licensed MIT. It adds 43 tokens to every session and 1,247 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

deprecation-and-migration

Manages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset…

addyosmani/agent-skills · 69 tokens

database-design

Design relational database schemas (and choose when to go NoSQL) that stay maintainable and fast. Use this skill whenever the user mentions tables, DDL, entities and relationships, normalization (1NF/2NF/3NF), primary and foreign keys, UUID vs bigint IDs, indexes (B-tree, composite, covering, partial), EXPLAIN…

svngoku/coding-agents-skills · 163 tokens

backfill-runbook

Safely backfill historical data for a pipeline stage — scope the date range, run a dry-run, execute in chunks to avoid overwhelming the database, and verify row counts after each chunk. Use when historical data is missing, when a pipeline stage is added retroactively, or when asked to "backfill the {stage} table from…

zakelfassi/skills-driven-development · 76 tokens

dataset-onboard

Onboard a new raw dataset into the data platform — sniff the schema, generate a profiling notebook, create the ingestion job, and add an entry to the data dictionary. Use when adding a new data source, when a partner delivers a new CSV/Parquet drop, or when asked to "onboard the {name} dataset".

zakelfassi/skills-driven-development · 71 tokens

pipeline-stage

Scaffold a new transform stage in the data pipeline — create the transformation script, schema contract, idempotency logic, and tests. Use when adding a new dbt model or pandas transform, when a new business metric needs a dedicated stage, or when asked to "add a {name} stage to the pipeline".

zakelfassi/skills-driven-development · 67 tokens

data-engineering

Guides data pipeline design, ETL/ELT workflows, schema evolution, and data quality assurance. Use when building data pipelines, designing data warehouses, migrating schemas, or ensuring data integrity across systems. Use when you need reliable, testable, and observable data flows.

borhen68/SkillEngine · 59 tokens