Skip to content

ericrisco/rsc-harness / skills/sqlite-turso

sqlite-turso

Verified

Use 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`).

FileKindSize
SKILL.mdskill md11.4 KB
evals/README.mdmarkdown1.7 KB
evals/cases.yamlconfig4.0 KB
references/embedded-replicas.mdmarkdown5.6 KB
scripts/verify.shexecutablescript3.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.
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