Borrowing it
Nothing to install: this file belongs to wmt-mobile/localnest. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/wmt-mobile/localnest/main/.claude/skills/localnest-sql-adapter/SKILL.mdgit clone --depth 1 https://github.com/wmt-mobile/localnestWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/wmt-mobile/localnest/localnest-sql-adapter)<a href="https://agentmods.dev/skills/wmt-mobile/localnest/localnest-sql-adapter"><img src="https://agentmods.dev/badge/skills/wmt-mobile/localnest/localnest-sql-adapter/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/wmt-mobile/localnest/localnest-sql-adapter"><img src="https://agentmods.dev/badge/skills/wmt-mobile/localnest/localnest-sql-adapter.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00039 | $0.00423 |
| Opus 5.5 | $0.00016 | $0.00169 |
| Sonnet 5.5 | $0.00008 | $0.00085 |
| Haiku 4.5 | $0.00004 | $0.00042 |
Grade A, and why
localnest-sql-adapter scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
What it actually says
LocalNest SQL Adapter
Use this skill when working on LocalNest database access in:
src/services/retrieval/sqlite-vec/src/services/memory/src/app/create-services.ts- runtime/setup code that selects SQLite backends
Quick Start
- Find direct DB bindings first.
- Separate adapter-selection changes from query/schema changes.
- Preserve current Node 22 behavior unless the task explicitly changes defaults.
- Test retrieval and memory paths independently.
Workflow
1. Map the current DB entry points
Check for:
- direct imports of
node:sqlite - direct DB constructors
- extension loading calls
- transaction wrappers
- schema and migration helpers
2. Contain the blast radius
When introducing a new adapter or backend path:
- keep query semantics unchanged first
- avoid mixing schema edits with adapter refactors
- keep the active default path identical for current users until compatibility is proven
3. Verify extension-sensitive behavior
For sqlite-vec work, confirm:
- connection creation allows extension loading
vec0path resolution still works- status output reports whether the extension actually loaded
4. Test both data planes
Do not stop at retrieval tests if memory also touches SQLite. At minimum, cover:
- index creation
- re-index and update behavior
- semantic search fallback behavior
- memory backend detection and status
Guardrails
- Do not eagerly import
node:sqlitefrom general-purpose barrel modules. - Prefer lazy imports for sqlite-specific code paths.
- If adding compatibility adapters, keep them behind explicit selection until verified.
- Surface adapter and backend choice in status output so failures are diagnosable.
Reference
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 2mo ago First seen · 66 lines · 39 tokens per session scan A 932c724c732a
localnest-sql-adapter is a skill published in the GitHub repository wmt-mobile/localnest (6 stars, last pushed 4mo ago), licensed MIT. It adds 39 tokens to every session and 423 once invoked, about $0.0002 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
localnest-sql-adapter compared with skills from other repositories
| Mod | Type | Stars | Last push | Licence | Scan | Tokens | Works with |
|---|---|---|---|---|---|---|---|
| localnest-sql-adapterwmt-mobile/localnest | Skill | 6 | 4mo ago | MIT | A | 39 | Claude Code |
| narsilpostrv/narsil-mcp | Skill | 187 | 1mo ago | Apache-2.0 | A | 42 | Claude Code |
| chromadbEliasOulkadi/shokunin | Skill | 112 | 1mo ago | MIT | A | 61 | Claude Code, Codex |
| orchardcore-ai-memory-elasticsearchCrestApps/CrestApps.AgentSkills | Skill | 13 | 16d ago | MIT | A | 130 | Claude Code |
| crestapps-core-ai-memoryCrestApps/CrestApps.AgentSkills | Skill | 13 | 16d ago | MIT | A | 140 | Claude Code |
| setup-location-memorymichelgrolet/tars-location-mcp | Skill | 0 | 2mo ago | MIT | A | 59 | Claude Code |
| lore-onboardlabyrinth-analytics/loreconvo | Skill | 12 | 10d ago | none | A | 81 | Claude Code |