SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 TypeScript SQL Projects
-
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.
3. Sequelize
-
InfluxDB
Purpose built for real-time analytics at any scale. InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.
-
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 VS wabe - a user suggested alternative | libhunt.com/r/directus | 2024-09-08 -
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 😅
Project mention: drizzle-orm VS rado - a user suggested alternative | libhunt.com/r/drizzle-orm | 2024-08-09 -
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Project mention: Beekeeper Studio: Lightweight DataGrip Alternative | news.ycombinator.com | 2024-09-17I use Beekeeper and like it very much for a simple GUI that works with a number of sql databases.
It should be noted that the link here is a comparison page specifically for DataGrip. There are similar comparison pages for other tools. Or go to Beekeepers home page for an overview of the product.
https://www.beekeeperstudio.io
-
Surprised nobody has mentioned “Kysely” (https://kysely.dev).
It is a query builder (not an ORM), that (ab)-uses the Typescript type system to give you full type safety, intellisense, autocomplete etc.
Crucially it doesn’t require any build/compile step for your queries which is fantastic.
-
Project mention: SQLite on Rails: The how and why of optimal performance | news.ycombinator.com | 2024-09-11
I'm wondering how would it perform if we can compile https://pglite.dev/ as a native library and use it as an in-process Postgres... I know Node folks already use it as a Wasm module, so it shouldn’t be too tricky?
-
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.
Project mention: MikroORM: TypeScript ORM for Node.js Based on Data Mapper | news.ycombinator.com | 2024-07-18 -
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
azuredatastudio
Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
-
-
sql-translator
SQL Translator is a tool for converting natural language queries into SQL code using artificial intelligence. This project is 100% free and open source.
-
Project mention: Node.js adds experimental support for TypeScript | news.ycombinator.com | 2024-07-24
I don't use them directly much, but template literal generic and contidiontal types is probably the closest a mainstream language has inched towards dependent types.
Some examples of TypeScript power:
- SQL database in TypeScript types: https://github.com/codemix/ts-sql
- Statically typed raw SQL queries: https://github.com/andywer/squid?tab=readme-ov-file#tag-func...
- (Someone fill in your TS hackery for me)
-
There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql
There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped
To me the second approach seems much more pragmatic because you don’t need to run a SQL parser in a fairly potato interpreter on every build
-
chartdb
Free and Open-source database diagrams editor, visualize and design your DB with a single query.
Project mention: ChartDB – Free and open source, database design editor | news.ycombinator.com | 2024-08-27 -
Project mention: Quadratic – Open-Source Spreadsheet Is Now Multiplayer | news.ycombinator.com | 2024-02-01
https://github.com/quadratichq/quadratic/issues
-
-
-
-
database-lab-engine
DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.
Project mention: Pg_branch: Pre-alpha Postgres extension brings Neon-like branching | news.ycombinator.com | 2023-10-01Underlying DBLab Engine is FOSS (Apache 2.0), with API, CLI and UI https://github.com/postgres-ai/database-lab-engine
-
Project mention: Codd almighty! Has it been half a century of SQL already? | news.ycombinator.com | 2024-06-04
> SQL is great at expressing simple needs very well, but in more advanced cases, it can get "mind-twistingly complicated" even for a mathematically included brain.
I have found Malloy[1] to be easier to read and write, even for really complex queries. Malloy complies to SQL. As an example check out [2].
Malloy can query .csv files directly (enabled by duckdb). You can also join .csv files. This makes getting started a breeze for beginners, and is a boon for data scientists. Much easier than Pandas in many cases.
With the visualization capabilities it has built in, Malloy sort-of competes with Tableau and PowerBI.
Most people only write SQL to get data out of databases, for these people, Malloy is an interesting tool to consider.
[1] https://www.malloydata.dev/
-
-
Project mention: Show HN: Text-to-SQL Focus on Semantics and UI/UX | news.ycombinator.com | 2024-05-08
-
-
-
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 SQL discussion
TypeScript SQL related posts
-
Surrealist 3.0 is now available!
-
Beekeeper Studio: Lightweight DataGrip Alternative
-
Surrealist 3.0 beta
-
drizzle-orm VS rado - a user suggested alternative
2 projects | 9 Aug 2024 -
rado VS drizzle-orm - a user suggested alternative
2 projects | 9 Aug 2024 -
Good Practices Using Node.js + Sequelize with TypeScript
-
Node.js adds experimental support for TypeScript
-
A note from our sponsor - SaaSHub
www.saashub.com | 19 Sep 2024
Index
What are some of the best open-source SQL projects in TypeScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Sequelize | 29,428 |
| 2 | Directus | 27,127 |
| 3 | drizzle-orm | 23,134 |
| 4 | beekeeper-studio | 16,156 |
| 5 | kysely | 10,357 |
| 6 | pglite | 7,939 |
| 7 | MikroORM | 7,616 |
| 8 | azuredatastudio | 7,539 |
| 9 | sqlchat | 4,491 |
| 10 | sql-translator | 4,166 |
| 11 | ts-sql | 3,156 |
| 12 | pgtyped | 2,923 |
| 13 | chartdb | 2,921 |
| 14 | quadratic | 2,917 |
| 15 | datastation | 2,891 |
| 16 | vscode-database-client | 2,444 |
| 17 | sql-formatter | 2,304 |
| 18 | database-lab-engine | 2,088 |
| 19 | malloy | 1,953 |
| 20 | typeorm | 1,905 |
| 21 | WrenAI | 1,700 |
| 22 | safeql | 1,326 |
| 23 | node-pg-migrate | 1,273 |
Sponsored
Purpose built for real-time analytics at any scale.
InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.
www.influxdata.com