50 Top Projects of SQL on GitHub in 2018

50 Top Projects of SQL on GitHub in 2018

Image for post

1) Sequelize

Image for post

Sequelize is a promise-based Node.js ORM for Postgres, MySQL, SQLite and Microsoft SQL Server. It features solid transaction support, relations, read replication and more.

GitHub Stars: 14.5k+

The GitHub page of Sequelize from where you can download and see the project code is:

https://github.com/sequelize/sequelize

2) TiDB

Image for post

TiDB (The pronunciation is: /?ta?di?bi:/ tai-D-B, etymology: titanium) is an open-source distributed scalable Hybrid Transactional and Analytical Processing (HTAP) database. It features infinite horizontal scalability, strong consistency, and high availability. TiDB is MySQL compatible and serves as a one-stop data warehouse for both OLTP (Online Transactional Processing) and OLAP (Online Analytical Processing) workloads.

GitHub Stars: 13.5k+

The GitHub page of TiDB from where you can download and see the project code is:

https://github.com/pingcap/tidb

3) mysqljs

Image for post

A pure node.js JavaScript Client implementing the MySql protocol.

GitHub Stars: 12k+

The GitHub page of mysql from where you can download and see the project code is:

https://github.com/mysqljs/mysql

4) KNEX

Image for post

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

GitHub Stars: 7k+

The GitHub page of KNEX from where you can download and see the project code is:

https://github.com/tgriesser/knex

5) TypeORM

Image for post

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native and Electron platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7, ES8). Its goal is to always support the latest JavaScript features and provide additional features that help you to develop any kind of application that uses databases ? from small applications with a few tables to large scale enterprise applications with multiple databases.

GitHub Stars: 6.5k+

The GitHub page of TypeORM from where you can download and see the project code is:

https://github.com/typeorm/typeorm

6) Vitess

Image for post

Vitess is a database clustering system for horizontal scaling of MySQL through generalized sharding.

GitHub Stars: 6.5k+

The GitHub page of Vitess from where you can download and see the project code is:

https://github.com/vitessio/vitess

7) mycli

Image for post

A command line client for MySQL that can do auto-completion and syntax highlighting.

GitHub Stars: 6k+

The GitHub page of mycli from where you can download and see the project code is:

https://github.com/dbcli/mycli

8) Go-MySQL-Driver

Image for post

Go MySQL Driver is a MySQL driver for Go?s (golang) database/sql package.

GitHub Stars: 5.5k+

The GitHub page of Go MySQL Driver from where you can download and see the project code is:

https://github.com/go-sql-driver/mysql

9) gh-ost

Image for post

GitHub?s Online Schema Migrations for MySQL.

GitHub Stars: 5.5k+

The GitHub page of gh-ost from where you can download and see the project code is:

https://github.com/github/gh-ost

10) DBeaver

Image for post

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports any database which has JDBC driver (which basically means ? ANY database). EE version also supports non-JDBC datasources (WMI, MongoDB, Cassandra, Redis).

GitHub Stars: 5k+

The GitHub page of DBeaver from where you can download and see the project code is:

https://github.com/dbeaver/dbeaver

11) bookshelf.js

Image for post

A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

GitHub Stars: 4.9k+

The GitHub page of bookshelf.js from where you can download and see the project code is:

https://github.com/bookshelf/bookshelf

12) PyMySQL

Image for post

Pure Python MySQL Client.

GitHub Stars: 4k+

The GitHub page of PyMySQL from where you can download and see the project code is:

https://github.com/PyMySQL/PyMySQL

13) Bolt

Image for post

Bolt is a simple CMS written in PHP. It is based on Silex and Symfony components, uses Twig and either SQLite, MySQL or PostgreSQL.

GitHub Stars: 3.5k+

The GitHub page of Bolt from where you can download and see the project code is:

https://github.com/bolt/bolt

14) kingshard

Image for post

kingshard is a high-performance proxy for MySQL powered by Go. Just like other mysql proxies, you can use it to split the read/write sqls. Now it supports basic SQL statements (select, insert, update, replace, delete). The most important feature is the sharding function. Kingshard aims to simplify the sharding solution of MySQL. The Performance of kingshard is about 80% compared to connecting to MySQL directly.

GitHub Stars: 3.5k+

The GitHub page of kingshard from where you can download and see the project code is:

https://github.com/flike/kingshard

15) Franchise

Image for post

Franchise is a lightweight but powerful SQL tool with a notebook interface.

GitHub Stars: 3k+

The GitHub page of Franchise from where you can download and see the project code is:

https://github.com/HVF/franchise

16) phpMyAdmin

Image for post

A web interface for MySQL and MariaDB.

GitHub Stars: 3k+

