Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →jezweb/d1-migration
Cloudflare D1 migration workflow: generate with Drizzle, inspect SQL for gotchas, apply to local and remote, fix stuck migrations, handle partial failures.
Passed 22 of 23 test cases with the skill, and 12 of 23 without it.
and 11 more in the full report
10 fixed12 passed either way1 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 10 test cases the skill fixed. Same model, same prompt, with and without the skill.
When manually inserting a record into the d1_migrations table for a stuck remote migration named 0005_add_role.sql, what exact SQL function call should be used for the timestamp?
| Checked | Without skill | With skill |
|---|---|---|
| Instructs using datetime('now') for the applied_at column in the manual d1_migrations INSERT statement. | Missed | Passed |
The instructions your model reads when the skill loads.
Guided workflow for Cloudflare D1 database migrations using Drizzle ORM.
pnpm db:generate
This creates a new .sql file in drizzle/ (or your configured migrations directory).
Always read the generated SQL before applying. Drizzle sometimes generates destructive migrations for simple schema changes.
If you see this pattern, the migration will likely fail:
CREATE TABLE `my_table_new` (...);
INSERT INTO `my_table_new` SELECT ..., `new_column`, ... FROM `my_table`;
-- ^^^ This column doesn't exist in old table!
DROP TABLE `my_table`;
ALTER TABLE `my_table_new` RENAME TO `my_table`;
Cause: Changing a column's default value in Drizzle schema triggers full table recreation. The INSERT SELECT references the new column from the old table.
Fix: If you're only adding new columns (no type/constraint changes on existing columns), simplify to:
ALTER TABLE `my_table` ADD COLUMN `new_column` TEXT DEFAULT 'value';
Edit the .sql file directly before applying.
test cases passed, vs 12 / 23 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.