TypeScript Database

Open-source TypeScript projects categorized as Database

Top 23 TypeScript Database Projects

  • TypeORM

    ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    Project mention: Help with my small Edtech startup. | reddit.com/r/nextjs | 2023-01-05
  • Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

    Project mention: Startchart: Prisma Schema | dev.to | 2023-02-03

    This week, I focus on creating an initial schema for the project through using Prisma. This is for a MySQL database, and the PR for the initial schema is here.

  • Appwrite

    Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  • Directus

    The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

    Project mention: Looking for a stupid simple CMS solution for static pages! | reddit.com/r/Frontend | 2023-01-31

    I prefer https://directus.io/ because Strapi STILL cannot re-order collections.

  • RxDB

    A fast, offline-first, reactive database for JavaScript Applications

    Project mention: Sveltekit SPA Mode: Prevent serverside code | reddit.com/r/sveltejs | 2022-11-14

    I am using rxdb which internally uses some folder imports like import x from './folder' as opposed to import x from './folder/index.js which is big nono inside node.js environments.

  • Redis

    🚀 A robust, performance-focused, and full-featured Redis client for Node.js.

    Project mention: Help implementing Heroku Data For Redis (+bull & throng) / `ioredis` | reddit.com/r/Heroku | 2022-11-25

    In order to try and mitigate the OOMs. I read the Background Jobs in Node.JS with Redis blog post and implemented Heroku Data For Redis with ioredis, BullMQ and Throng,

  • MongoDB

    The Official MongoDB Node.js Driver

    Project mention: How does one set up MongoDB using "vanilla" JS? | reddit.com/r/mongodb | 2022-08-19

    The MongoDB JavaScript driver uses and requires node.js, which is what 99.9% of server-side JavaScript implementations use.

  • nhost

    The Open Source Firebase Alternative with GraphQL.

    Project mention: Is there smth like firebase on-prem? | reddit.com/r/Firebase | 2023-01-25

    You can use Nhost (100% open source): https://github.com/nhost/nhost/tree/main/examples/docker-compose

  • Sonar

    Write Clean JavaScript Code. Always.. Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • MikroORM

    TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

    Project mention: RFC: Remove `persist`/`flush` from repository level in MikroORM v6 | reddit.com/r/node | 2023-01-31
  • altair

    ✨⚡️ A beautiful feature-rich GraphQL Client for all platforms. (by altair-graphql)

    Project mention: Public Angular Project | reddit.com/r/angular | 2022-05-08

    However, it's not an Angular app, if you are looking for an app instead of library, you can check Altair app: https://github.com/altair-graphql/altair/tree/master/packages/altair-app or angular sptify, https://github.com/trungk18/angular-spotify/tree/main/libs/web (Uses NX monorepos to maintain the libraries)

  • slonik

    A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

    Project mention: Kysely: TypeScript SQL Query Builder | news.ycombinator.com | 2023-01-24

    I think this is a really cool project, but for most use cases (not all, but most) I strongly believe query builders are an anti-pattern. I could go over the reasons, but when I saw this blog post, https://gajus.medium.com/stop-using-knex-js-and-earn-30-bf41..., from the author of slonik years ago I had a eureka moment, and it explains the reasoning better than I could.

    Template strings in TypeScript allow you to safely write SQL directly, still with type checking: https://github.com/gajus/slonik#readme

  • grist-core

    Grist is the evolution of spreadsheets.

    Project mention: irelia VS grist-core - a user suggested alternative | libhunt.com/r/irelia | 2023-02-03

    Irelia is an unauthorized clone of Grist. https://twitter.com/fitzyfitzyfitzy/status/1563273434612002817

  • kysely

    A type-safe typescript SQL query builder

    Project mention: Announcing a new TypeScript ORM | reddit.com/r/typescript | 2023-02-04

    prisma (mentioned in the article), zapatos, pgtyped and kysely are the most popular currently I think.

  • vuefire

    🔥 Firebase bindings for Vue.js

    Project mention: VueFire CRUD | Vue 3 | Firebase Auth | dev.to | 2023-01-19

    We will use VueFire that exposes some helpful composables to easily achieve things like authentication and real-time data sync.

  • express-typescript-boilerplate

    A delightful way to building a RESTful API with NodeJs & TypeScript by @w3tecch

  • sequelize-auto

    Automatically generate bare sequelize models from your database.

  • datastation

    App to easily query, script, and visualize data from every database, file, and API.

    Project mention: Engineers using dbt with VS Code - how are you previewing your results in lieu of the functionality provided by dbt cloud? | reddit.com/r/dataengineering | 2022-06-29

    If my employer doesn't consider paying for dbt cloud, I will use u/eatonphil 's datastation, run the queries on a dev database then put them in dbt.

  • tad

    A desktop application for viewing and analyzing tabular data

    Project mention: Consider Using CSV | news.ycombinator.com | 2022-12-10

    Since this is about CSV, this is obligatory tool for larger ones:

    * https://github.com/antonycourtney/tad

  • cloudbeaver

    Cloud Database Manager

    Project mention: WAL Mode in LiteFS | news.ycombinator.com | 2023-01-04

    Hi, author of litexplore here!

    I agree remote management is the "least convenient" aspect of SQLite. If you have control over the remote VM where the DB is hosted, you can also run something like ClouDBeaver[0], Datasette[1] or sqlite-web[2] as a Docker container, then connect to it from your laptop.

    The reason I wrote litexplore was that those approaches require exposing extra ports, managing authentication, etc. With litexplore, you just need the sqlite3 CLI (compiled with the JSON1 extension) installed in the VM and a way to access it over SSH.

    litexplore is still in early stages and I have some updates planned in the following 2 months, but the basics are working.

    [0]: https://github.com/dbeaver/cloudbeaver

  • denodb

    MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno

    Project mention: MariaDB API Recomendations | reddit.com/r/Deno | 2022-09-29

    denoDB? https://github.com/eveningkid/denodb

  • ElectroCRUD

    Database CRUD Application Built on Electron | MySQL, Postgres, SQLite

    Project mention: After few years, ElectroCRUD is coming back | reddit.com/r/opensource | 2023-01-19

    development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop

  • Systemizer

    A system design tool that allows you to simulate data flow of distributed systems.

  • pg-mem

    An in memory postgres DB instance for your unit tests

    Project mention: Ask HN: How do you test SQL? | news.ycombinator.com | 2023-01-31

    I was wondering the other day how to classify tests that use a test double like pg-mem, which isn't a mock but isn't the Dockerized test DB either :

    https://github.com/oguimbal/pg-mem

  • layr

    Dramatically simplify full‑stack development

    Project mention: Layr v2 Is Out, but You May Never Use It | dev.to | 2023-01-12

    Finally, after two years of hard work, Layr v2 is out.

  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

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). The latest post mention was on 2023-02-04.

TypeScript Database related posts

Index

What are some of the best open-source Database projects in TypeScript? This list will help you:

Project Stars
1 TypeORM 30,280
2 Prisma 28,710
3 Directus 19,569
4 RxDB 18,717
5 Redis 11,669
6 MongoDB 9,661
7 nhost 5,958
8 MikroORM 5,547
9 altair 4,580
10 slonik 3,627
11 grist-core 3,606
12 kysely 3,526
13 vuefire 3,466
14 express-typescript-boilerplate 2,839
15 sequelize-auto 2,730
16 datastation 2,660
17 tad 2,584
18 cloudbeaver 2,020
19 denodb 1,860
20 ElectroCRUD 1,442
21 Systemizer 1,278
22 pg-mem 1,216
23 layr 1,214
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
www.influxdata.com