Skip to content

ericrisco/rsc-harness / skills/db-migrations

db-migrations

Verified

Use when a schema change must ship without downtime — NOT NULL, rename, type change, or backfilling millions of live rows — for the expand-contract sequence and the lock/batching discipline that keeps each step from freezing prod. NOT lock internals or EXPLAIN (that is `postgresdb`), NOT drizzle-kit mechanics (that is `drizzle-orm`), NOT PITR (that is `backups`).

FileKindSize
SKILL.mdskill md12.9 KB
evals/README.mdmarkdown774 B
evals/cases.yamlconfig3.1 KB
references/backfill-and-batching.mdmarkdown4.0 KB
references/expand-contract-playbook.mdmarkdown5.5 KB
references/tools-and-runners.mdmarkdown5.1 KB
scripts/verify.shexecutablescript4.6 KB

evals/README.md

View on GitHub
# Evals — db-migrations

`cases.yaml` specifies routing and capability expectations, not live database runs. `should_trigger` /
`should_not_trigger` are prompt-routing checks: feed each prompt to the router and confirm db-migrations
fires (or that the named sibling — postgresdb, drizzle-orm, backups, sql, planetscale — wins instead).
The `capability` case is a rubric: ask the model to plan the column rename, then score the response
against the `must_include` bullets (each phase present, in order, with lock_timeout, batched/throttled
backfill, checksum verify, N/N-1, cooling period, forward-only). There is no database connection here;
the DDL-shape and self-consistency check lives in `../scripts/verify.sh`. Run these through the repo's
standard eval harness.
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall