sqlite

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.

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.

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.

JFrog Security Research investigates a batch of SQLite CVEs and argues many are AI-generated or unsupported by the source code and PoC testing. The post includes a comparison matrix, methodology, and detailed breakdown of several alleged vulnerabilities.