Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →zzafergok/database-migrations-skill
SQL database migration strategies with zero-downtime deployment, rollback plans, and data integrity validation for PostgreSQL, MySQL, and SQL Server.
Passed 20 of 22 test cases with the skill, and 18 of 22 without it.
2 fixed18 passed either way2 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
This benchmark measured an earlier version of the skill.
One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.
We want to replace the full_name column with display_name on the users table using the Expand-Contract pattern. What exact SQL operations belong in Phase 1 (Expand)?
| Checked | Without skill | With skill |
|---|---|---|
| Adds the new column as nullable | Passed | Passed |
| Backfills existing rows in batch updates | Missed | Passed |
The instructions your model reads when the skill loads.
Zero-downtime SQL database migration strategies for PostgreSQL, MySQL, and SQL Server.
Answer these four questions for every production migration:
The standard approach for large schema changes consists of three phases.
Add the new structure and preserve the old one:
-- Add the new column as NULL (minimal lock)
ALTER TABLE users ADD COLUMN display_name VARCHAR(255);
-- Backfill existing data in batches
UPDATE users
SET display_name = full_name
WHERE display_name IS NULL
AND id BETWEEN :start AND :end;
Update the application code to read and write the new column while continuing to write the old column.
test cases passed, vs 18 / 22 without
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.