Manages personal knowledge and thinking trails using a local-first SQLite database integrated with Claude Code.
SQLite Notes is a sophisticated personal knowledge management (PKM) system designed for Claude Code users who need a persistent 'memory-on-disk.' It moves beyond simple text files by using a structured SQLite database to track the evolution of ideas through notes, resources, clippings, and AI-generated reflections. The skill emphasizes provenance and epistemic status, allowing you to distinguish between your own thoughts, external sources, and AI-generated synthesis. With built-in full-text search and a flexible linking system, it transforms Claude from a chat interface into a powerful partner for long-term thinking and knowledge building.
Key Features
01High-performance full-text search (FTS5) for rapid knowledge retrieval.
02Local-first SQLite storage for complete data ownership and portability.
03Epistemic status tagging (fleeting to settled) to manage the lifecycle of ideas.
04Granular provenance tracking to identify human vs. AI-generated content.
0531 GitHub stars
06AI-generated 'breadcrumbs' to snapshot and track intellectual momentum over time.
Use Cases
01Synthesizing complex research by linking external clippings to AI-assisted reflections.
02Building an evergreen personal knowledge base directly within your terminal and dev environment.
03Tracking the lineage and evolution of technical decisions during long-term projects.
