SQLite is a lightweight, serverless, self-contained, and zero-configuration SQL database engine that is widely used in application development for managing small to medium databases. It is embedded directly into the application, allowing you to store all your data in a single cross-platform file, which reduces complexity associated with database servers. SQLite provides full support for transactions, has a minimal footprint, and is renowned for its reliability and performance in situations where a full-fledged relational database system might be overkill. Its simplicity and ease of use make it ideal for applications like mobile apps, desktop applications, and small to medium websites that don’t require the high demands of enterprise-level database management. As an application developer, you can leverage SQLite to execute a range of operations using SQL queries without needing a separate server process, significantly simplifying deployment and maintenance.
View the most prominent open source SQLite projects in the list below. Click on a specific project to view its alternative or complementary packages. Make comparisons and find the best package for your app.
- Persistent Context Across Sessions for Every Agent – Captures everything your agent does during sessions, compresses it with AI, and inj…☆112,843Updated this week
- 🔥 🔥 🔥 A Free & Self-hostable Airtable Alternative☆65,421Updated this week
- Memos is an open-source, self-hosted note-taking app that brings your everyday thoughts together in a personal timeline. Your data stays …☆64,273Updated this week
- Free universal database tool and SQL client☆52,289Updated this week
- Local code intelligence for developers and AI agents. Connect code, docs and infrastructure in a persistent graph, with CBM Lens, MCP too…☆48,105Updated this week
- The Prisma ORM: write your application in TypeScript with human-readable queries instead of SQL. Host your database on Prisma Postgres an…☆47,661Updated this week
- Free, simple, and intuitive online database diagram editor and SQL generator.☆40,244Updated this week
- The flexible backend for all your projects 🐰 Turn your DB into a headless CMS, admin panels, or apps with a custom UI, instant APIs, aut…☆38,818Updated this week
- TypeScript & JavaScript ORM for Node.js — supports PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, and more.☆36,663Oct 29, 2026Updated last week
- ORM☆36,208Updated this week
- Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL …☆30,342Updated this week
- Chat2DB is a free, cross-platform, local-first database client and SQL workspace for developers, DBAs, analysts, and data teams. Connect …☆28,349Updated this week
- 25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Ser…☆29,062Updated this week
- Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite…☆24,754Updated this week
- Modern and easy to use database GUI & SQL client for MySQL, Postgres, SQLite, SQL Server, ClickHouse, and more. Linux, MacOS, and Windows…☆23,844Updated this week
- The local-first database that runs on every JS runtime and replicates with your existing backend - no vendor, no lock-in - https://rxdb.i…☆23,419Updated this week
- Database diagrams editor that allows you to visualize and design your DB with a single query.☆23,073Updated this week
- Database migrations. CLI and Golang library.☆19,006Sep 9, 2026Updated last month
- Generate type-safe code from SQL☆18,432Updated this week
- The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort.☆17,915Updated this week
- 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, …☆17,622Updated this week
- libSQL is a fork of SQLite that is both Open Source, and Open Contributions.☆17,307Oct 17, 2026Updated 2 weeks ago
- 抖音 / TikTok 平台作品下载/数据采集工具☆17,360Updated this week
- Streaming replication for SQLite.☆14,574Updated this week
- A type-safe TypeScript SQL query builder☆14,330Updated this week
- A safe, extensible ORM and Query Builder for Rust☆14,222Updated this week
- A javascript library to run SQLite on the web.☆13,678Oct 26, 2026Updated last week
- 小红书（XiaoHongShu、RedNote）链接提取/作品采集工具☆13,209Updated this week
- Rethinking Student Productivity☆12,163Oct 17, 2024Updated 2 years ago
- a small, expressive orm -- supports postgresql, mysql, sqlite, now with asyncio☆12,007Updated this week
- WCDB is a cross-platform database framework developed by WeChat.☆11,649Oct 8, 2026Updated 3 weeks ago
- A database migration tool. Supports SQL migrations and Go functions.☆11,655Updated this week
- An open source multi-tool for exploring and publishing data☆11,542Updated this week
- A simple Minecraft clone written in C using modern OpenGL (shaders).☆11,134Apr 3, 2024Updated 2 years ago
- q - Run SQL directly on delimited files and multi-file sqlite databases☆10,360Feb 6, 2026Updated 8 months ago
- A type-safe, Swift-language layer over SQLite3.☆10,185Oct 25, 2026Updated last week
- Universal command-line interface for SQL databases☆10,163Updated this week
- 🐚 A powerful relational ORM for Rust☆9,948Updated this week
- Python SQL Parser and Transpiler☆9,750Updated this week
- Doctrine Database Abstraction Layer☆9,699Updated this week