Creates safe database migrations with proper indexes and rollback strategies. Use when creating tables, adding columns, creating indexes, handling zero-downtime migrations, or when user mentions migrations, schema changes, or database structure.
89
88%
Does it follow best practices?
Impact
85%
1.34xAverage score across 3 eval scenarios
Passed
No known issues
Safe concurrent index creation
disable_ddl_transaction!
100%
100%
algorithm: :concurrently
100%
100%
if_not_exists: true
0%
100%
Composite index column order
100%
100%
Partial index where clause
100%
100%
Foreign key indexed
100%
100%
Migration version [8.0]
100%
100%
Reversible migrations
100%
100%
No direct add_index without concurrently
100%
100%
Index name specified
0%
100%
Safe column type change with batched backfill
No change_column
100%
100%
New column added first
100%
100%
Batched backfill
100%
100%
sleep in batch loop
0%
100%
disable_ddl_transaction! on data migration
100%
100%
safety_assured on remove_column
0%
100%
Old column removed
100%
100%
Migration version [8.0]
100%
100%
Reversible migrations
100%
100%
Separate migration files
100%
100%
NOT NULL constraint and enum column migration
Two-step NOT NULL
0%
0%
Initial column nullable
0%
50%
Enum uses :integer type
0%
100%
Enum default: 0
0%
100%
Enum column indexed
100%
100%
on_delete specified
0%
0%
Migration version [8.0]
100%
100%
Reversible migrations
100%
100%
change_column_null usage
0%
0%
Enum model declaration
0%
100%
15fdeaf
Table of Contents
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.