Top 10 TypeScript Mssql Projects

Prisma

447 37,856 9.9 TypeScript

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

Project mention: Seeking a Type-Safe Ruby on Rails in TypeScript, I Started Developing an ORM | dev.to | 2024-06-11

For example, the increasingly popular Prisma has high type safety but adopts the Table Gateway pattern. The closest fit was TypeORM, which uses the Active Record pattern, but its type support is weaker compared to recent ORMs, and its release frequency has been low recently.

SurveyJS

surveyjs.io featured

Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
Sequelize

89 29,180 9.9 TypeScript

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.

Project mention: Full Stack Web Development Concept map | dev.to | 2024-03-23

Sequelize - modern Typescript and NodeJS ORM for Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server+docs

Directus

210 26,261 9.9 TypeScript

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

Project mention: Twenty, a modern CRM alternative to Salesforce | news.ycombinator.com | 2024-06-11

Nice! It's great to have more open source platforms in the CRM space.
This feels a lot like Directus [0] except that the latter is a more general data platform you build upon. They have a 100 Apps in 100 hours playlist where they build sample apps on top on Directus, even a simple CRM [1].
[0] https://directus.io/
[1] https://youtu.be/tTrBn9Wvko0?si=IoqQ7o7Y8czfxB31

kysely

27 9,644 9.1 TypeScript

A type-safe typescript SQL query builder

Project mention: Swift sucks at web serving or does it? | news.ycombinator.com | 2024-05-15

The most interesting JS DB lib I came across was https://github.com/kysely-org/kysely but still didn't feel as good as EF Core.

sqlchat

6 4,020 8.0 TypeScript

Chat-based SQL Client and Editor for the next decade

Project mention: FLaNK Stack Weekly 12 February 2024 | dev.to | 2024-02-12

vscode-sql-notebook

3 120 4.9 TypeScript

Open SQL files as VSCode Notebooks.
typetta

13 100 7.4 TypeScript

Node.js ORM written in TypeScript for type lovers.
InfluxDB

www.influxdata.com featured

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
bellboy

3 93 6.7 TypeScript

Highly performant JavaScript data stream ETL engine.
nodeMyAdmin

2 89 10.0 TypeScript

A replace phpMyAdmin to Node.js with the help of Sveltekit
knex-tree

2 10 0.0 TypeScript

Query hierarchical data structures in sql with knex

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 Mssql discussion

Index

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

	Project	Stars
1	Prisma	37,856
2	Sequelize	29,180
3	Directus	26,261
4	kysely	9,644
5	sqlchat	4,020
6	vscode-sql-notebook	120
7	typetta	100
8	bellboy	93
9	nodeMyAdmin	89
10	knex-tree	10