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.svg" alt="Measured on agentmods" 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 | $0.00019 | $0.00211 |
| Sonnet 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 7d 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.
- 7d 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 2mo ago), licensed MIT. It adds 39 tokens to every session and 423 once invoked, about $0.0002 per session on Opus 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.
Other skills, from other repositories
orchardcore-ai-memory-elasticsearch
Skill for indexing CrestApps Orchard Core AI Memory with Elasticsearch. Covers memory field mappings, dense vectors, k-nearest-neighbor retrieval, default query fields, user isolation, and Elasticsearch operations. Use this skill when requests mention AI Memory Elasticsearch, AIMemoryElasticsearchIndexProfileHandler…
crestapps-core-ai-memory
Skill for durable user memory, safety validation, and memory-aware orchestration in CrestApps.Core.
narsil
Use narsil-mcp code intelligence tools effectively. Use when searching code, finding symbols, analyzing call graphs, scanning for security vulnerabilities, exploring dependencies, or performing static analysis on indexed repositories.
setup-location-memory
Install or repair the location archive. Use when the location tools are missing, when they error on the database, when the user wants to import a Google Timeline export, when they want to start a live feed from OwnTracks, or when they ask to set up location memory.
lore-onboard
First-time setup wizard for LoreConvo. Verifies the MCP server is connected, the database is accessible, hooks are configured, and runs a test save/load cycle. Use when the user says "set up loreconvo", "onboard", "/lore-onboard", "verify loreconvo", "test loreconvo setup", or after first installing the plugin.
sepia
Use when the user's AI assistant should recall or persist long-term knowledge about the user, their projects, preferences, decisions, people, conventions, or technical stack — across sessions and across tools. Triggers: starting meaningful work ("remember that", "what do we know about", "recall", "save this for…