JavaScript SQL

Open-source JavaScript projects categorized as SQL
Edit details
Topics: #Database #MySQL #JavaScript #NodeJS #Postgresql
Collect and Analyze Billions of Data Points in Real Time
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.
www.influxdata.com
Sponsored

Top 23 JavaScript 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: Contributing to Tech Communities: How Open-Source can land you a job and get you out of the Skill Paradox 💼 | dev.to | 2023-09-26

    I made a small change to the new documentation for Sequelize! I was just scrolling through the documentation and found this mistake that could lead others to weird debugging sessions, so as soon as I found it, I submitted a PR for them! You can check out the contribution here!

  • Knex

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

    Project mention: Plankaban Raspberry Pi 4 Setup Help | /r/selfhosted | 2023-06-08

    # related: https://github.com/knex/knex/issues/2354

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

  • sql.js

    A javascript library to run SQLite on the web.

    Project mention: How to show CRUD projects on Github? | /r/learnprogramming | 2023-05-08

  • falcon

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

    Project mention: Best apps for transitioning from Spreadsheets to SQLite? | /r/macapps | 2023-05-27

    Regarding visualization tools, sqliteviz has proven to be the best I've found so far. Their web app runs locally but has some trackers, so I run it locally via a simple, static HTTP server. Falcon and Redash seem like overkill for my needs.

  • franchise

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

    Project mention: What is the best web-based PostgreSQL for Workshop | /r/PostgreSQL | 2022-10-05

    Would https://franchise.cloud be any use?

  • join-monster

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

  • sqliteviz

    Instant offline SQL-powered data visualisation in your browser

    Project mention: Best apps for transitioning from Spreadsheets to SQLite? | /r/macapps | 2023-05-27

    Regarding visualization tools, sqliteviz has proven to be the best I've found so far. Their web app runs locally but has some trackers, so I run it locally via a simple, static HTTP server. Falcon and Redash seem like overkill for my needs.

  • Sonar

    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.

  • react-awesome-query-builder

    User-friendly query builder for React

    Project mention: What are some of the main packages and other parts of the React ecosystem that have yet to be implemented in Svelte contrib? | /r/sveltejs | 2023-04-17

    A query builder https://github.com/ukrbublik/react-awesome-query-builder

  • jQuery-QueryBuilder

    jQuery plugin offering an interface to create complex queries

  • ElectroCRUD

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

    Project mention: After few years, ElectroCRUD is coming back | /r/opensource | 2023-01-19

    development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop

  • generator-starhackit

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

  • xhgui-branch

    uprofiler UI,xhprof UI,tideways UI , PHP Non-intrusive performance monitoring platform.

    Project mention: 使用基于 tideways 的 php-monitor 搭建 PHP 性能监控平台 | dev.to | 2023-09-07

    xhgui：https://github.com/laynefyc/xhgui-branch

  • 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: Best Clone Projects On Github!! | /r/github | 2023-01-26

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

  • gnorm

    A database-first code generator for any language

    Project mention: Architecture Pitfalls: Don’t use your ORM entities for everything — embrace the SQL! | /r/programming | 2023-01-12

    Furthermore, there can be a lot of boilerplate queries we do that it's nice to not have to write, say, the same kind of delete query over and over. In the past I've used gnorm as one way of generating all that boilerplate code based on the actual database design, and it works reasonably well, but again it plays a similar role to an ORM.

  • dataframe-js

    A javascript library providing a new data structure for datascientists and developpers

    Project mention: I made an app which grabs all Top Shot activity into a CSV and runs calculations to help with tax | /r/nbatopshot | 2022-10-06

    It might be an issue with file paths on windows and this dataframe.js library I'm using. At least similar to this issue: https://github.com/Gmousse/dataframe-js/issues/105

  • 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

  • analytics-toolbox-core

    A set of UDFs and Procedures to extend BigQuery, Snowflake, Redshift, Postgres and Databricks with Spatial Analytics capabilities

  • dekart

    WebGL-powered map visualizations for modern Data Platform. Self-hosted alternative to CARTO and Foursquare Studio.

    Project mention: Dekart is an open-source data visualization and analytical tool for large scale geospatial data. Dekart is based on Kepler.gl visualization and supports BigQuery as a data source. | /r/dekart | 2023-05-01

  • firenze

    Adapter based JavaScript ORM for Node.js and the browser

  • SQLToy

    Learn SQL by creating a SQL database in JavaScript

  • Stackoverflow-Clone-Backend

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

  • Onboard AI

    Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.

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

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 28,454
2 Knex 18,034
3 sql.js 11,652
4 falcon 5,094
5 franchise 3,978
6 join-monster 2,616
7 sqliteviz 1,783
8 react-awesome-query-builder 1,655
9 jQuery-QueryBuilder 1,636
10 ElectroCRUD 1,498
11 generator-starhackit 1,287
12 xhgui-branch 890
13 Stackoverflow-Clone-Frontend 502
14 gnorm 482
15 dataframe-js 447
16 Codecademy-Exercise-Answers 292
17 cuelake 281
18 sqliterally 257
19 analytics-toolbox-core 178
20 dekart 155
21 firenze 130
22 SQLToy 122
23 Stackoverflow-Clone-Backend 102

Sponsored
Collect and Analyze Billions of Data Points in Real Time
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.
www.influxdata.com