sqlite

Local-first SQLite memory engine for AI coding tools that preserves project decisions and context across agents and model switches.

A local-first Windows tool for indexing, searching, and loading large agent skill libraries without keeping full skill bodies in context. It supports SQLite FTS5 search, multiple ranking modes, CLI use, HTTP, and MCP stdio.

Local-first record, inspect, and replay tool for debugging AI agents. Orchid captures LLM calls and tool traffic through a proxy, exposes traces in a web UI and MCP tools, and supports offline replay for deterministic testing.

Rudi is a Python tool for LLM memory management that replaces a growing chat transcript with a causal dependency graph, aiming to keep token usage flat across long sessions. The README shows benchmarking results, fold behavior, and example usage with get_slice, store_decisions, and run_turn.

A lightweight terminal AI sidecar for Zellij that keeps quick questions separate from your main agent session, with local JSONL logging, SQLite search, and multiple LLM provider options.

A tutorial and live demo showing how to build an AI SQL analyst agent that inspects schema, writes queries, runs them, and explains results using Node.js, OpenAI, Vercel AI SDK, and SQLite.

Chemical X is a developer tool for autonomous coding agents that combines AST-based linting, SQLite symbol indexing, silent verification, and an MCP gateway to reduce context noise and catch code decay.

Shared, append-only memory for AI coding agents. Vera lets Claude, local models, and Codex read and write the same numbered memory log so projects can continue across sessions.

Open-source AI harness for jailbroken iPhones and older Macs that lets you query local SQLite databases through LLM tools. The repo describes personal-assistant and coding-assistant modes, a C backend, Objective-C UI, and Linux test coverage.

A plugin for recording AI coding agent activity in a tamper-evident local audit trail. It stores sessions, tool calls, prompts, and integrity checkpoints in SQLite and exposes CLI and UI views for status, reports, anomalies, spend, inventory, exports, and proof verification.

OpenSmith is a local-first, open-source alternative to LangSmith for tracing Python LLM pipelines. It supports decorators, context managers, console output, autopatching, CLI commands, local SQLite storage, and optional Postgres and OpenTelemetry integrations.

Local-first task and context manager for humans and AI coding agents. It stores tasks, plans, docs, and memory in a shared SQLite database, with CLI commands, a web UI, and agent attribution built in.

FERNme is an open-source memory engine for AI agents that uses fuzzy graphs and Hebbian-style updates to store user preferences with near-zero LLM calls. The repository highlights editable user-owned memory, flat token usage, outcome-based reinforcement, and deployable plumbing via REST and MCP.

A local Go tool that turns encrypted iOS WhatsApp backups into a searchable workspace for AI agents, with OCR, transcription, and SQLite/FTS5 indexing.

Local-first long-term memory engine for AI agents with MCP, HTTP API, CLI, and Python usage. The page shows installation paths, IDE integrations, ingestion sources, and a live feature set focused on durable context, retrieval, and privacy.

Self-hosted memory layer for coding agents. It stores notes as Markdown in a local folder and exposes them over MCP so tools like Claude Code, Codex, and Cursor can recall shared context.

Aquifer is a self-hosted MCP gateway runtime for buffering spiky agent and API traffic. It queues requests durably in SQLite, dispatches them at a configurable rate, and supports both MCP and HTTP adapters with webhook delivery.

A local AI coding harness that turns business-rule specs into a constrained JSON AST, validates it, and compiles it into Clojure code while logging generation and repair artifacts.

An offline agent mesh for Termux/Android that runs a self-testing, SQLite-based agent system on-device. The repo shows install steps, tier-by-tier commands, and a detailed breakdown of the mesh components and design rules.

An open-source, headless CRM built for Claude and other agents, centered on a portable .acrm file, a CLI, and versioned SQL-backed workflows for sales data, transcripts, and follow-up tasks.

Local long-term memory for a personal AI that keeps raw conversation logs, timestamps every record, and uses time-aware retrieval plus a small current-topic index.

A lightweight SQLite FTS5 memory layer and MCP server for Google Antigravity agents, with CLI tools for storing, searching, and syncing facts.

A GitHub-hosted technical guide for running a multi-tier agent system on Termux, with SQLite used for messaging, scheduling, and audit logs, plus thermal-aware admission control for Android devices.

A lightweight open-source telemetry collector for agentic systems. It stores events in SQLite, serves a local dashboard, and provides HTTP endpoints to send and retrieve agent events.