Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge. Learn more →
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.
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.
-
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!
-
Project mention: Database Review: Top Five Missing Features from Database APIs | dev.to | 2023-09-14
Kysely
-
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.
-
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.
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.
-
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.
-
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.
-
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?
-
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.
-
-
-
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-25That 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".
-
-
Project mention: Generate and run SQL with GPT in Database Client (built with go - wails) | /r/golang | 2023-07-02
-
-
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)
-
-
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.
-
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.
-
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-09I 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-17When 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
- How to Design a SurrealDB schema and create a basic client for TypeScript
- SurrealDB - Structuring Data for Multi-Tenant Role & Permission Systems
- 👻Top 8 Free, Open Source SQL Clients🔥
- Modern data stack: scaling people and technology at FINN
- compile-time SQL validations and type generation in TypeScript & Node
- azuredatastudio: NEW Data - star count:7203.0
- azuredatastudio: NEW Data - star count:7203.0
-
A note from our sponsor - InfluxDB
www.influxdata.com | 25 Sep 2023
Index
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.
www.sonarsource.com