User Experience on mobile might not be great yet, but I'm working on it.

Your first time on this page? Allow me to give some explanations.

Awesome MySQL

A curated list of awesome MySQL software, libraries, tools and resources

Here you can see meta information about this topic like the time we last updated this page, the original creator of the awesome list and a link to the original GitHub repository.

Last Update: Dec. 1, 2020, 6:03 a.m.

Thank you shlomi-noach & contributors
View Topic on GitHub:
shlomi-noach/awesome-mysql

Search for resources by name or description.
Simply type in what you are looking for and the results will be filtered on the fly.

Further filter the resources on this page by type (repository/other resource), number of stars on GitHub and time of last commit in months.

Analysis

Box SQL Slow Query Monitor

1.28K
312
4y 51d
Apache-2.0

A parser for InnoDB file formats, in Ruby

835
180
12d
n/a

A realtime terminal-based top-like monitor for MySQL

612
108
8d
GPL-2.0

MySQL JSON Explain Analyzer

53
12
2y 77d
BSD-2-Clause
98
36
4y 9m
BSD-3-Clause

pstop - a top-like program for MySQL

167
24
15d
BSD-2-Clause

A script that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.

An open-source platform for managing and monitoring MySQL performance.

heavy_dollar_sign: - Open-source service monitoring system and time series database

Backup

37
18
92d
Apache-2.0

Official mydumper project

1.15K
271
85d
GPL-3.0

open-source web based backup tool - useful for shared webhosting

an open-source hot backup utility for MySQL - based servers that doesnโ€™t lock your database during the backup.

Benchmarking

Java based iiBench for MySQL/Percona/MariaDB

41
14
6y 8d
n/a

A toolbox to benchmark TPC workloads in Go

51
21
8d
Apache-2.0

Scriptable database and system performance benchmark

3.56K
708
82d
GPL-2.0

A port of the popular TPCC benchmark for MySQL.

Binlog-Replication

Data Migration Platform

338
131
4d
Apache-2.0

A distributed MySQL binlog storage system built on Raft

781
105
1y 7m
Apache-2.0

Ripple, a server that can serve as a middleman in MySQL replication

332
40
9m
Apache-2.0

ChatOps

ChatOps for MySQL.

86
8
6y 10m
MIT

Configuration

Make MySQL behave more like newer (or older) releases

88
32
3y 9m
n/a

Connectors

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

10.21K
1.83K
4d
MPL-2.0
  • NOTE: This is now a dead project and used for CI testing * A lightweight C API for MySQL servers
35
16
2y 8m
Apache-2.0

MariaDB Client for GNU Octave (maybe this is compatible for MySQL and Matlab too)

1
0
1y 7m
MIT

MySQL database connector for Python (with Python 3 support)

1.83K
303
5m
GPL-2.0

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

15.99K
2.22K
83d
MIT

Pure Python MySQL Client

6.22K
1.25K
82d
MIT

A modern, simple and very fast Mysql library for Ruby - binding to libmysql

2.04K
480
84d
MIT

a standardized database driver for the Java platforms and development.

Connector/Net is a fully-managed ADO.NET driver for MySQL

a standardized database driver for Python platforms and development.

LGPL-licensed MariaDB Client Library for Java Applications.

MySQL native driver for MySQL, deprecating older libmysql based driver.

Deployment

A tool that installs one or more MySQL servers within seconds, easily, securely, and with full control.

Development

shift is an application that helps you run schema migrations on MySQL databases

685
43
84d
Apache-2.0

A sample MySQL database with an integrated test suite, used to test your applications and database servers

2.28K
1.54K
85d
n/a

Database migrations; Evolve your database schema easily and reliably across all your instances

Source control for your database

Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools

GUI

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

9.2K
566
36d
n/a

GUI client for MySQL or MariaDB, including debugger

51
11
4d
n/a

Unix pager designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Now it can be used as CSV or TSV viewer. Works well with pgcli too.

1.38K
60
3d
BSD-2-Clause

MySQL/MariaDB database management for macOS

8.11K
773
5m
n/a
1.19K
186
7m
GPL-2.0

Free universal database tool and SQL client

16.78K
1.51K
2d
Apache-2.0

Web tool for database management

2.26K
340
34d
MIT

Database management in a single PHP file.

Powerful and easy client for MySQL, MariaDB, Microsoft SQL Server and PostgreSQL.

Advanced client and code editor for MySQL that supports development and administration for the MySQL Server and MySQL InnoDB cluster (AdminAPI) with an interactive JavaScript, Python, or SQL interface.

An open-source platform for managing and monitoring MySQL performance.

a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

HA

MySQL replication topology management and HA

3.85K
642
7d
Apache-2.0

Repository of the Percona Pacemaker resource agents

76
53
2y 4d
ISC

Signal 18 repman - Replication Manager for MySQL / MariaDB / Percona Server

440
125
6d
GPL-3.0

a true Multimaster Cluster based on synchronous replication.

MHA

Master High Availability Manager and tools for MySQL.

Proxy

An intelligent database proxy.

1.05K
286
5d
n/a

a MySQL proxy powered by Go

698
117
5y 54d
n/a
21
5
3y 15d
GPL-3.0

A simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication.

MySQL Router is part of InnoDB cluster, and is a lightweight middleware that provides transparent routing between your application and back-end MySQL Servers.

Schema

DBA's framework for MySQL

105
20
1y 10m
MIT

The MySQL sys schema

748
191
4y 4m
n/a

Security

Database security suite. Database proxy with field-level encryption, search through encrypted data, SQL injections prevention, intrusion detection, honeypots. Supports client-side and proxy-side ("transparent") encryption. SQL, NoSQL.

658
77
28d
Apache-2.0

Server

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.

3.58K
1.1K
3d
GPL-2.0

MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-time, open source transactional database.

5.87K
2.29K
5m
n/a

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

26K
4.05K
1d
Apache-2.0

An enhanced, drop-in MySQL replacement.

Sharding

MySQL toolkit for managing billions of rows and hundreds of database machines

1.13K
79
3y 5m
Apache-2.0

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

10.96K
1.41K
3d
Apache-2.0

Toolkits

GitHub's Online Schema Migrations for MySQL

8.33K
864
39d
MIT

a powerful mysql toolset with Go

2.71K
618
99d
n/a

a collection of command-line utilities, written in Python, that are used for maintaining and administering MySQL servers, either individually, or within Replication hierarchies.

a set of utilities that solve everyday maintenance tasks, which may be complicated or time consuming to do by hand, written in Python.

a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually.

a tool to recover data from dropped or corrupted InnoDB tables.

Conferences

Annual 2-day gathering of F/OSS developers in Brussels which sometimes has a "Lua devroom".

Oracle's annual MySQL conference, as part of Oracle Open World.

MySQL & Openstack focused conference.

A community organized Linux and Open Source conference held annually in Southern California. The local MySQL community runs a track under the name MySQL Community Day.

e-books