Top 12 TypeScript Mssql Projects
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
5. Backend & Database (Supabase + Prisma)
-
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!
-
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
-
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
-
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
-
-
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.
-
-
-
-
-
TypeScript Mssql discussion
TypeScript Mssql related posts
Index
What are some of the best open-source Mssql projects in TypeScript? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Prisma | 43,643 |
| 2 | Directus | 32,233 |
| 3 | Sequelize | 30,141 |
| 4 | beekeeper-studio | 20,344 |
| 5 | chartdb | 18,509 |
| 6 | kysely | 12,579 |
| 7 | sqlchat | 5,391 |
| 8 | vscode-sql-notebook | 139 |
| 9 | typetta | 115 |
| 10 | bellboy | 101 |
| 11 | nodeMyAdmin | 99 |
| 12 | knex-tree | 10 |
Sponsored