awesome-mysql

MySQL management toolbox

A curated collection of tools and resources for managing and optimizing MySQL databases

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

GitHub
2k stars
121 watching
379 forks
last commit: about 1 month ago
Linked from 9 awesome lists


awesome-mysql / Analysis
Anemometer 1,389 about 3 years ago Box SQL slow query monitor
innodb-ruby 1,695 about 2 months ago A parser for InnoDB file formats, in Ruby
innotop 766 about 2 months ago a 'top' clone for MySQL with many features and flexibility
MySQL Explain Analyzer 93 almost 2 years ago A web-based analyzer of output, providing comments, scalability analysis and permalinks for saved samples
mysql-statsd 99 over 3 years ago A Python daemon to collect information from MySQL and send it via StatsD to Graphite
MySQLTuner-perl 9,011 2 months ago A script that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability
Prometheus 56,244 about 1 month ago / - Time series database for real-time monitoring and alerting
pstop 206 about 1 month ago a top-like program for MySQL, collecting, aggregating and displaying information from performance_schema
Wireshark a protocol analyzer that can decode the MySQL protocol
Dolphie 688 about 1 month ago a modern terminal tool for real-time analytics into MySQL/MariaDB & ProxySQL

awesome-mysql / Backup
Dumpling 37,447 about 1 month ago Logical, parallel backup/dumper tool for MySQL/TiDB written in GoLang - support csv format output and integrated as library
MyDumper 2,567 about 1 month ago Logical, parallel backup/dumper tool for MySQL
Percona Xtrabackup 1,313 about 1 month ago an open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup

awesome-mysql / Benchmarking
go-tpc 184 5 months ago A golang port of and benchmark for MySQL
iibench-mysql 46 about 7 years ago Java based version of the Index Insertion Benchmark for MySQL/Percona/MariaDB
Sysbench 6,174 5 months ago a modular, cross-platform and multi-threaded benchmark tool
TPCC-MySQL 481 over 6 years ago (archived) - A port of the popular benchmark for MySQL

awesome-mysql / Binlog-Replication
DM 431 about 1 month ago A High-Availability data migration platform which supports migrating data from MySQL/MariaDB to TiDB and merging shard tables
Kingbus 889 almost 4 years ago A distributed MySQL binlog storage system built on Raft
mysql-ripple 374 over 3 years ago (archived) - Ripple, a server that can serve as a middleman in MySQL replication

awesome-mysql / ChatOps
Hubot MySQL ChatOps 90 almost 11 years ago

awesome-mysql / Configuration
mysql-compatibility-config 94 almost 8 years ago make MySQL configuration behave more like newer (or older) releases of MySQL

awesome-mysql / Connectors
ballerinax/mysql 113 about 1 month ago Official Ballerina connector for MySQL
DBD::MariaDB 33 about 1 month ago MariaDB and MySQL driver for the Perl5 Database Interface
DBD::mysql 63 about 1 month ago MySQL driver for the Perl5 Database Interface
go-sql-driver 14,580 about 2 months ago a lightweight and fast MySQL-Driver for Go's (golang) database/sql package
libAttachSQL 30 over 4 years ago libAttachSQL is a lightweight, non-blocking C API for MySQL servers
MariaDB Connector/J 341 about 1 month ago LGPL-licensed MariaDB Client Library for Java Applications
mex-mariadb 2 about 2 years ago MIT licensed MariaDB/MySQL Client Library for GNU Octave and Matlab
MySQL C API Official C driver for MySQL
MySQL Connector/C++ 639 3 months ago Official C/C++ driver for MySQL
MySQL Connector/J 925 3 months ago a standardized database driver for the Java platforms and development
MySQL Connector/NET 295 about 1 month ago a standardized database driver for .Net platforms and development
MySQL Connector/Node.js 156 3 months ago Official Node.js driver for MySQL
MySQL Connector/Python 882 3 months ago a standardized database driver for Python platforms and development
mysqlclient-python 2,461 about 1 month ago MySQL database connector for Python
node-mysql A pure Nodejs Javascript client implementing the MySQL protocol
PHP mysqlnd MySQL native driver for PHP
PyMySQL 7,689 about 2 months ago MySQL database connector for Python
Ruby Mysql2 gem 2,253 about 1 month ago MySQL driver for Ruby and Rails projects
MyZql 33 3 months ago MySQL and MariaDB driver in native Zig

awesome-mysql / Deployment
dbdeployer 707 about 1 year ago (archived) - A tool that installs one or more MySQL servers within seconds, easily, securely, and with full control
MariaDB4j 854 about 1 month ago A Java launcher to run MariaDB without installation or external dependencies
MySQL Docker Official Docker images

