db-migrations

Create, review, test, and rollback Alembic database migrations for OPRE OPS. Use this skill whenever the user mentions database migrations, alembic, schema changes, adding/modifying columns or tables, model changes that need migration, or "migrate the database". Also use when a model change has been made and the user needs to generate the corresponding migration.

0.98x

Quality

88%

Does it follow best practices?

Impact

96%

0.98x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Evaluation results

95%

Audit and Fix an Auto-Generated Database Migration

Column rename migration fix

Criteria

Without context

With context

Identifies drop+add problem

100%

Alembic rename limitation

100%

Data loss risk noted

100%

Uses op.alter_column()

100%

new_column_name parameter

100%

No drop_column in upgrade

100%

Correct downgrade

100%

Revision chain checked

Column attributes preserved

100%

Revision metadata unchanged

100%

95%

-2%

Review a Migration for New Agreement Workflow State

Enum value migration gap detection

Criteria

Without context

With context

Identifies missing enum change

100%

Alembic enum limitation

100%

Adds op.execute() call

100%

Correct ALTER TYPE syntax

100%

Correct enum type name

100%

New enum value string correct

100%

Downgrade limitation noted

100%

cancelled_date column retained

100%

Revision chain checked

40%

Does not accept as complete

100%

Review a Production-Bound Migration for a New Required Field

NOT NULL column migration safety

Criteria

Without context

With context

Identifies NOT NULL problem

100%

Explains failure mechanism

100%

Production data risk noted

100%

Safe strategy proposed

100%

Fixed migration is safe for existing rows

100%

Backfill or default provided

100%

NOT NULL constraint applied

100%

Correct downgrade

100%

Does not approve as-is

100%

Data migration between schema steps

100%

Repository: HHS/OPRE-OPS
Commit: e2a9461

Evaluated: 2 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Audit and Fix an Auto-Generated Database Migration Review a Migration for New Agreement Workflow State Review a Production-Bound Migration for a New Required Field

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.