Awesome MySQL
by shlomi-noach · shlomi-noach/awesome-mysql
A curated list of awesome MySQL software, libraries, tools and resources.
A
D
I
I
MA web-based analyzer of EXPLAIN FORMAT=JSON output, providing comments, scalability analysis and permalinks for saved samples.
MA Python daemon to collect information from MySQL and send it via StatsD to Graphite.
MA script that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
P/mysqldexporter - Time series database for real-time monitoring and alerting.
Pa top-like program for MySQL, collecting, aggregating and displaying information from performanceschema.
Ra browser-based MySQL and MariaDB EXPLAIN visualizer with issue detection, index recommendations, and query rewrites. 100% client-side.
S
Dtool for scheduled MySQL backups via web UI with external storages (local, S3, FTP, Google Drive, etc.), notifications (webhook, Discord, Slack, etc.) and team management.
DLogical, parallel backup/dumper tool for MySQL/TiDB written in GoLang - support csv format output and integrated as library
M
Pan open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup.
PAgent-based platform for MySQL backups and restores with decentralized execution and centralized orchestration.
HAn open-source database benchmark for MySQL/MariaDB and other open source and commercial databases.
IJava based version of the Index Insertion Benchmark for MySQL/Percona/MariaDB.
S
TDA High-Availability data migration platform which supports migrating data from MySQL/MariaDB to TiDB and merging shard tables
K
M(archived) - Ripple, a server that can serve as a middleman in MySQL replication
H
Mmake MySQL configuration behave more like newer (or older) releases of MySQL.
B
D
Ga lightweight and fast MySQL-Driver for Go's (golang) database/sql package.
L
M
M
Ma standardized database driver for the Java platforms and development.
Ma standardized database driver for Python platforms and development.
M
M
N
R
W
MA Java launcher to run MariaDB without installation or external dependencies.
C
D
FDatabase migrations; Evolve your database schema easily and reliably across all your instances
L
S
SDeclarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools
S
TA sample MySQL database with an integrated test suite, used to test applications and servers
A
D
H
ILow-code internal tool builder integrated with Mysql, can be used as GUI for Mysql.
MMAdvanced 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.
Mprovides DBAs and developers an integrated tools environment for database design & modeling; SQL devleopment; database administration.
O
OPAn open-source platform for managing and monitoring MySQL performance.
Pa free software tool written in PHP, intended to handle the administration of MySQL over the Web.
Pprovides a pager with enhanced visualization and navigation for tabular data. Originally implemented for PostgreSQL, but also supports MySQL.
S
SSQLyog Community edition. For Windows, works fine under wine in Mac and Linux
S
TNative macOS client for MySQL and many other databases with inline editing, SSH tunneling, and AI assistant. Free and open-source.
WOpen Source and Efficient Database IDE. Featuring Easy server connection, Modern ERD, Intelligent data generator, AI assistant, NoSQL structure manager, Time machine and Powerful query editor
G
Mand mha4mysql-manager (both unmaintained) - Master High Availability Manager and tools for MySQL.
O(archived) - MySQL replication topology management and High Availability solution.
PAsynchronous MySQL replication manager agent for Pacemaker. Supports file and GTID based replication, geo-distributed clusters using booth.
Ra high availability solution to manage MariaDB 10.x and MySQL & Percona Server 5.7 GTID replication topologies.
V
M
MMySQL Router is part of InnoDB cluster, and is a lightweight middleware that provides transparent routing between your application and back-end MySQL Servers.
P
D(archived) - Command-line tool and Python library to efficiently diff rows across two different databases.
CDBA's framework for MySQL, providing a function library, views library and QueryScript interpreter.
S(archived) - A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage. See sys schema docs
ASQL database protection suite: strong selective encryption, SQL injections prevention, intrusion detection system.
MStreaming anonymizer for MySQL dump files, reading mysqldump output from stdin and writing anonymized data to stdout. Supports deterministic hashing, fixed values, JSON field anonymization, and Python extensions.
MMOfficial Oracle's MySQL server & MySQL Cluster distribution.
J
Vvitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services.
G
GM(deprecated) - a collection of command-line utilities, written in Python, that are used for maintaining and administering MySQL servers, either individually, or within Replication hierarchies.
Pa 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.
SHigh-performance CLI for splitting, merging, converting, validating, and sampling mysqldump files.
SUltra fast MySQL table importer that stages swaps through temporary tables and supports file/clipboard targets.
Ulecture notes on Database Systems (available in pdf, html, odt and markdown) including a Chapter on SQL that covers basic set-up, exercises and problems.
Scontains several SQL exercises, including the schema description figure, SQL code to build schema, questions and solutions in SQL. Based on wikibook SQL Exercises.