awesome-mysql / Development
Flywaydb 8,342 about 1 month ago Database migrations; Evolve your database schema easily and reliably across all your instances
Liquibase 4,793 about 1 month ago Source control for your database
Shift 735 over 1 year ago An application that helps you run schema migrations on MySQL databases
Skeema 1,273 about 1 month ago Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools
SQLE 1,457 about 1 month ago SQLE is a SQL audit platform for DBA or developer
Test database 4,109 5 months ago A sample MySQL database with an integrated test suite, used to test applications and servers

awesome-mysql / GUI
Adminer 6,283 8 months ago Database management in a single PHP file
DBeaver 40,942 about 1 month ago A cross-platform SQL and NoSQL database client
HeidiSQL 4,863 about 1 month ago MySQL GUI frontend for Windows
ILLA Cloud 11,712 about 1 month ago Low-code internal tool builder integrated with Mysql, can be used as GUI for Mysql
mycli 11,513 about 1 month ago A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting
MySQL Shell 195 3 months ago 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 907 3 months ago provides DBAs and developers an integrated tools environment for database design & modeling; SQL devleopment; database administration
Ocelot GUI 62 3 months ago GUI client for MySQL or MariaDB, including debugger
OmniDB: Web tool for database management 3,195 almost 2 years ago
Percona Monitoring and Management 688 about 1 month ago An open-source platform for managing and monitoring MySQL performance
phpMyAdmin 7,307 about 1 month ago a free software tool written in PHP, intended to handle the administration of MySQL over the Web
pspg 2,517 4 months ago provides a pager with enhanced visualization and navigation for tabular data. Originally implemented for PostgreSQL, but also supports MySQL
Sequel Ace 6,776 about 2 months ago a Mac database management application for working with MySQL databases
SQLyog Community edition 2,216 6 months ago SQLyog Community edition. For Windows, works fine under wine in Mac and Linux
WebDB 192 about 1 month ago – 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

awesome-mysql / HA
Galera Cluster 452 about 2 months ago a true Multimaster Cluster based on synchronous replication
mha4mysql-node 404 almost 5 years ago and (both unmaintained) - Master High Availability Manager and tools for MySQL
Orchestrator 5,645 6 months ago MySQL replication topology management and High Availability solution
Percona Replication Manager 3 about 2 months ago Asynchronous MySQL replication manager agent for Pacemaker. Supports file and GTID based replication, geo-distributed clusters using booth
replication-manager 662 about 1 month ago a high availability solution to manage MariaDB 10.x and MySQL & Percona Server 5.7 GTID replication topologies

awesome-mysql / Proxy
MySQL Proxy 421 over 9 years ago (deprecated) - A simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication
MySQL Router MySQL Router is part of InnoDB cluster, and is a lightweight middleware that provides transparent routing between your application and back-end MySQL Servers
ProxySQL 6,077 about 1 month ago High performance proxy for MySQL

awesome-mysql / Replication
data-diff 2,949 8 months ago Command-line tool and Python library to efficiently diff rows across two different databases

awesome-mysql / Schema
common_schema 130 almost 5 years ago DBA's framework for MySQL, providing a function library, views library and QueryScript interpreter
sys 828 over 2 years ago A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage

awesome-mysql / Security
Acra 1,368 4 months ago SQL database protection suite: strong selective encryption, SQL injections prevention, intrusion detection system

awesome-mysql / Server
MariaDB 5,752 about 1 month ago Community developed fork of MySQL server
MySQL Server & MySQL Cluster 10,964 3 months ago Official Oracle's MySQL server & MySQL Cluster distribution
Percona Server 1,164 about 1 month ago An enhanced, drop-in MySQL replacement
TiDB 37,447 about 1 month ago A distributed HTAP database compatible with the MySQL protocol

awesome-mysql / Sharding
Jetpants 1,135 over 7 years ago An automation suite for managing large range sharding clusters, by Tumblr
Vitess 18,777 about 1 month ago vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services

awesome-mysql / Toolkits
gh-ost 12,468 about 1 month ago GitHub's online schema migration for MySQL
go-mysql 4,630 about 1 month ago A pure go library to handle MySQL network protocol and replication
MySQL Utilities 269 over 5 years ago (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
Percona Toolkit 1,190 about 1 month ago 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
UnDROP 389 over 1 year ago a tool to recover data from dropped or corrupted InnoDB tables

Resources / e-books
Database Systems Lecture Notes lecture notes on Database Systems (available in pdf, html, odt and markdown) including a Chapter on SQL that covers basic set-up, exercises and problems
SQL-exercise 1,352 about 1 year ago contains several SQL exercises, including the schema description figure, SQL code to build schema, questions and solutions in SQL. Based on wikibook

Backlinks from these awesome lists:

More related projects: