TypeScript SQL

Open-source TypeScript projects categorized as SQL
Edit details
Topics: TypeScript Postgresql Database NodeJS Postgres
The modern identity platform for B2B SaaS
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com
Sponsored

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.

    • 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

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

    • Project mention: How to Deploy Directus as a Backend-as-a-Service (BaaS) on Koyeb | dev.to | 2024-04-25

    Directus is an open data platform built to serve as a headless CMS, API, or Backend-as-a-Service (BaaS) for other applications. It is designed to make data accessible to people of all technical levels and to make it easy to build data-centric applications. Directus is extensible and can be integrated with many different frontend technologies to create stable, well-structured development and user experiences.

  • SurveyJS

    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.

    SurveyJS logo

  • 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: Get started with Drizzle ORM and Xata's Postgres service | dev.to | 2024-04-16

    Drizzle ORM is a very popular TypeScript ORM that provides type safe access to your database, automated migrations, and a custom data model definition.

  • beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    • Project mention: Using migrations with Golang | dev.to | 2024-04-17

    If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

  • kysely

    A type-safe typescript SQL query builder

    • Project mention: Show HN: Tsynamo – Type-friendly DynamoDB query builder for TypeScript | news.ycombinator.com | 2024-04-10

    Hello HN! I was recently introduced to Kysely (https://github.com/kysely-org/kysely), a type-safe Typescript SQL query builder, and instantly fell in love! I got inspired and wanted to make something similar for AWS DynamoDB.

    Thus, I developed Tsynamo! Instead of calling it type-safe, I decided to go with type-friendly, because the library is still in an early stage, and is not 100% type-safe.

    Under the hood, Tsynamo compiles the built queries into AWS SDK v3 commands. I feel that Tsynamo simplifies the AWS SDK API quite a lot since the developer doesn't have to mess around with condition/filter expressions or attribute names/values themselves, and as a bonus gets autocompletion for building the queries!

    There's also a playground to test it out in your browser: https://try.tsynamo.dev. It might not have the most up-to-date API of the library in use yet, but you can get the library's main idea from there.

    Since the project is still in its early stages, it doesn't yet have 100% support for all DynamoDB features, like querying indexes. The next steps will be increasing the support coverage and perhaps adding automatic type generation as inspired by kysely-codegen (https://github.com/RobinBlomberg/kysely-codegen).

    Would love to get some feedback, thanks in advance!

  • 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.

    • Project mention: azuredatastudio: NEW Data - star count:7321.0 | /r/algoprojects | 2023-12-10

  • 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: Rust GraphQL APIs for NodeJS Developers: Introduction | dev.to | 2024-02-08

    In my usual NodeJS tech stack, which includes GraphQL, NestJS, SQL (predominantly PostgreSQL with MikroORM), I encountered these limitations. To overcome them, I've developed a new stack utilizing Rust, which still offers some ease of development:

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo

  • 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: Storybook GPT | dev.to | 2023-05-08

    I started to see more and more applications that use the OpenAI API and I wanted to try it out. One of these apps is this one made by Kate.

  • sqlchat

    Chat-based SQL Client and Editor for the next decade

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

  • ts-sql

    A SQL database implemented purely in TypeScript type annotations.

    • Project mention: Type-Safe Printf() in TypeScript | news.ycombinator.com | 2024-03-24

    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

  • datastation

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

  • pgtyped

    pgTyped - Typesafe SQL in TypeScript

    • Project mention: Type-Safe Printf() in TypeScript | news.ycombinator.com | 2024-03-24

    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

  • quadratic

    Quadratic | Data Science Spreadsheet with Python & SQL

    • Project mention: Quadratic – Open-Source Spreadsheet Is Now Multiplayer | news.ycombinator.com | 2024-02-01

    https://github.com/quadratichq/quadratic/issues

  • vscode-database-client

    Database Client For Visual Studio Code

  • sql-formatter

    A whitespace formatter for different query languages (by sql-formatter-org)

  • 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-01

    Underlying DBLab Engine is FOSS (Apache 2.0), with API, CLI and UI https://github.com/postgres-ai/database-lab-engine

  • typeorm

    TypeORM module for Nest framework (node.js) 🍇 (by nestjs)

  • malloy

    Malloy is an experimental language for describing data relationships and transformations.

    • Project mention: Malloy: A language for describing data relationships and transformations | news.ycombinator.com | 2024-03-17

  • slashbase

    In-browser database IDE for dev/data workflows. Supports PostgreSQL & MongoDB.

    • Project mention: Generate and run SQL with GPT in Database Client (built with go - wails) | /r/golang | 2023-07-02

  • safeql

    Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.

    • Project mention: compile-time SQL validations and type generation in TypeScript & Node | /r/typescript | 2023-08-27

    Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?

  • node-pg-migrate

    Node.js database migration management for Postgresql

  • molecule

    :rocket: A lightweight Web IDE UI framework. (by DTStack)

  • surrealist

    Surrealist is the ultimate way to visually manage your SurrealDB database

    • Project mention: Thinking Inside The Box: Relational Style Joins in SurrealDB | dev.to | 2024-02-21

    If you want to follow along, you can go to https://surrealist.app/ → Create session → Click on sandbox → Type any name for namespace and database → Copy and paste the two queries below, which work both for SurrealDB and most relational DBs

  • InfluxDB

    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.

    InfluxDB logo
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 related posts

Index

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

Project Stars
1 Sequelize 29,045
2 Directus 25,357
3 drizzle-orm 19,510
4 beekeeper-studio 15,274
5 kysely 9,289
6 azuredatastudio 7,442
7 MikroORM 7,158
8 sql-translator 3,966
9 sqlchat 3,722
10 ts-sql 3,114
11 datastation 2,854
12 pgtyped 2,800
13 quadratic 2,711
14 vscode-database-client 2,349
15 sql-formatter 2,142
16 database-lab-engine 1,900
17 typeorm 1,830
18 malloy 1,822
19 slashbase 1,294
20 safeql 1,221
21 node-pg-migrate 1,215
22 molecule 840
23 surrealist 797

Sponsored
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.
www.influxdata.com