SQLite Search
Offline sqlite search over approved brain notes.
Before you install · 0.1.0
What it touches, and what it needs
The author declared these for this release, and review checked them against what the stack does, including what its skills ask the agent to do. They are declarations, not a sandbox.
About
Ranked offline full-text search over approved Dryft brain notes using SQLite FTS5. Searches titles and contents, giving title matches more weight. Maintains a disposable local index while Markdown remains authoritative. No API key, external database, model download or background service is required.
Capabilities
- Reads files
Approved brain-note content supplied by Dryft and the provider’s local SQLite index
Index approved notes and find matching current notes by title and content.
Leaves your machine: None from the provider. Results returned to a host agent may be processed by its configured service.
- Writes files
Dryft-managed disposable SQLite index
Store note IDs, hashes, titles and contents; reconcile changed/deleted notes and replace the index on rebuild. Markdown notes remain unchanged.
None.
- Runs processes
assets/provider.py, launched with Dryft’s Python interpreter
Execute on-demand indexing and ranked full-text search using SQLite FTS5. Requires explicit executable trust and runs with the user’s OS permissions.
Leaves your machine: None from the provider; communication with Dryft uses local JSON input/output.
Prerequisites
Supply approved notes, manage the index, validate provider results and enforce executable trust.
Required
Run the provider using Dryft’s own Python 3.12 interpreter on Linux x86_64.
Required
Provide full-text indexing and ranking through that interpreter’s built-in sqlite3 module. Installing the SQLite command-line tool alone is insufficient.
Required
Executable hooks
No hooks. Nothing runs on session start or turn completion.
Supported agents
Claude Code and Codex
Release source and checksums
The Dryft CLI downloads this commit from GitHub, never a branch or a moving tag, and refuses the archive unless both digests match. A tag that moves later does not change this record.
Review notes
Reviewed the exact public release archive, Python provider, manifest asset hash/size, requirements and disclosures. Disposable Claude/Codex installation and doctor passed. Python 3.12 SQLite FTS5 checks passed indexing, title-weighted ranking, stale/deleted-note exclusion and rebuild using synthetic notes. Provider has no network calls or background service. Executable trust is required; it runs with user OS access. Compatibility is Linux x86_64, Dryft 0.1 and Python 3.12 with FTS5. macOS/native Windows are not supported by this release manifest.
- 0.1.0
- v0.1.0
- b7898337a165638933201e28cc15b1d29c21cf9eefb544404d521b04d1dcc136
- b58f0c8c23923f8533fcc9cf6226485db4dad7277528d38c15194ab0065978a0
- v2
Versions
Every approved version, newest first. There are no automatic updates: use dryft stack update dryft-search-sqlite to inspect and approve a newer one.
0.1.0Latest
dryft stack install dryft-search-sqlite --version 0.1.0 --inspectCapabilities
- Reads files
Approved brain-note content supplied by Dryft and the provider’s local SQLite index
Index approved notes and find matching current notes by title and content.
Leaves your machine: None from the provider. Results returned to a host agent may be processed by its configured service.
- Writes files
Dryft-managed disposable SQLite index
Store note IDs, hashes, titles and contents; reconcile changed/deleted notes and replace the index on rebuild. Markdown notes remain unchanged.
None.
- Runs processes
assets/provider.py, launched with Dryft’s Python interpreter
Execute on-demand indexing and ranked full-text search using SQLite FTS5. Requires explicit executable trust and runs with the user’s OS permissions.
Leaves your machine: None from the provider; communication with Dryft uses local JSON input/output.
Prerequisites
Supply approved notes, manage the index, validate provider results and enforce executable trust.
Required
Run the provider using Dryft’s own Python 3.12 interpreter on Linux x86_64.
Required
Provide full-text indexing and ranking through that interpreter’s built-in sqlite3 module. Installing the SQLite command-line tool alone is insufficient.
Required
Executable hooks
No hooks. Nothing runs on session start or turn completion.
Supported agents
Claude Code and Codex