sqlite-notes

Installation
SKILL.md

SQLite Notes - Personal Thinking Environment

A minimalist sqlite skill for note-taking, thinking trails, and knowledge building.

This skill uses SQLite as a local-first, composable thinking environment that captures the story of how you ended up thinking the way you do, with full lineage and provenance tracking. SQL is the interface, schemas are DDL, and the database is portable.

Overview

sqlite-notes transforms SQLite into a personal knowledge system that:

  • Captures notes, resources, clippings, and reflections with clear provenance
  • Generates AI thinking trail snapshots (breadcrumbs) to track intellectual momentum
  • Organizes notes through workflow stages (inbox, working, permanent, archive)
  • Links entities naturally through a flexible links table and structural foreign keys
  • Synthesizes insights from multiple sources with full lineage tracking
  • Provides full-text search with FTS5 (ranking, boolean operators, snippets)
  • Keeps all data local in a single .sqlite/notes.db file
  • Works seamlessly with Claude Code for AI-assisted thinking and synthesis

Philosophy

Related skills

More from bfollington/terma

Installs
16
GitHub Stars
45
First Seen
Feb 10, 2026