TypeScript SQL

Open-source TypeScript projects categorized as SQL Edit details

Top 23 TypeScript SQL Projects

  • azuredatastudio

    Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

    Project mention: Show HN: If VS Code had a data-centric IDE sibling, what would that look like? | news.ycombinator.com | 2022-07-18

    I think there isn't, and if there is it would be illegal:

    > You may not sublicense the Software Code or any use of it

    https://github.com/microsoft/azuredatastudio/blob/main/LICEN...

  • ts-sql

    A SQL database implemented purely in TypeScript type annotations.

    Project mention: HypeScript: Simplified TypeScript's type system in TypeScript's own type system | news.ycombinator.com | 2022-07-27

    Which allows for things like this type that implements a simplified SQL query parser checked against a provided 'database' object:

    https://github.com/codemix/ts-sql

    This project was my go-to "nifty but pointless" example for TS string literal types before this article :)

  • Appwrite

    Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  • datastation

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

    Project mention: Engineers using dbt with VS Code - how are you previewing your results in lieu of the functionality provided by dbt cloud? | reddit.com/r/dataengineering | 2022-06-29

    If my employer doesn't consider paying for dbt cloud, I will use u/eatonphil 's datastation, run the queries on a dev database then put them in dbt.

  • vscode-database-client

    Database Client For Visual Studio Code

    Project mention: DB Plugin | reddit.com/r/vscode | 2022-06-12

    https://github.com/cweijan/vscode-database-client Have a look at this one, looks nice.

  • ElectroCRUD

    Database CRUD Application Built on Electron | MySQL, Postgres, SQLite

  • typeorm

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

  • kysely

    A type-safe typescript SQL query builder

    Project mention: What is a clean way to build SQL queries to handle filters? | reddit.com/r/node | 2022-08-09

    In fact, here's a prime example of that exact scenario for this exact situation: kysely. Kysely is a query builder much like knex that is being developed by Koskimas, the core maintainer of Objection.js. He's building kysely with an API inspired by knex but as a typescript-first solution. Knex is really a js solution so Kysely is able to leverage typescript more completely from the ground up to build out an even better experience for typescript based projects in ways that would never make sense for knex to do.

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • sql-formatter

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

    Project mention: Would love your feedback on this tutorial I wrote: Learn SQL with Datasette | reddit.com/r/SQL | 2022-02-28

    To be honest I didn't put much thought into the formatting at all - I went with the defaults for the https://github.com/zeroturnaround/sql-formatter library, which is what runs when you click the "Format SQL" button on this page.

  • node-pg-migrate

    Node.js database migration management for Postgresql

    Project mention: Fully featured Repository Pattern with Typescript and native PostgreSQL driver | dev.to | 2022-03-20

    Why PG? For the clarity of the article to a large circle of developers, the entire explanation will be built by PostgreSQL and PG package. And in a real project, the database schema will change over time, and in order to be able to perform migrations, we will use Node PG migrate.

  • lucid

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

    Project mention: Moving MyUnisoft Node.js back to TypeORM | dev.to | 2022-08-02

    When I started this project I was inspired by Lucid which is the ORM of the Adonis.js framework.

  • nodejs-bigquery

    Node.js client for Google Cloud BigQuery: A fast, economical and fully-managed enterprise data warehouse for large-scale data analytics.

    Project mention: How to authenticate via JSON file and query a table from NodeJS? | reddit.com/r/bigquery | 2022-07-25

    I have been searching the entire day, reading through the source code in https://github.com/googleapis/nodejs-bigquery , and I have yet to find an answer to this very basic, and at this point I feel also dumb, question.

  • sql-lint

    An SQL linter

    Project mention: sql-lint - A linter for SQL (finally hits version 1.0.0) | reddit.com/r/coolgithubprojects | 2022-06-24
  • pure-orm

    A pure ORM for writing native SQL queries yielding pure business objects

    Project mention: An ORM which only does object relational mapping | reddit.com/r/Database | 2022-05-09
  • sql-language-server

    SQL Language Server

    Project mention: A postgres plugin for neovim | reddit.com/r/neovim | 2022-03-15

    Nice. I'm going to try it out. This would go well with sql-language-server.

  • @databases

    TypeScript clients for databases that prevent SQL Injection

    Project mention: SQL result into variable | reddit.com/r/node | 2022-07-31

    Since the method is marked as async, you can use await to get the results of a query (if your database library supports promises. For example with https://www.atdatabases.org as your db library you could do

  • tellery

    Tellery lets you build metrics using SQL and bring them to your team. As easy as using a document. As powerful as a data modeling tool.

    Project mention: my list of self-hosted (dev) tools | reddit.com/r/selfhosted | 2022-05-19

    please take a look at tellery https://tellery.io/ this can be a great project , but it is stuck in 200 likes for a while now and i wanted to give it some love from the self-hosted community.

  • trilogy

    TypeScript SQLite layer with support for both native C++ & pure JavaScript drivers. (by haltcase)

    Project mention: Trilogy – GitHub-built MySQL client library written in C | news.ycombinator.com | 2021-12-15

    Naming is hard and conflicts are easy, but this project clashes with my own project called Trilogy. Both for SQL-family, although mine is in the JavaScript realm. I'm not too surprised someone followed the logic did to get the name.

    Not a huge project but has some users, and I still try to work on it to get the typings (TypeScript) where I want them.

    https://github.com/citycide/trilogy

  • sql-template-tag

    ES2015 tagged template string for preparing SQL statements, works with `pg` and `mysql`

    Project mention: Knex Raw SQL String SQL Highlighting VS Code and best practices to avoid SQL Injection Attack? | reddit.com/r/node | 2022-04-10

    If you prefer SQL and you use postgres you can check out slonik. If you want to keep using knex you can use https://github.com/blakeembrey/sql-template-tag. They will add placeholders for all the values and expose helper for query building via strings (e.g. a special join). At the same time they are typesafe.

  • iasql-engine

    Infrastructure as data in PostgreSQL

    Project mention: UPDATE iasql SET source = 'open'; | dev.to | 2022-03-03

    We are excited to announce that IaSQL is now open source! The main repository is under https://github.com/iasql/iasql-engine. As perfectionists, we feel like IaSQL will never be truly ready. However, we believe IaSQL is at the point where it can start to be useful for developers managing infrastructure in the cloud. IaSQL is a SaaS that lets you model your infrastructure as data by maintaining a 2-way connection between your AWS account and a Postgres SQL database to represent the definitive state (and status) of your cloud which cannot be achieved with a static infrastructure declaration. This means that when you connect an AWS account to an IaSQL instance it automatically backfills the database with your existing cloud resources. No need to painstakingly redefine or reconcile your existing infrastructure, and IaSQL's module system means you can specify which parts of your cloud infrastructure you wish to control.

  • flan

    A tasty tool that lets you save, load and share postgres snapshots with ease (by sdelements)

    Project mention: Flan – A tasty tool that lets you save, load and share Postgres dumps with ease | news.ycombinator.com | 2021-10-29
  • safe-typeorm

    TypeORM helper library enhancing safety in the compilation level

    Project mention: safe-typeorm, helper library of typeorm in the compilation level | reddit.com/r/typescript | 2021-09-14

    Name of the helper library is safe-typeorm and this helper library makes below things possible. With the safe-typeorm, you can develop your solution much easily and conveniently by taking such advantages:

  • Sqlmancer

    Conjure SQL from GraphQL queries 🧙🔮✨

  • vscode-bigquery

    A Visual Studio Code plugin for running BigQuery queries.

    Project mention: Released BigQuery Runner | reddit.com/r/vscode | 2021-11-24

    It's a fork of google/vscode-bigquery with some improvements.Even if the field type is a deep and complex array or struct, the result will be output in an easy to read format, and the error message will be output in an easy to read format when the query fails.

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 2022-08-09.

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 azuredatastudio 6,871
2 ts-sql 2,459
3 datastation 2,432
4 vscode-database-client 1,863
5 ElectroCRUD 1,391
6 typeorm 1,335
7 kysely 1,242
8 sql-formatter 1,239
9 node-pg-migrate 1,063
10 lucid 831
11 nodejs-bigquery 383
12 sql-lint 363
13 pure-orm 347
14 sql-language-server 336
15 @databases 333
16 tellery 284
17 trilogy 240
18 sql-template-tag 202
19 iasql-engine 179
20 flan 177
21 safe-typeorm 163
22 Sqlmancer 130
23 vscode-bigquery 128
Find remote jobs at our new job board 99remotejobs.com. There are 3 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Clean code begins in your IDE with SonarLint
Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
www.sonarlint.org