ericrisco/rsc-harness / skills/sqlite-turso
sqlite-turso
VerifiedUse when deciding whether plain SQLite is enough, or wiring SQLite, Turso or libSQL for local-first, edge and embedded-replica apps — a local file DB, a remote Turso URL, or a local replica synced to a remote primary — plus WAL mode and SQLite's single-writer model and its lock errors. NOT Drizzle schema or queries on libSQL (that is `drizzle-orm`), NOT versioned up/down migrations (that is `db-migrations`), NOT serverless Postgres with branching (that is `neon`).
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 11.4 KB |
| evals/README.md | markdown | 1.7 KB |
| evals/cases.yaml | config | 4.0 KB |
| references/embedded-replicas.md | markdown | 5.6 KB |
| scripts/verify.shexecutable | script | 3.6 KB |
evals/README.md
View on GitHub# Eval harness — `sqlite-turso`
Two things get checked: **triggering** (does the skill fire on real SQLite/Turso situations and stay
quiet on near-misses that belong to a sibling?) and **capability** (does loading it measurably
improve the answer?). Cases live in `cases.yaml`. These run through an agent harness, not a pure
shell script — a human or driver agent feeds each prompt and grades the output.
**Triggering.** For each prompt, start a fresh session with only `sqlite-turso` discoverable, paste
the prompt verbatim, run 3–5 trials (the decision is stochastic). `should_trigger` passes if the
skill fires in the majority of trials; `should_not_trigger` passes if it does not fire — and when a
`route_to` is named (drizzle-orm, db-migrations, postgresdb, neon, vector-db), sanity-check the agent
would plausibly route there. Pass bar: ~90% accuracy across all trigger cases.
**Capability.** Run the scenario twice — once WITHOUT the skill, once WITH — and grade each
transcript against the `must_include` checklist, one point per bullet genuinely covered (not just
name-dropped). Pass bar: WITH the skill covers ≥80% of bullets and clearly beats WITHOUT.
**verify.sh spot-check (separate, deterministic).** `scripts/verify.sh` is a static, read-only,
no-network gate for generated connection files. Sanity-check it by hand: a file with `createClient` +
`syncUrl` + a local `file:` url + an env-var token should pass; flip the token to a string literal,
drop the `file:` url, or call `sync()` patterns on a remote-only client and confirm it FAILs. Running
it against an empty directory must print nothing actionable and exit 0.
Record trial counts and per-bullet verdicts so a reviewer can audit; don't report a bare pass/fail.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |