Open Source SQLite Projects
SQLite is a lightweight relational database engine that stores an entire database in a single file and runs without a separate server. It supports SQL queries, transactions, indexing, and reliable local data storage, making it useful for embedded applications, desktop software, mobile devices, and development workflows. Its compact design reduces operational overhead while keeping structured data accessible across platforms.
Open source tools in this area include database browsers, command-line clients, libraries, application frameworks, and synchronization utilities. When choosing one, consider its license, maintenance activity, compatibility with your language and SQLite version, required extensions, and how it handles backups or concurrent access. These tools can help developers, data analysts, and individuals who want portable, locally stored data.
6 repositories · updated September 5, 2026
AgentFS: The Filesystem Designed for AI Agents and Their State Management
AgentFS is an innovative filesystem specifically engineered for AI agents, providing robust storage abstractions. It leverages SQLite to offer auditability, reproducibility, and portability for agent states, tool calls, and file operations. This solution simplifies debugging, analysis, and deployment of AI agents by encapsulating their entire runtime into a single, queryable database file.
Leo-Health-Core: Unify Apple Health & Whoop Data Locally with SQLite
Leo-Health-Core is an open-source Python tool designed to parse Apple Health and Whoop exports, unifying your biometric data into a local SQLite database. It operates with zero dependencies and no network requests, ensuring complete privacy and local control over your health information. This project allows users to easily query and analyze their personal health trends using standard SQL.
ZeQLplus: A Fast Terminal SQLite Database Browser
ZeQLplus is an open-source terminal-based SQLite database browser designed for speed and simplicity. It provides a lightweight solution for interacting with SQLite databases directly from your command line, supporting various platforms. Users can efficiently browse tables, view paginated rows, and execute custom SQL queries.
SQL Studio: A Universal SQL Database Explorer Built with Rust
SQL Studio is a versatile, single-binary SQL database explorer built with Rust, offering broad compatibility with databases like SQLite, PostgreSQL, MySQL, DuckDB, and Microsoft SQL Server. It provides a comprehensive set of features for database interaction, from schema overview to advanced query capabilities with rich IntelliSense. This tool simplifies database management and exploration across diverse environments.
Drizzle ORM: A Headless TypeScript ORM for Modern Web Development
Drizzle ORM is a modern, lightweight, and headless TypeScript ORM designed for NodeJS, TypeScript, and JavaScript environments. It offers robust support for various SQL databases, including serverless options, and emphasizes type-safety and extensibility. With over 31,000 stars, Drizzle ORM is a popular choice for developers seeking a performant and flexible solution for their data interactions.
Marmot: Distributed SQLite Replication with NATS
Marmot is a distributed SQLite replicator that provides leaderless, eventually consistent replication built on NATS JetStream. It enables scaling read-heavy SQLite applications by allowing multiple nodes to read and write to their local databases. This innovative approach offers fault tolerance and simplifies scaling without requiring a single primary node.