Skip to content

ericrisco/rsc-harness / skills/sql

Use when writing or reviewing advanced SQL query logic independent of any one engine — multi-table joins, window functions, CTEs including recursive ones, GROUP BY and GROUPING SETS aggregation, and set operations — or when a query returns too many rows, too few, or wrong totals. NOT engine internals, indexes or EXPLAIN (that is `postgresdb`), NOT MySQL config (that is `mysql`), NOT OLAP columnar specifics (that is `duckdb`).

FileKindSize
SKILL.mdskill md14.9 KB
evals/README.mdmarkdown1.4 KB
evals/cases.yamlconfig3.0 KB
references/ctes-and-recursion.mdmarkdown2.7 KB
references/joins-and-sets.mdmarkdown3.2 KB
references/portability.mdmarkdown2.8 KB
references/window-functions.mdmarkdown3.7 KB
scripts/verify.shexecutablescript5.5 KB

evals/README.md

View on GitHub
# Eval harness — `sql`

These cases are hand-graded prompts, not an automated test suite. Run them through an agent harness and grade honestly.

**Triggering.** For each prompt in `cases.yaml`, start a fresh agent session with only the `sql` skill discoverable, paste the prompt verbatim, and run 3–5 trials (the decision is stochastic). A `should_trigger` case passes if the skill fires in the majority of trials; a `should_not_trigger` case passes if it stays quiet and the agent would plausibly route to the named `route_to` sibling (or `none`). Aim for ≥ 90% trigger accuracy across all cases — the near-misses (indexing, MySQL config, ORM builder, migrations, ClickHouse) deliberately share vocabulary with this skill, so they test intent, not keywords.

**Capability.** Run each `capability` scenario twice — once WITHOUT the skill (clean agent) and once WITH it loaded — and score each transcript against its `must_include` rubric, one point per bullet that is specifically and correctly covered (not merely name-dropped). The skill passes if WITH-coverage reaches ≥ 80% of the bullets and clearly beats WITHOUT (target ≥ +30 points or fail→pass). If a baseline agent already nails the rubric, tighten it.

**Artifact check.** `scripts/verify.sh` lints emitted `.sql` files heuristically (read-only, no DB connection); it complements the capability eval but does not replace it. Record trial counts and per-bullet verdicts so a reviewer can audit.
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