Open-source projects categorized as MySQL | Edit details

Top 23 MySQL Open-Source Projects

  • GitHub repo JavaGuide

    「Java学习+面试指南」一份涵盖大部分 Java 程序员所需要掌握的核心知识。准备 Java 面试,首选 JavaGuide!

    Project mention: Top 10 Developer Trends, Sun Oct 11 2020 | dev.to | 2020-10-11

    Snailclimb / JavaGuide

  • GitHub repo Grafana

    The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

    Project mention: Expose Open Policy Agent/Gatekeeper Constraint Violations for Kubernetes Applications with Prometheus and Grafana | dev.to | 2021-06-18

    We decided to use Prometheus and Grafana for gathering constraint violation metrics and displaying them, as these are good and popular open source tools.

  • GitHub repo tidb

    TiDB is an open source distributed HTAP database compatible with the MySQL protocol

    Project mention: Oceanbase, yet another open source HTAP database | news.ycombinator.com | 2021-05-31

    Another Chinese database seems to be doing a better job at this front: https://github.com/pingcap/tidb

  • GitHub repo Metabase

    The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:

    Project mention: Ask HN: Who is hiring? (June 2021) | news.ycombinator.com | 2021-06-01

    Metabase | https://metabase.com | REMOTE | Full-time | Engineering Product and Design

    We're hiring for multiple positions across the company.

    Metabase is open source analytics software that makes it easy to ask questions of your data. It interfaces with a number of databases / data warehouses (BigQuery, Redshift, Snowflake, Postgres, MySQL, etc) and has a simple and powerful UI and UX that sits on top of it.

    Tech stack: Clojure, Javascript, React, Redux, AWS (ECS, Autoscaling, Aurora, RDS, SecretsManager, S3)

    Roles: Frontend Engineering, Backend Engineering, Success Engineering, DevOps, Product Marketing Manager, Product Designer, Product Manager

    See https://www.metabase.com/jobs/

  • GitHub repo TypeORM

    ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    Project mention: I'm having some trouble creating entities in NestJs and typeorm | reddit.com/r/node | 2021-06-18

    Can you guys help out with: https://github.com/typeorm/typeorm/issues/7757

  • GitHub repo Sequelize

    An easy-to-use multi SQL dialect ORM tool for Node.js

    Project mention: Export Bear Notes to Markdown Files | dev.to | 2021-06-16

    We're going to keep this super simple. We'll find the database, make a copy, and query it directly with the sqlite3 package. If I were going to build a real workflow that I wanted to last, I'd probably look at putting a more formal system together using an ORM like Sequelize or Prisma. But I want to keep us focused here.

  • GitHub repo Redash

    Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

    Project mention: Apache Superset 1.1 | news.ycombinator.com | 2021-06-08

    Also Redash which I find to be more powerful: https://redash.io/

  • GitHub repo MySQL

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

    Project mention: DenoDB | news.ycombinator.com | 2021-06-17
  • GitHub repo Piwik

    Liberating Web Analytics. Star us on Github? +1. Matomo is the leading open alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. We love Pull Requests!

    Project mention: No More Google 🙅 | dev.to | 2021-06-10
  • GitHub repo Knex

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

    Project mention: We made Lowdefy - An open-source, self-hosted, low-code framework to easily make web apps, admin panels, BI dashboards, workflows, and CRUD apps with YAML or JSON. | reddit.com/r/javascript | 2021-06-12

    In terms of data, you can use Knex to connect to SQL databases or connect to MongoDB. You could even use the MongoDB query language to transform data on the frontend (a third party API response for example).

  • GitHub repo shardingsphere

    Distributed Database Ecosphere

    Project mention: Weekly Developer Roundup #23 - Sun Nov 22 2020 | dev.to | 2020-11-21

    apache/shardingsphere (Java): Distributed database middleware

  • GitHub repo Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server & SQLite

    Project mention: How to use PostgreSQL with Node? | reddit.com/r/node | 2021-06-14

    A lot of people opt for ORM libraries like TypeORM, Prisma or Sequelize for SQL databases.

  • GitHub repo nocodb

    🔥 🔥 The Open Source Airtable alternative.

    Project mention: Just released Baserow 1.3 with exporting to CSV, JSON importer, drag an drop ordering of databases, tables and views, new date filters, bug fixes and templates - Open Source Airtable alternative. | reddit.com/r/selfhosted | 2021-06-02

    NocoDB is a week old today :) and your first release was an year+ ago. So there might be a glitch :) and I believe small features that are mentioned as differentiators were just released a month ago.

  • GitHub repo vitess

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

    Project mention: Better JSON in Postgres with PostgreSQL 14 | news.ycombinator.com | 2021-06-01

    >but what does mysql do better than postgres

    Not MySQL itself but something like Vitess [1].

    [1] https://vitess.io

  • GitHub repo mybatis-plus

    An powerful enhanced toolkit of MyBatis for simplify development

    Project mention: The Apache Attic | news.ycombinator.com | 2021-04-09
  • GitHub repo Directus

    Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.

    Project mention: Headless CMS | reddit.com/r/cms | 2021-06-09
  • GitHub repo go-sql-driver/mysql

    Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)

    Project mention: Food-app | dev.to | 2021-06-08

    Go MySQL driver Link

  • GitHub repo cube.js

    📊 Cube.js — Open-Source Analytical API Platform

    Project mention: Looking for Feedback on an Open Source BI Project | reddit.com/r/BusinessIntelligence | 2021-06-02

    You might also want to think about integration with cube.js (https://cube.dev/), which is generic data layer. That way, you will have to think less about data connectors (and it's JS too).

  • GitHub repo mycli

    A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

    Project mention: What packages are missing from openSUSE? (and I will package it! ) | reddit.com/r/openSUSE | 2021-05-14

    lazygit and mycli.

  • GitHub repo gh-ost

    GitHub's Online Schema Migrations for MySQL

    Project mention: Altering table without downtime, MYSQL | reddit.com/r/SQL | 2021-05-11

    If you want to have finer control over how the alter works, there are a few 3rd party tools that will help you do them (gh-host and pt-online-schema-change).

  • GitHub repo Finagle

    A fault tolerant, protocol-agnostic RPC system

    Project mention: What is the state of frameworks and libraries support to build microservices in scala? | reddit.com/r/scala | 2021-04-16

    Finagle from Twitter

  • GitHub repo diesel

    A safe, extensible ORM and Query Builder for Rust

    Project mention: What's everyone working on this week (23/2021)? | reddit.com/r/rust | 2021-06-07

    You may find it easier to use threaded rouille HTTP server running on Heroku (with heroku-buildpack-rust) and store the images as Postgres Large Objects. Heroku backs up the database automatically, so you don't need to worry about a random machine failure destroying the photos while you're on your honeymoon.

  • GitHub repo migrate

    Database migrations. CLI and Golang library.

    Project mention: Simple database migration tool using fs.FS and sql.DB | reddit.com/r/golang | 2021-06-16

    I was always a bit confused about the complexity of my previous migration tool of choice, https://github.com/golang-migrate/migrate . While it does the job, setup of it on new projects is always a bit of a confusion. I wanted to build something simpler. My thought process:

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 2021-06-18.


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

Project Stars
1 JavaGuide 105,848
2 Grafana 42,596
3 tidb 28,138
4 Metabase 25,063
5 TypeORM 24,540
6 Sequelize 24,435
7 Redash 18,956
8 MySQL 16,495
9 Piwik 15,040
10 Knex 14,290
11 shardingsphere 14,076
12 Prisma 13,451
13 nocodb 12,373
14 vitess 12,043
15 mybatis-plus 11,199
16 Directus 11,118
17 go-sql-driver/mysql 10,972
18 cube.js 10,602
19 mycli 9,655
20 gh-ost 8,960
21 Finagle 7,980
22 diesel 6,941
23 migrate 6,605