sqlite

Mnemo is an open-source, local-first memory layer for any LLM that extracts entities and relationships into a persistent knowledge graph using SQLite and petgraph, providing automatic context injection for enhanced conversations.

The EverOS open-source library has completed a major refactoring, storing original memory directly as Markdown files, supplemented by SQLite for state management and LanceDB for retrieval, significantly improving developer readability, modifiability, and fault recovery.

ArcRift is an open-source desktop app and Chrome extension that provides persistent, local memory for AI chats across platforms like Claude and ChatGPT using a local SQLite database and Ollama, solving the problem of AI amnesia.

This blog post argues that SQLite, combined with Litestream for async backups, provides a simple and effective approach to durable execution for many workflow systems, especially AI agents, without needing a separate orchestration tier or network database.

A technical blog post demonstrating how Profile-Guided Optimization (PGO) with LLVM can significantly improve binary performance beyond standard -O3 and LTO, using SQLite as a benchmark.

SQLite has added an AGENTS.md file stating it does not accept agentic code but welcomes agentic bug reports with reproducible test cases, and has split AI-generated bug reports into a separate forum.

Mission Control is an open-source dashboard for AI agent orchestration, self-hosted with zero external dependencies, featuring real-time monitoring, multi-gateway support, and role-based access.

Datasette Agent is a new extensible AI assistant for Datasette that lets users query their data conversationally and generate charts via plugins. It supports local models and cloud APIs like Gemini 3.1 Flash-Lite.

Turso used the Quint formal verification tool to model SQLite's C API and discovered over 10 bugs in SQLite itself, enhancing the reliability of their SQLite rewrite.

Pro Workflow is a plugin for Claude Code and Cursor that adds self-correcting memory and persistent wikis using SQLite, allowing the AI to learn from corrections and build knowledge across sessions.

Witchcraft is an open-source re-implementation of Stanford's XTR-Warp semantic search engine in Rust, using SQLite for fast local search. It includes Pickbrain CLI for indexing code session transcripts and equipping AI agents with global memory.

Tabularis is an open-source, cross-platform modern database client that supports PostgreSQL, MySQL/MariaDB, and SQLite, with built-in AI, MCP, and Notebook, and supports plugin extensions. Designed for developers.

A tweet highlights a free, open-source Mac app that is great for databases and fast for viewing local SQLite files.

Hermes agent's three-tier memory system combines tiny always-present markdown files, full-text SQLite+FTS5 session search, and pluggable external providers to give AI agents persistent, curated memory that composes on every turn.

This article explains how rqlite, a distributed SQLite database, takes control of SQLite's Write-Ahead Log to enable efficient snapshotting for Raft consensus, avoiding full database copies by using the WAL as incremental state.

Release of Hermes Memory Installer v2.2.0, a zero-dependency Python tool providing tiered long-term memory and RRF fusion for AI agents, alongside an early-stage structured vibe-coding pipeline.

Context Mode is a tool that solves AI agent context problems by sandboxing tool outputs and persisting sessions, achieving up to 98% compression of Playwright snapshots and using BM25 retrieval to reduce context window usage. It supports 15 platforms including Claude Code, Gemini CLI, VS Code Copilot, and is used by major tech companies.

The author describes replacing a 3 GB SQLite database with a 10 MB Finite State Transducer (FST) binary to optimize a Finnish-English dictionary tool, achieving a 300x reduction in memory usage while maintaining performance.

Honker is a SQLite extension that adds PostgreSQL-style NOTIFY/LISTEN semantics, enabling durable pub/sub and task queues without external brokers or polling.

Antenna is a local-first RSS reader that stores feeds in SQLite and exposes them via email digests and an MCP server for AI agents, all under MIT license.