SQLite Search

tdt-search-sqlite

FunctionalityClaude CodeCodex

Offline sqlite search over approved brain notes.

By ThisDamnThing · submitted by @CharlGottschalk · Apache-2.0

Extends how ThisDamnThing itself works.

Before you install · 0.1.3

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

A ThisDamnThing stack that adds ranked full-text search to your approved brain notes. It uses SQLite FTS5 to search titles and contents, giving title matches more weight. Indexing and searching run locally without an API key, external service or model download. Your Markdown notes remain the source for every result.

search #offline #sqlite

Capabilities

3

Reads filesfile_read
Scope Approved brain notes supplied by the host.
Index and search approved notes.
Leaves your machine: None.
Writes filesfile_write
Scope Stack-owned local SQLite search index.
Build, replace and remove the search index.
Leaves your machine: None.
Runs processesprocess
Scope Bundled Python brain.search provider.
Run offline SQLite FTS5 indexing and search.
Leaves your machine: None.

Prerequisites

2

ThisDamnThingCommand-line tool
thisdamnthing >=0.1.1
Validate and install the stack; provide workspace commands and contracts.
Required
PythonRuntime
python 3.12
Run local helper scripts and providers.
Required

Executable hooks

0

No hooks. Nothing runs on session start or turn completion.

Supported agents

Claude Code and Codex

Compatibility reviewed for this version, not a guarantee for every host version or platform.

Release source and checksums

The ThisDamnThing 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 pinned archive and changes from the previously approved release: version and usetdt.com link updates only. Core and website manifest/tag validation and disposable installation/removal passed on Linux with Python 3.12. SQLite indexing, search and stale-note exclusion passed.

Version: 0.1.3
Release tag: v0.1.3
Commit: 6c2af46c20bb8659e9f55db55b9c591660a45946
Archive SHA256: eff1a05e100a87aaa1333907372dffb45f8cabe7e36774a80db77ca1536bf733
Content SHA256: 4add1e986664bcefb7958daf09ac4efe00c37a754ac49043228aa1049e4be029
Stack contract: v2

Versions

Every approved version, newest first. There are no automatic updates: use tdt stack update tdt-search-sqlite to inspect and approve a newer one.

0.1.3LatestApproved 23 Sept 20266c2af46c20bb3 capabilities · 2 prerequisites · 0 hooks
Inspect this version:
$tdt stack install tdt-search-sqlite --version 0.1.3 --inspect
Capabilities
3
Reads filesfile_read
Scope Approved brain notes supplied by the host.
Index and search approved notes.
Leaves your machine: None.
Writes filesfile_write
Scope Stack-owned local SQLite search index.
Build, replace and remove the search index.
Leaves your machine: None.
Runs processesprocess
Scope Bundled Python brain.search provider.
Run offline SQLite FTS5 indexing and search.
Leaves your machine: None.
Prerequisites
2
ThisDamnThingCommand-line tool
thisdamnthing >=0.1.1
Validate and install the stack; provide workspace commands and contracts.
Required
PythonRuntime
python 3.12
Run local helper scripts and providers.
Required
Executable hooks
0
No hooks. Nothing runs on session start or turn completion.
Supported agents
Claude Code and Codex
Compatibility reviewed for this version, not a guarantee for every host version or platform.
archive eff1a05e100a87aaa1333907372dffb45f8cabe7e36774a80db77ca1536bf733 · content 4add1e986664bcefb7958daf09ac4efe00c37a754ac49043228aa1049e4be029
0.1.2Approved 21 Sept 20269f06b84f3b6b3 capabilities · 2 prerequisites · 0 hooks
Inspect this version:
$tdt stack install tdt-search-sqlite --version 0.1.2 --inspect
Capabilities
3
Reads filesfile_read
Scope Approved brain notes supplied by the host.
Index and search approved notes.
Leaves your machine: None.
Writes filesfile_write
Scope Stack-owned local SQLite search index.
Build, replace and remove the search index.
Leaves your machine: None.
Runs processesprocess
Scope Bundled Python brain.search provider.
Run offline SQLite FTS5 indexing and search.
Leaves your machine: None.
Prerequisites
2
ThisDamnThingCommand-line tool
thisdamnthing >=0.1.1
Validate and install the stack; provide workspace commands and contracts.
Required
PythonRuntime
python 3.12
Run local helper scripts and providers.
Required
Executable hooks
0
No hooks. Nothing runs on session start or turn completion.
Supported agents
Claude Code and Codex
Compatibility reviewed for this version, not a guarantee for every host version or platform.
archive b4d6f1fac44a0232b840dae6cd9f365dea289a097e598c8849616a35a9b9c1ce · content e7f628b2e88d6b904b296c3c90f13f2c8449e1db90d073da4c16df20eeb1e80f