Catch the ALTER TABLE that would lock your production database for 45 minutes
Reviews database migration scripts for dangerous operations — long-running locks, data loss risks, and backward-incompatible changes. Suggests safe alternatives using online schema change tools.
Create a skill called "Migration Guardian". Review database migration scripts for safety: 1. Parse migration files (SQL, Flyway, Liquibase, Alembic, Rails, Prisma, etc.) 2. Flag dangerous operations: - ALTER TABLE that acquires long-running locks (adding columns with defaults on old MySQL, adding indexes without CONCURRENTLY on Postgres) - DROP TABLE or DROP COLUMN (data loss) - Large data backfills - Changes that break backward compatibility with the current application version 3. For each dangerous operation, suggest a safe alternative: - Use CREATE INDEX CONCURRENTLY instead of CREATE INDEX - Use online schema change tools (gh-ost, pt-osc) for large MySQL tables - Use expand-contract pattern for breaking changes 4. Estimate lock duration if table size info is available 5. Generate a rollback script for each migration 6. Verify migration ordering and dependency chain
A seemingly innocent `ALTER TABLE ADD COLUMN WITH DEFAULT` can lock a large
table for minutes or hours. This skill reviews migration scripts and flags
operations that could cause downtime, suggesting safe alternatives.
Stop the push-and-pray CI debugging loop
Paste your failing pipeline config and the error log. Your Claw spots YAML mistakes, platform-specific gotchas, and likely root causes before you burn another CI run.
Faster builds, smaller images, fewer headaches
Paste your Dockerfile and get it back cleaner, smaller, and easier to cache. Good starter recipe for developers because the advice is concrete and the output is easy to compare against the original.
Reduce travel stress with checklists and realistic routines
Builds a travel plan that covers safety basics, sleep/meal routines, and packing checklists for car or air travel — so you're not improvising under pressure.
Catches wrong quantity or off-market limit prices
Traders frequently report costly order entry mistakes (wrong limit price, wrong size), especially while rushed. This recipe blocks orders that look like outliers relative to current price and usual size.