SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Sqlite Open-Source Projects
-
NocoDB is an open-source Airtable alternative — a spreadsheet interface on top of a database. Some teams use it as a lightweight CRM, particularly in earlier stages when "CRM" mostly means "a shared table of contacts with some metadata."
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
memos
Open-source, self-hosted note-taking tool built for quick capture. Markdown-native, lightweight, and fully yours.
ObjeX currently serves as the S3 backend for our Outline and Memos instances. Both use presigned URLs and server-side uploads through the standard AWS SDKs, no special configuration needed.
-
Project mention: CLI to manage your SQL database schemas and migrations | news.ycombinator.com | 2025-11-01
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Project mention: We ran Pinaka on an open, unresolved Prisma bug. No ground truth. Here's what it found. | dev.to | 2026-07-06Prisma issue #29480 is open. It has persisted through four minor releases — 7.5.0, 7.6.0, 7.7.0, 7.8.0 — unresolved as of the time we ran this benchmark. There is no merged fix to score against. So we had to validate Pinaka's diagnosis differently: against behavioral evidence in the codebase itself, not a known-correct answer. That's a different kind of benchmark, and it's worth being precise about what it does and doesn't prove.
-
Project mention: Ask HN: What Are You Working On? (September 2025) | news.ycombinator.com | 2025-09-29
-
TypeORM
TypeScript & JavaScript ORM for Node.js — supports PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, and more.
TypeORM - TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native
-
Directus
The flexible backend for all your projects 🐰 Turn your DB into a headless CMS, admin panels, or apps with a custom UI, instant APIs, auth & more.
Project mention: Self-hosted Directus 12 requires a license key to lift caps | news.ycombinator.com | 2026-06-17 -
Project mention: Flat Chat Threads Suck for Reading Books. So I Built a Local-First AI Tree Companion. | dev.to | 2026-06-08
Built on the Pi SDK for tree-structured agent conversations, Hono for a lightweight server (Electron-friendly), and SQLite with Drizzle ORM for metadata.
-
Sequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB, DB2 and DB2 for IBM i.
Sequelize - promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server
-
codebase-memory-mcp
High-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 languages, sub-ms queries, 99% fewer tokens. Single static binary, zero dependencies.
Project mention: Stop Making Your AI Coding Agent Grep Your Whole Repo — Try codebase-memory-mcp | dev.to | 2026-06-20codebase-memory-mcp is an open-source MCP server built to fix exactly that. It indexes your codebase into a persistent knowledge graph — functions, classes, call chains, HTTP routes, cross-service links — and lets your agent ask structural questions directly instead of reading its way through the filesystem.
-
sqlitebrowser
Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
-
RxDB
The local-first database that runs on every JS runtime and replicates with your existing backend - no vendor, no lock-in - https://rxdb.info/
I’m doing offline-first apps at work and want to emphasize that you’re constraining yourself a lot trying to do this.
As mentioned, everything fast(ish) is using SQLite under the hood. If you don’t already know, SQLite has a limited set of types, and some funky defaults. How are you going to take this loosey-goosey typed data and store it in a backend database when you sync? What about foreign key constraints, etc., can you live without those? Some of the sync solutions don’t support enforcing them on the client.
Also, the SQLite query planner isn’t great in my experience, even when you’re only joining on ids/indexes.
Document databases seem more friendly/natural, but as mentioned indexeddb is slow.
I wish this looked at https://rxdb.info/ more. They have some posts that lead me to believe they have a good grasp on the issues in this space at least
-
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Beekeeper Studio is a modern SQL editor and database manager with an open-source community edition. It supports many databases, including MySQL, PostgreSQL, SQLite, SQL Server, ClickHouse, DuckDB, MariaDB, Oracle, Redis, Redshift, Trino, and more.
-
chartdb
Database diagrams editor that allows you to visualize and design your DB with a single query.
Project mention: Show HN: Clawe – open-source Trello for agent teams | news.ycombinator.com | 2026-02-10the limits of a no-code website editor https://chartdb.io/ that's hilarious
-
-
The CLI generates migration files; applying them is up to your usual tool. With golang-migrate:
-
Project mention: Show HN: Bun-sqlgen – Type-safe raw SQL for Bun, no ORM | news.ycombinator.com | 2026-06-23
-
rqlite
The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort.
Project mention: Show HN: rqlite – the fault-tolerant DB built on SQLite – v10.0 released | news.ycombinator.com | 2026-04-27https://rqlite.io
Major new release which improves clustering robustness, especially when dealing with slow Followers. New features include a built in web-based console (at localhost:4001/console) and comprehensive use of CRC32 for even strong data integrity guarantees. Lots of other bug fixes and improvements under the covers.
Full list of changes at at https://github.com/rqlite/rqlite/blob/master/CHANGELOG.md
-
sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by transact-rs)
Project mention: What ORMs have taught me: just learn SQL (2014) | news.ycombinator.com | 2026-07-04If you use Rust and like to write SQL, check out SQLx: https://github.com/transact-rs/sqlx
Or diesel-rs for ORM
-
Project mention: IndexNow, libSQL, and three other tools I reached for this week | dev.to | 2026-05-09
libSQL is a fork of SQLite with an HTTP API, replication, and edge-friendly semantics. Turso wraps it in a managed service; the free tier handles my current scale without expiring on inactivity.
-
-
Project mention: Optimistic concurrency is the whole design: event sourcing on Aurora DSQL | dev.to | 2026-06-14
TypeScript end to end. Kysely as a typed query builder rather than an ORM, because I wanted type safety without surrendering control of the SQL: on a distributed database the exact shape of a query has real consequences, and I did not want a query planner I could not see. Next.js App Router on Vercel for the front end and the server-side data access. DSQL as the database, reached over IAM using Vercel's OIDC federation to AWS, so there are no static database credentials anywhere in the system.
-
Project mention: SQLite Backup Strategy for Production SaaS: WAL, Litestream, Recovery Tests | dev.to | 2026-06-15
Litestream is a small Go binary that watches a SQLite WAL file and streams its contents to a remote target (S3, B2, GCS, SFTP). It's the closest thing SQLite has to write-ahead replication.
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Sqlite discussion
Sqlite related posts
-
Qlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)
-
You Probably Don't Need a Vector Database for RAG
-
What ORMs have taught me: just learn SQL (2014)
-
Letos: Create, edit, browse SQLite databases. Formerly known as SQLiteStudio
-
DuckDB SQLite Extension
-
Show HN: Bun-sqlgen – Type-safe raw SQL for Bun, no ORM
-
Show HN: WhatsKept – Searchable,agent-queryable WhatsApp history from iOS backup
-
A note from our sponsor - SaaSHub
www.saashub.com | 11 Jul 2026
Index
What are some of the best open-source Sqlite projects? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | nocodb | 63,732 |
| 2 | memos | 61,455 |
| 3 | dbeaver | 50,835 |
| 4 | Prisma | 46,816 |
| 5 | drawdb | 37,981 |
| 6 | TypeORM | 36,577 |
| 7 | Directus | 36,440 |
| 8 | drizzle-orm | 35,028 |
| 9 | Sequelize | 30,363 |
| 10 | codebase-memory-mcp | 29,404 |
| 11 | sqlitebrowser | 24,298 |
| 12 | RxDB | 23,246 |
| 13 | beekeeper-studio | 23,194 |
| 14 | chartdb | 22,560 |
| 15 | teable | 21,454 |
| 16 | migrate | 18,700 |
| 17 | sqlc | 17,973 |
| 18 | rqlite | 17,617 |
| 19 | sqlx | 17,259 |
| 20 | libsql | 16,929 |
| 21 | diesel | 14,105 |
| 22 | kysely | 14,024 |
| 23 | litestream | 13,906 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com