Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more! Learn more →
Top 23 TypeScript Sqlite Projects
-
Project mention: A FREE and Open Source Airtable Alternative - How to Spin Up NocoDB Using Docker | dev.to | 2025-07-23
NocoDB is an open-source Airtable alternative. On their site they claim that it "allows building no-code database solutions with ease of spreadsheets." You can turn any database into a smart spreadsheet interface, create forms, build APIs, and collaborate with your team.
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
5. Backend & Database (Supabase + Prisma)
-
TypeORM
ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
TypeORM - ⚠️ o'rtacha, cli tool bor lekin unchalik aniq migration querylar generate qilib bermaydi va asosan buggy
-
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: Directus.js (JavaScript SDK) – The official client for Directus APIs | dev.to | 2025-06-11If you're working with Directus, the open-source headless CMS and data platform, then Directus.js is your new best friend.
-
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 (v6), DB2 and DB2 for IBM i.
Sequelize
-
drizzle-orm
Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
Drizzle ORM - next gen TypeScript ORM.
-
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
-
Sevalla
Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
-
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
-
Project mention: Is Airtable Too Expensive? 5 Self-Hosted Alternatives Compared by Cost & Features | dev.to | 2025-06-29
-
chartdb
Database diagrams editor that allows you to visualize and design your DB with a single query.
Project mention: drawdb VS chartdb - a user suggested alternative | libhunt.com/r/drawdb | 2025-07-12Free, open-source tool to generate database diagrams from a single SQL query. Supports PostgreSQL, MySQL, SQLite, ClickHouse, and more. Runs in-browser or self-hosted. No data ever leaves your machine. 🔗 https://chartdb.io
-
The way my company uses Clickhouse is basically that we have one giant flat table, and have written our own abstraction layer on top of it based around "entities" which are functions of data in the underlying table, potentially adding in some window functions or joins against s3 or postgres depending on the entity being queried. Pretty much every query we write with Clickhouse tacks on a big "Group By All" at the end of it, because we are always trying to squash down the number of rows and aggregate as aggressively as possible.
I imagine we're not alone in this type of abstraction layer, and some type-safety would be very welcome there. I tried to build our system on top of Kysely (https://kysely.dev/) but the Clickhouse extension was not far along enough to make sense for our use-case. As such, we basically had to build our own parser that compiles down to sql, but there are many type-error edge cases, especially when we're joining in against data from S3 that could be CSV, Parquet, etc.
Side note: One of the things I love most about Clickhouse is how easy it is to combine data from multiple sources other than just the source database at query time. I imagine this makes the problem of building an ORM much harder as well, since you could need to build type-checking / ORM against sql queries to external databases, rather than to the source table itself
-
-
MikroORM
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
MikroORM
-
-
studio
A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.
Project mention: Mathesar – An intuitive spreadsheet-like interface on Postgres | news.ycombinator.com | 2025-01-29Hi I'm one of the founders of Outerbase, just want to clarify a few things, seems like you might have some wrong information on Outerbase.
Big fan of Mathesar by the way!
1. We have a incredibly powerful CRUD editor on our table, in fact you can drag and drop and select multiple columns & rows, I haven't seen many other DB editors support this.
2. We allow you to pick foreign key constraints from a dropdown as well.
3. This is true.
4. Outerbase is open-source with more and more features heading into our core offering there. https://github.com/outerbase/studio
-
Project mention: supabase VS Manifest - a user suggested alternative | libhunt.com/r/supabase | 2025-07-01
Manifest is an open source backend as service and alternative to Supabase: https://dev.to/bd_perez/supabase-alternative-for-ai-code-editors-cursor-bolt-lovable-2d16
-
Keyv - Simple key-value storage with support for multiple backends
-
livestore
LiveStore is a next-generation state management framework based on reactive SQLite and built-in sync engine.
Great questions!
> Handling compaction for long lived apps/pages?
That's a very common question and something I'm planning to ship a solution for soon. The basic idea is to give each event some more semantic "meaning" by annotating the event definition which allows you to express which events "semantically overlap". For example in a todo app you could express that the "todoCompleted" event for a given task id can compact other "todoCompleted" / "todoUncompleted" events for the same task id.
You can track the progress of this topic here: https://github.com/livestorejs/livestore/issues/254
> IMO events are nice, but also require discipline and good design w.r.t code
Yes, I agree with that. When it comes to data there is "no free lunch" - it's all about tradeoffs. I prefer the tradeoffs of event sourcing though for my own use cases such as Overtone.
That being said for many situations (like older client versions etc) there are pretty straightforward ways to address those concerns. Always depends on your application use case and possible tradeoffs though.
> Overtone looks sick. I've been using Spotify less and less because of janky UI and constant UI changes, would love a replacement. I see that it supports multiple sources, will it offer offline playback?
Very excited to hear! I'm sharing your frustrations which is why I'm building Overtone (next to many other reasons). Re "offline playback": That will depend on where your music is coming from. e.g. for your own music collection in Dropbox (or similar) it will be supported. For music streaming services like Spotify it will depend on their terms.
Hope that all makes sense?
-
triplit
A full-stack, syncing database that runs on both server and client. Pluggable storage (indexeddb, sqlite, durable objects), syncs over websockets, and works with your favorite framework (React, Solid, Vue, Svelte).
-
-
-
-
Project mention: SQLite-on-the-Server Is Misunderstood: Better at Hyper-Scale Than Micro-Scale | news.ycombinator.com | 2025-03-03
The folks over at StarbaseDB (https://starbasedb.com/) are working on building tools for shareded SQLite.
From the companies I've talked to, most developers using this architecture are building quick scripts to do this in-house. Both Turso and Durable Objects SQLite already a surprising amount of usage that people don't talk about much publicly yet, so I suspect some of this tooling will start to be published in the next year.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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).
TypeScript Sqlite discussion
TypeScript Sqlite related posts
-
Offline-First Landscape – 2025
-
Kysely – The type-safe SQL query builder for TypeScript
-
Why Elixir? A Rebuttal to Common Misconceptions
-
Show HN: SnapQL – Desktop app to query Postgres with AI (local, open source)
-
Kysely: The type-safe SQL query builder for TypeScript
-
Replacing Prisma Accelerate with Redis and Twemproxy
-
Choice of ORM for your Next NodeJS Project: Prisma or TypeORM
-
A note from our sponsor - Sevalla
sevalla.com | 1 Sep 2025
Index
What are some of the best open-source Sqlite projects in TypeScript? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | nocodb | 56,680 |
| 2 | Prisma | 43,582 |
| 3 | TypeORM | 35,726 |
| 4 | Directus | 32,180 |
| 5 | Sequelize | 30,141 |
| 6 | drizzle-orm | 30,019 |
| 7 | RxDB | 22,608 |
| 8 | beekeeper-studio | 20,344 |
| 9 | teable | 19,315 |
| 10 | chartdb | 18,509 |
| 11 | kysely | 12,579 |
| 12 | noodle | 12,396 |
| 13 | MikroORM | 8,471 |
| 14 | sqlchat | 5,391 |
| 15 | studio | 4,898 |
| 16 | Manifest | 3,023 |
| 17 | Keyv | 2,970 |
| 18 | livestore | 2,893 |
| 19 | triplit | 2,876 |
| 20 | eidos | 2,801 |
| 21 | denodb | 1,927 |
| 22 | evolu | 1,702 |
| 23 | starbasedb | 1,088 |
Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com