Stevens: a hackable AI assistant using a single SQLite table and a handful of cron jobs

The design is refreshingly simple considering how much it can do. Everything works around a single memories table. A memory has text, tags, creation metadata and an optional date for things like calendar entries and weather reports.
— Read on simonwillison.net/2025/Apr/13/stevens/