The GitHub page of phpMyAdmin from where you can download and see the project code is:

https://github.com/phpmyadmin/phpmyadmin

17) AliSQL

Image for post

AliSQL is a MySQL branch originated from Alibaba Group. It is based on the MySQL official release and has many feature and performance enhancements. AliSQL has proven to be very stable and efficient in production environment. It can be used as a free, fully compatible, enhanced and open source drop-in replacement for MySQL.

GitHub Stars: 2.5k+

The GitHub page of AliSQL from where you can download and see the project code is:

https://github.com/alibaba/AliSQL

18) Requery

Image for post

A light but powerful object mapping and SQL generator for Java/Kotlin/Android with RxJava and Java 8 support. Easily map to or create databases, perform queries and updates from any platform that uses Java.

GitHub Stars: 2.5k+

The GitHub page of Requery from where you can download and see the project code is:

https://github.com/requery/requery

19) usql

Image for post

A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and other SQL databases.

GitHub Stars: 2k+

The GitHub page of usql from where you can download and see the project code is:

https://github.com/xo/usql

20) SQLPad

Image for post

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, Crate, Vertica, and Presto. Written in Node.js.

GitHub Stars: 1.8k+

The GitHub page of SQLPad from where you can download and see the project code is:

https://github.com/rickbergfalk/sqlpad

21) sqlcheck

Image for post

sqlcheck automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.

GitHub Stars: 1.5k+

The GitHub page of sqlcheck from where you can download and see the project code is:

https://github.com/jarulraj/sqlcheck

22) Sqitch

Image for post

Sqitch is a database change management application. It currently supports PostgreSQL 8.4+, SQLite 3.7.11+, MySQL 5.0+, Oracle 10g+, Firebird 2.0+, Vertica 6.0+ and Exasol 6.0+.

GitHub Stars: 1.4k+

The GitHub page of Sqitch from where you can download and see the project code is:

https://github.com/sqitchers/sqitch

23) generatedata

Image for post

Random data generator in JS, PHP and MySQL.

GitHub Stars: 1.3k+

The GitHub page of generatedata from where you can download and see the project code is:

https://github.com/benkeen/generatedata

24) JSqlParser

Image for post

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes.

GitHub Stars: 1.2k+

The GitHub page of JSqlParser from where you can download and see the project code is:

https://github.com/JSQLParser/JSqlParser

25) Node MySQL 2

Image for post

Fast node-mysql compatible mysql driver for node.js.

GitHub Stars: 1.1k+

The GitHub page of Node MySQL 2 from where you can download and see the project code is:

https://github.com/sidorares/node-mysql2

26) python-mysql-replication

Image for post

Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL.

GitHub Stars: 1k+

The GitHub page of python-mysql-replication from where you can download and see the project code is:

https://github.com/noplay/python-mysql-replication

27) LAMP

LAMP is a powerful bash script for the installation of Apache + PHP + MySQL/MariaDB/Percona Server and so on. You can install Apache + PHP + MySQL/MariaDB/Percona Server in an very easy way, just need to choose what you want to install before installation. And all things will be done in a few minutes.

GitHub Stars: 1k+

The GitHub page of LAMP from where you can download and see the project code is:

https://github.com/teddysun/lamp

28) mysql_utils

Image for post

Pinterest MySQL Management Tools.

GitHub Stars: 500+

The GitHub page of mysql_utils from where you can download and see the project code is:

https://github.com/pinterest/mysql_utils

29) SQL Tabs

Image for post

Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift.

GitHub Stars: 500+

The GitHub page of SQL Tabs from where you can download and see the project code is:

https://github.com/sasha-alias/sqltabs

30) Fullstack GraphQL

Image for post

Simple Fullstack GraphQL Application. API built with Express + GraphQL + Sequelize (supports MySQL, Postgres, Sqlite and MSSQL). WebApp built with React + Redux to access the API. Written in ES6 using Babel + Webpack.

GitHub Stars: 500+

The GitHub page of Fullstack GraphQL from where you can download and see the project code is:

https://github.com/atulmy/fullstack-graphql

31) binlog2sql

Image for post

Parse MySQL binlog to SQL you want.

GitHub Stars: 500+

The GitHub page of binlog2sql from where you can download and see the project code is:

https://github.com/danfengcao/binlog2sql

32) Program O

Image for post

PHP MySQL AIML Chatbot ? One click installation. Fully loaded admin area to admin your chatbot. Set up multiple chatbots. Foreign language support.

GitHub Stars: 500+

The GitHub page of Program O from where you can download and see the project code is:

https://github.com/Program-O/Program-O

33) Grafana dashboards

Image for post

Grafana dashboards for MySQL and MongoDB monitoring using Prometheus.

GitHub Stars: 500+

