JavaScript SQL

Open-source JavaScript projects categorized as SQL Edit details

Top 23 JavaScript SQL Projects

  • Sequelize

    An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js | Postgres, MySQL, MariaDB, SQLite, MSSQL, Snowflake & DB2

    Project mention: Comparing 4 popular NestJS ORMs | dev.to | 2022-06-22

    Introduced around 2014, Sequelize is an easy-to-use and Promise-based ORM for Node.js.

  • Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

    Project mention: Tech stack for this? | reddit.com/r/webdev | 2022-06-08

    For using SQL with JavaScript check out knex.js

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

  • sql.js

    A javascript library to run SQLite on the web.

    Project mention: Show HN: CSVFiddle – Query CSV files with DuckDB in the browser | news.ycombinator.com | 2022-07-01

    Does it work with really large files? Like, >100mb or so. I was considering making something similar but with sqlite.js [1], but the problem with it is that it loads everything in memory, so I wasn't entirely sure how it will deal with larger workloads.

    [1]: https://sql.js.org/#/

  • falcon

    Free, open-source SQL client for Windows and Mac 🦅 (by plotly)

    Project mention: best free sql query assistance tool | reddit.com/r/SQL | 2021-08-30

    Or maybe Falcon as a desktop tool.

  • franchise

    🍟 a notebook sql client. what you get when have a lot of sequels.

    Project mention: Show HN: DataStation – App to easily query, script, and visualize data | news.ycombinator.com | 2022-05-31

    I love the idea of a data notebook. Have you seen Franchise? It's a lovely design for something similar, though its implementation (which stopped in 2019) didn't go beyond querying and visualization, rather than manipulation. But the stying and component design are lovely, and it may be possible to pull that from their code. https://github.com/HVF/franchise

  • join-monster

    A GraphQL to SQL query execution layer for query planning and batch data fetching.

    Project mention: GraphQL Is a Trap? | news.ycombinator.com | 2022-05-06
  • jQuery-QueryBuilder

    jQuery plugin offering an interface to create complex queries

    Project mention: Creating a condition/rule builder for users to save rules - unsure how to model this in Django | reddit.com/r/django | 2022-05-05

    https://querybuilder.js.org look this up to get an idea ;)

  • SonarLint

    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.

  • sqliteviz

    Instant offline SQL-powered data visualisation in your browser

    Project mention: Awesome SQLite | dev.to | 2022-04-28

    sqliteviz - Instant offline SQL-powered data visualisation in your browser

  • generator-starhackit

    StarHackIt: React/Native/Node fullstack starter kit with authentication and authorisation, data backed by SQL, the infrastructure deployed with GruCloud

  • react-awesome-query-builder

    User-friendly query builder for React

    Project mention: Recommendations for exposing / publishing business rules | reddit.com/r/SoftwareEngineering | 2022-02-04

    I'm using JsonLogic quite a bit. If your just after true/false I've found this is great: https://github.com/ukrbublik/react-awesome-query-builder

  • gnorm

    A database-first code generator for any language

    Project mention: Is it just me who doesn't agree with db first ORM model? | reddit.com/r/golang | 2022-04-09

    I've used gnorm for that in the past for some code generation, and I had absolute control. Gnorm took care of the database inspection side of things, and I created the templates it used to generate the code. I had full control over generated models and code.

  • Stackoverflow-Clone-Frontend

    Clone project of a famous Q/A website for developers built using MySQL, Express, React, Node, Sequelize :globe_with_meridians:

    Project mention: Stack Overflow CLONE (MySQL + Sequelize + Node + React) | reddit.com/r/todayilearned | 2022-03-13
  • mlcraft

    Low-code metrics store, modern open-source alternative to Looker

    Project mention: Ыelf-hosted alternative to Looker | reddit.com/r/selfhosted | 2021-09-27
  • Codecademy-Exercise-Answers

    :mortar_board: Codecademy.com exercise answers

  • cuelake

    Use SQL to build ELT pipelines on a data lakehouse.

  • sqliterally

    Lightweight SQL query builder

  • dekart

    Write SQL and get beautiful, shareable Maps based on Kepler.gl

  • SQLToy

    An in-memory SQL database written in Javascript to demonstrate how SQL works.

    Project mention: SQL: The difference between WHERE and HAVING | news.ycombinator.com | 2021-12-14

    You might look at SQLToy which is a DB and blog I wrote to teach how SQL processing works internally: https://github.com/weinberg/SQLToy

  • lexiQL

    lexiQL is a GraphQL prototyping tool and SQL database visualizer built for developers looking to optimize their queries and transition away from RESTful APIs

  • Stackoverflow-Clone-Backend

    Backend code of the Stackoverflow Clone project. Built using Express, Node, MySQL, and Sequelize

    Project mention: Stackoverflow CLONE (MySQL + Express + React + Node) | reddit.com/r/reactjs | 2021-09-14

    Frontend: https://github.com/Mayank0255/Stackoverflow-Clone-Frontend Backend: https://github.com/Mayank0255/Stackoverflow-Clone-Backend

  • worker-template-postgres

    Reference demo and modified PostgreSQL driver to connect Cloudflare Workers to a relational database.

    Project mention: Cloudflare Workers Postgres Client | reddit.com/r/CloudFlare | 2022-06-19

    Couldn't find any good Postgres client for Cloudflare Workers, so I decided to bundle the Postgres template into a single module. I hope it is useful for some of you!

  • database-js

    Common Database Interface for Node

  • tree-sitter-sql

    SQL syntax highlighting for tree-sitter

    Project mention: Open Source SQL Parsers | news.ycombinator.com | 2022-04-21
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-07-01.

JavaScript SQL related posts

Index

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

Project Stars
1 Sequelize 26,362
2 Knex 16,014
3 sql.js 10,244
4 falcon 4,930
5 franchise 3,880
6 join-monster 2,485
7 jQuery-QueryBuilder 1,546
8 sqliteviz 1,534
9 generator-starhackit 1,270
10 react-awesome-query-builder 1,195
11 gnorm 456
12 Stackoverflow-Clone-Frontend 405
13 mlcraft 338
14 Codecademy-Exercise-Answers 290
15 cuelake 267
16 sqliterally 251
17 dekart 114
18 SQLToy 106
19 lexiQL 77
20 Stackoverflow-Clone-Backend 58
21 worker-template-postgres 57
22 database-js 51
23 tree-sitter-sql 49
Find remote jobs at our new job board 99remotejobs.com. There are 2 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
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.
scoutapm.com