TypeScript SQL

Open-source TypeScript projects categorized as SQL

Top 23 TypeScript SQL Projects

  • 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: Building a User Feedback Widget with Vue.js and Directus | dev.to | 2023-09-21

    One of our DevRel initiatives at Directus is constantly improving our documentation. As a small team with finite time and resources, we rely a lot on user feedback to help guide our writing efforts. But we were missing the most important bit there – your feedback.

  • drizzle-orm

    TypeScript ORM that feels like writing SQL.

    Project mention: Database Review: Top Five Missing Features from Database APIs | dev.to | 2023-09-14

    Drizzle ORM

  • Appwrite

    Appwrite - The open-source backend cloud platform. The open-source backend cloud platform for developing Web, Mobile, and Flutter applications. You can set up your backend faster with real-time APIs for authentication, databases, file storage, cloud functions, and much more!

  • kysely

    A type-safe typescript SQL query builder

    Project mention: Database Review: Top Five Missing Features from Database APIs | dev.to | 2023-09-14


  • 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:7203.0 | /r/algoprojects | 2023-08-16
  • 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: The Epic Stack by Kent C. Dodds | news.ycombinator.com | 2023-05-12

    It also does code generation into its own module, so good luck with hoisting in a monorepo where you want multiple independent prisma schemas. MikroORM[1] is a much better alternative to Prisma in my opinion but any ORM carries some form of baggage.

    [1] https://mikro-orm.io/

  • sqlchat

    Chat-based SQL Client and Editor for the next decade

    Project mention: 👻Top 8 Free, Open Source SQL Clients🔥 | dev.to | 2023-09-04

    SQL Chat is a young player, prompting SQL clients from the traditional GUI-based to the Chat-based stage: it's powered by ChatGPT to write and polish SQL for you.

  • ts-sql

    A SQL database implemented purely in TypeScript type annotations.

    Project mention: Functions and algorithms implemented purely with TypeScript's type system | news.ycombinator.com | 2023-07-04
  • SurveyJS

    A Non-Cloud Alternative to Google Forms that has it all.. SurveyJS JavaScript libraries allow you to easily set up a robust form management system fully integrated into your IT infrastructure where users can create and edit multiple dynamic JSON-based forms in a no-code form builder. Learn more now.

  • datastation

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

    Project mention: Code coverage for Go integration tests | news.ycombinator.com | 2023-03-08

    There was a technique that existed already where you could use `go test -cover` and the `-o` flag to produce a binary from `go test` rather than actually running tests. So you could build a binary that had coverage enabled. Then when you ran

    Here's an example: https://github.com/multiprocessio/datastation/blob/main/runn....

    I can't remember where I found this technique but it's been around for a while.

    This new option is the same thing but a way to `go build` with `-cover` instead of `go test -cover -o $out`? Do I have that right?

  • quadratic

    Quadratic | Data Science Spreadsheet with Python & SQL

    Project mention: suggestions for a free spreadsheet library (like excel or google spreadsheets) | /r/reactjs | 2023-07-01

    Hey guys, as the title says I am looking for some suggestions on useful free spreadsheet libraries, similar to excel or google sheets. I saw quadratic (https://github.com/quadratichq/quadratic), which looks really interesting but is in very early alpha, to the point I cant even embed it in my own project yet.

  • 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: Want to avoid MySQL but find PlanetScale really appealing | /r/PostgreSQL | 2023-03-25

    That said, there are a few folks out there attempting it. As mentioned, Neon attempts branching but has no "merge". Postgres.ai has "thin clones" for similar migration testing but again, no "merge".

  • typeorm

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

  • 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
  • node-pg-migrate

    Node.js database migration management for Postgresql

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

  • lucid

    AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more (by adonisjs)

  • molecule

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

  • sql-language-server

    SQL Language Server

    Project mention: SQL LSP dialect | /r/neovim | 2023-08-04

    I'm struggling to get [sqlls](https://github.com/joe-re/sql-language-server) with [nvim-lspconfig](https://github.com/neovim/nvim-lspconfig) to use Postgres syntax.

  • iasql

    Cloud Infrastructure as data in PostgreSQL

    Project mention: Save $ on public S3 buckets using VPC endpoints via SQL | dev.to | 2023-03-23

    When the VPC endpoints are enabled you can access your S3 buckets using this endpoint. In this post, we will walk you through how to control your buckets from an internal network with the desired security, and without the extra costs of a NAT gateway using a VPC endpoint and IaSQL. IaSQL is an open-source software tool that creates a two-way connection between an unmodified PostgreSQL database and an AWS account so you can manage your infrastructure from a database.

  • @databases

    TypeScript clients for databases that prevent SQL Injection

    Project mention: Node Core Dev Starter Kit | dev.to | 2022-10-21

    At Databases because you don't need ORM.

  • vulcan-sql

    Open-source Analytical Data API Framework for data apps. It turns SQL queries into RESTful APIs in no time!

    Project mention: Shout out to Appsmith developers to check out this new tool! | /r/lowcode | 2023-07-09

    I am one of the members of an open-source project VulcanSQL, a Data API Framework for data applications that helps data folks create and share data APIs faster.

  • Surrealist

    ⚡ Powerful graphical SurrealDB query playground and database explorer for Browser and Desktop

    Project mention: How to Design a SurrealDB schema and create a basic client for TypeScript | dev.to | 2023-09-17

    When it comes to working with SurrealDB, there's one tool that I wholeheartedly recommend: Surrealist. This software is a game-changer for simplifying your SurrealDB experience.

  • Amplication

    Amplication: open-source Node.js backend code generator. An open-source platform that helps developers build backends without spending time on boilerplate & repetitive coding. Including production-ready GraphQL & REST APIs, DB schema, DTOs, filtering, pagination, RBAC, & more.

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-09-21.

TypeScript SQL related posts


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

Project Stars
1 Directus 23,214
2 drizzle-orm 13,375
3 kysely 7,362
4 azuredatastudio 7,241
5 MikroORM 6,474
6 sqlchat 3,082
7 ts-sql 2,912
8 datastation 2,804
9 quadratic 2,325
10 vscode-database-client 2,208
11 sql-formatter 1,751
12 database-lab-engine 1,727
13 typeorm 1,696
14 slashbase 1,195
15 node-pg-migrate 1,183
16 safeql 1,084
17 lucid 899
18 molecule 756
19 sql-language-server 564
20 iasql 560
21 @databases 551
22 vulcan-sql 486
23 Surrealist 471
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.