The GitHub page of Grafana dashboards from where you can download and see the project code is:

https://github.com/percona/grafana-dashboards

34) FluentPDO

Image for post

FluentPDO is a smart SQL Builder for PHP.

GitHub Stars: 500+

The GitHub page of FluentPDO from where you can download and see the project code is:

https://github.com/envms/fluentpdo

35) MySQLDump ? PHP

Image for post

PHP version of mysqldump cli that comes with MySQL.

GitHub Stars: 500+

The GitHub page of MySQLDump ? PHP from where you can download and see the project code is:

https://github.com/ifsnop/mysqldump-php

36) HeidiSQL

Image for post

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases, PostgreSQL and MariaDB. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data, either to SQL file, clipboard or to other servers.

GitHub Stars: 500+

The GitHub page of HeidiSQL from where you can download and see the project code is:

https://github.com/HeidiSQL/HeidiSQL

37) aiomysql

Image for post

aiomysql is a library for accessing a MySQL database from the asyncio.

GitHub Stars: 500+

The GitHub page of aiomysql from where you can download and see the project code is:

https://github.com/aio-libs/aiomysql

38) Npgsql

Image for post

Npgsql is the .NET data provider for PostgreSQL.

GitHub Stars: 1k+

The GitHub page of Npgsql from where you can download and see the project code is:

https://github.com/npgsql/npgsql

39) pg

Image for post

PostgreSQL ORM for Golang with focus on PostgreSQL features and performance.

GitHub Stars: 1.5k+

The GitHub page of pg from where you can download and see the project code is:

https://github.com/go-pg/pg

40) KSQL

Image for post

KSQL is the streaming SQL engine for Apache Kafka.

GitHub Stars: 1.5k+

The GitHub page of KSQL from where you can download and see the project code is:

https://github.com/confluentinc/ksql

41) PipelineDB

Image for post

SQL on streams, backed by PostgreSQL.

GitHub Stars: 1.5k+

The GitHub page of PipelineDB from where you can download and see the project code is:

https://github.com/pipelinedb/pipelinedb

42) Join Monster

Image for post

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

GitHub Stars: 1k+

The GitHub page of Join Monster from where you can download and see the project code is:

https://github.com/acarl005/join-monster

43) GRDB 3

A toolkit for SQLite databases, with a focus on application development.

GitHub Stars: 1k+

The GitHub page of GRDB 3 from where you can download and see the project code is:

https://github.com/groue/GRDB.swift

44) gitbase

Image for post

SQL interface to Git repositories, written in Go.

GitHub Stars: 1k+

The GitHub page of gitbase from where you can download and see the project code is:

https://github.com/src-d/gitbase

45) RadonDB

Image for post

RadonDB is an open source, Cloud-native MySQL database for unlimited scalability and performance.

GitHub Stars: 800+

The GitHub page of RadonDB from where you can download and see the project code is:

https://github.com/radondb/radon

46) RediSQL

Image for post

RediSQL is a module for Redis that embed a completely functional SQLite database.

GitHub Stars: 500+

The GitHub page of RediSQL from where you can download and see the project code is:

https://github.com/RedBeardLab/rediSQL

47) GitHub::DS

Image for post

A collection of Ruby libraries for working with SQL on top of ActiveRecord?s connection.

GitHub Stars: 400+

The GitHub page of GitHub::DS from where you can download and see the project code is:

https://github.com/github/github-ds

48) SQLite Client for Node.js Apps

Image for post

SQLite client library for Node.js applications (SQlite3, ES6 Promise, ES7 async/await, Babel) and SQL-based migrations API.

GitHub Stars: 300+

The GitHub page of SQLite Client for Node.js Apps from where you can download and see the project code is:

https://github.com/kriasoft/node-sqlite

49) DataFusion

SQL Query Execution against Apache Arrow, in Rust.

GitHub Stars: 300+

The GitHub page of DataFusion from where you can download and see the project code is:

https://github.com/datafusion-rs/datafusion

50) PacketQ

Image for post

A tool that provides a basic SQL-frontend to PCAP-files.

GitHub Stars: 300+

The GitHub page of PacketQ from where you can download and see the project code is:

https://github.com/DNS-OARC/PacketQ

This post is curated by IssueHunt that a issue-based bounty platform for open-source projects.

IssueHunt offers a service that pays freelance developers for contributing to the open-source code. We do it through what is called bounties: financial rewards granted to whoever solves a given problem. The funding for these bounties comes from anyone who is willing to donate to have any given bug fixed or feature added.

IssueHunt – Boost your issue and boost your happiness

IssueHunt ? = OSS Development ? + Bounty Program ?. IssueHunt is an issue-based bounty platform for open source?

issuehunt.io

1

No Responses

Write a response