awesome-mysql

awesome-mysql

A curated list of awesome MySQL free and opensource software, libraries and resources.

This list accepts and encourages pull requests. See CONTRIBUTING

Contents

• Awesome MySQL

  • Analysis
  • Backup
  • Benchmarking
  • Binlog Replication
  • ChatOps
  • Configuration
  • Connectors
  • Deployment
  • Development
  • GUI
  • HA
  • MCP
  • Proxy
  • Replication
  • Schema
  • Security
  • Server
  • Sharding
  • Toolkits

• Resources

  • E-Books

Analysis

Performance, structure & data analysis tools

• Anemometer - Box SQL slow query monitor.
• innodb-ruby - A parser for InnoDB file formats, in Ruby.
• innotop - a 'top' clone for MySQL with many features and flexibility.
• MySQL Explain Analyzer - A web-based analyzer of EXPLAIN FORMAT=JSON output, providing comments, scalability analysis and permalinks for saved samples.
• mysql-statsd - A Python daemon to collect information from MySQL and send it via StatsD to Graphite.
• MySQLTuner-perl - A script that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
• Prometheus/mysqld_exporter - Time series database for real-time monitoring and alerting.
• pstop - a top-like program for MySQL, collecting, aggregating and displaying information from performance_schema.
• ReliaDB EXPLAIN Analyzer - a browser-based MySQL and MariaDB EXPLAIN visualizer with issue detection, index recommendations, and query rewrites. 100% client-side.
• Wireshark - a protocol analyzer that can decode the MySQL protocol.
• Dolphie - a modern terminal tool for real-time analytics into MySQL/MariaDB & ProxySQL
• sql-tap - Real-time SQL traffic viewer.

Backup

Backup/restore/recovery tools

• Databasus - tool for scheduled MySQL backups via web UI with external storages (local, S3, FTP, Google Drive, etc.), notifications (webhook, Discord, Slack, etc.) and team management.
• Dumpling - Logical, parallel backup/dumper tool for MySQL/TiDB written in GoLang - support csv format output and integrated as library
• MyDumper - Logical, parallel backup/dumper tool for MySQL
• Percona Xtrabackup - an open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup.
• Portabase - Agent-based platform for MySQL backups and restores with decentralized execution and centralized orchestration.

Benchmarking

Tools to stress your servers

• HammerDB - An open-source database benchmark for MySQL/MariaDB and other open source and commercial databases.
• go-tpc - A golang port of TPCC and TPCH benchmark for MySQL.
• iibench-mysql - Java based version of the Index Insertion Benchmark for MySQL/Percona/MariaDB.
• Sysbench - a modular, cross-platform and multi-threaded benchmark tool.
• TPCC-MySQL (archived) - A port of the popular TPCC benchmark for MySQL.

Binlog-Replication

• DM - A High-Availability data migration platform which supports migrating data from MySQL/MariaDB to TiDB and merging shard tables
• Kingbus - A distributed MySQL binlog storage system built on Raft
• mysql-ripple (archived) - Ripple, a server that can serve as a middleman in MySQL replication

ChatOps

Scripts integrated into chat rooms

• Hubot MySQL ChatOps

Configuration

MySQL sample configuration and advisors

• mysql-compatibility-config - make MySQL configuration behave more like newer (or older) releases of MySQL.

Connectors

MySQL connectors for various programming languages

• ballerinax/mysql - Official Ballerina connector for MySQL.
• DBD::MariaDB - MariaDB and MySQL driver for the Perl5 Database Interface.
• DBD::mysql - MySQL driver for the Perl5 Database Interface.
• go-sql-driver - a lightweight and fast MySQL-Driver for Go's (golang) database/sql package.
• libAttachSQL - libAttachSQL is a lightweight, non-blocking C API for MySQL servers.
• MariaDB Connector/J - LGPL-licensed MariaDB Client Library for Java Applications.
• mex-mariadb - MIT licensed MariaDB/MySQL Client Library for GNU Octave and Matlab.
• MySQL C API - Official C driver for MySQL.
• MySQL Connector/C++ - Official C/C++ driver for MySQL.
• MySQL Connector/J - a standardized database driver for the Java platforms and development.
• MySQL Connector/NET - a standardized database driver for .Net platforms and development.
• MySQL Connector/Node.js - Official Node.js driver for MySQL.
• MySQL Connector/Python - a standardized database driver for Python platforms and development.
• mysqlclient-python - MySQL database connector for Python.
• node-mysql - A pure Nodejs Javascript client implementing the MySQL protocol.
• PHP mysqlnd - MySQL native driver for PHP.
• PyMySQL - MySQL database connector for Python.
• Ruby Mysql2 gem - MySQL driver for Ruby and Rails projects.
• MyZql - MySQL and MariaDB driver in native Zig.
• wtx - Client for MySQL/MariaDB/Percona written in Rust

Deployment

MySQL deployment tools

• dbdeployer - A tool that installs one or more MySQL servers within seconds, easily, securely, and with full control.
• MariaDB4j - A Java launcher to run MariaDB without installation or external dependencies.

Development

Tools to support MySQL-related development

• Flywaydb - Database migrations; Evolve your database schema easily and reliably across all your instances
• dbsafe - Pre-execution safety analysis for MySQL DDL/DML operations
• Liquibase - Source control for your database
• Shift - An application that helps you run schema migrations on MySQL databases
• Skeema - Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools
• SQLE - SQLE is a SQL audit platform for DBA or developer
• Test database - A sample MySQL database with an integrated test suite, used to test applications and servers
• cover_me - code coverage tool for mysql stored procedures and functions

GUI

GUI frontends & applications

• Adminer - Database management in a single PHP file.
• DBeaver - A cross-platform SQL and NoSQL database client.
• StackRender - Free and open-source database schema design and SQL migration generator for MySQL.
• HeidiSQL - MySQL GUI frontend for Windows.
• ILLA Cloud - Low-code internal tool builder integrated with Mysql, can be used as GUI for Mysql.
• LibreDB Studio - Browser-based SQL IDE for MySQL and nine other engines, deployed as a container or Helm chart next to the database.
• mycli - A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
• MySQL Shell - 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.
• MySQL Workbench - provides DBAs and developers an integrated tools environment for database design & modeling; SQL devleopment; database administration.
• Ocelot GUI - GUI client for MySQL or MariaDB, including debugger.
• OmniDB: Web tool for database management
• Percona Monitoring and Management - An open-source platform for managing and monitoring MySQL performance.
• phpMyAdmin - a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
• pspg - provides a pager with enhanced visualization and navigation for tabular data. Originally implemented for PostgreSQL, but also supports MySQL.
• Sequel Ace - a Mac database management application for working with MySQL databases.
• TablePro - Native macOS client for MySQL and many other databases with inline editing, SSH tunneling, and AI assistant. Free and open-source.
• SQLyog Community edition - SQLyog Community edition. For Windows, works fine under wine in Mac and Linux
• squix - SQL command-line client with query management and interactive results.
• WebDB – Open 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

HA

High availability solutions

• Galera Cluster - a true Multimaster Cluster based on synchronous rep