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: almost 2 years ago
Linked from 9 awesome lists


awesome-mysql / Analysis

Anemometer1,389almost 5 years agoBox SQL slow query monitor
innodb-ruby1,695almost 2 years agoA parser for InnoDB file formats, in Ruby
innotop766almost 2 years agoa 'top' clone for MySQL with many features and flexibility
MySQL Explain Analyzer93over 3 years agoA web-based analyzer of output, providing comments, scalability analysis and permalinks for saved samples
mysql-statsd99over 5 years agoA Python daemon to collect information from MySQL and send it via StatsD to Graphite
MySQLTuner-perl9,011almost 2 years agoA script that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability
Prometheus56,244almost 2 years ago/ - Time series database for real-time monitoring and alerting
pstop206almost 2 years agoa top-like program for MySQL, collecting, aggregating and displaying information from performance_schema
Wiresharka protocol analyzer that can decode the MySQL protocol
Dolphie688almost 2 years agoa modern terminal tool for real-time analytics into MySQL/MariaDB & ProxySQL

awesome-mysql / Backup

Dumpling37,447almost 2 years agoLogical, parallel backup/dumper tool for MySQL/TiDB written in GoLang - support csv format output and integrated as library
MyDumper2,567almost 2 years agoLogical, parallel backup/dumper tool for MySQL
Percona Xtrabackup1,313almost 2 years agoan open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup

awesome-mysql / Benchmarking

go-tpc184about 2 years agoA golang port of and benchmark for MySQL
iibench-mysql46almost 9 years agoJava based version of the Index Insertion Benchmark for MySQL/Percona/MariaDB
Sysbench6,174about 2 years agoa modular, cross-platform and multi-threaded benchmark tool
TPCC-MySQL481over 8 years ago(archived) - A port of the popular benchmark for MySQL

awesome-mysql / Binlog-Replication

DM431almost 2 years agoA High-Availability data migration platform which supports migrating data from MySQL/MariaDB to TiDB and merging shard tables
Kingbus889over 5 years agoA distributed MySQL binlog storage system built on Raft
mysql-ripple374over 5 years ago(archived) - Ripple, a server that can serve as a middleman in MySQL replication

awesome-mysql / ChatOps

Hubot MySQL ChatOps90over 12 years ago

awesome-mysql / Configuration

mysql-compatibility-config94over 9 years agomake MySQL configuration behave more like newer (or older) releases of MySQL

awesome-mysql / Connectors

ballerinax/mysql113almost 2 years agoOfficial Ballerina connector for MySQL
DBD::MariaDB33almost 2 years agoMariaDB and MySQL driver for the Perl5 Database Interface
DBD::mysql63almost 2 years agoMySQL driver for the Perl5 Database Interface
go-sql-driver14,580almost 2 years agoa lightweight and fast MySQL-Driver for Go's (golang) database/sql package
libAttachSQL30about 6 years agolibAttachSQL is a lightweight, non-blocking C API for MySQL servers
MariaDB Connector/J341almost 2 years agoLGPL-licensed MariaDB Client Library for Java Applications
mex-mariadb2almost 4 years agoMIT licensed MariaDB/MySQL Client Library for GNU Octave and Matlab
MySQL C APIOfficial C driver for MySQL
MySQL Connector/C++639almost 2 years agoOfficial C/C++ driver for MySQL
MySQL Connector/J925almost 2 years agoa standardized database driver for the Java platforms and development
MySQL Connector/NET295almost 2 years agoa standardized database driver for .Net platforms and development
MySQL Connector/Node.js156almost 2 years agoOfficial Node.js driver for MySQL
MySQL Connector/Python882almost 2 years agoa standardized database driver for Python platforms and development
mysqlclient-python2,461almost 2 years agoMySQL database connector for Python
node-mysqlA pure Nodejs Javascript client implementing the MySQL protocol
PHP mysqlndMySQL native driver for PHP
PyMySQL7,689almost 2 years agoMySQL database connector for Python
Ruby Mysql2 gem2,253almost 2 years agoMySQL driver for Ruby and Rails projects
MyZql33almost 2 years agoMySQL and MariaDB driver in native Zig

awesome-mysql / Deployment

dbdeployer707almost 3 years ago(archived) - A tool that installs one or more MySQL servers within seconds, easily, securely, and with full control
MariaDB4j854almost 2 years agoA Java launcher to run MariaDB without installation or external dependencies
MySQL DockerOfficial Docker images

awesome-mysql / Development

Flywaydb8,342almost 2 years agoDatabase migrations; Evolve your database schema easily and reliably across all your instances
Liquibase4,793almost 2 years agoSource control for your database
Shift735over 3 years agoAn application that helps you run schema migrations on MySQL databases
Skeema1,273almost 2 years agoDeclarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools
SQLE1,457almost 2 years agoSQLE is a SQL audit platform for DBA or developer
Test database4,109about 2 years agoA sample MySQL database with an integrated test suite, used to test applications and servers

awesome-mysql / GUI

Adminer6,283over 2 years agoDatabase management in a single PHP file
DBeaver40,942over 1 year agoA cross-platform SQL and NoSQL database client
HeidiSQL4,863almost 2 years agoMySQL GUI frontend for Windows
ILLA Cloud11,712almost 2 years agoLow-code internal tool builder integrated with Mysql, can be used as GUI for Mysql
mycli11,513almost 2 years agoA Terminal Client for MySQL with AutoCompletion and Syntax Highlighting
MySQL Shell195almost 2 years agoAdvanced 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 Workbench907almost 2 years agoprovides DBAs and developers an integrated tools environment for database design & modeling; SQL devleopment; database administration
Ocelot GUI62almost 2 years agoGUI client for MySQL or MariaDB, including debugger
OmniDB: Web tool for database management3,195over 3 years ago
Percona Monitoring and Management688almost 2 years agoAn open-source platform for managing and monitoring MySQL performance
phpMyAdmin7,307almost 2 years agoa free software tool written in PHP, intended to handle the administration of MySQL over the Web
pspg2,517almost 2 years agoprovides a pager with enhanced visualization and navigation for tabular data. Originally implemented for PostgreSQL, but also supports MySQL
Sequel Ace6,776almost 2 years agoa Mac database management application for working with MySQL databases
SQLyog Community edition2,216about 2 years agoSQLyog Community edition. For Windows, works fine under wine in Mac and Linux
WebDB192almost 2 years 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 Cluster452almost 2 years agoa true Multimaster Cluster based on synchronous replication
mha4mysql-node404over 6 years agoand (both unmaintained) - Master High Availability Manager and tools for MySQL
Orchestrator5,645about 2 years agoMySQL replication topology management and High Availability solution
Percona Replication Manager3almost 2 years agoAsynchronous MySQL replication manager agent for Pacemaker. Supports file and GTID based replication, geo-distributed clusters using booth
replication-manager662over 1 year agoa high availability solution to manage MariaDB 10.x and MySQL & Percona Server 5.7 GTID replication topologies

awesome-mysql / Proxy

MySQL Proxy421about 11 years ago(deprecated) - A simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication
MySQL RouterMySQL Router is part of InnoDB cluster, and is a lightweight middleware that provides transparent routing between your application and back-end MySQL Servers
ProxySQL6,077almost 2 years agoHigh performance proxy for MySQL

awesome-mysql / Replication

data-diff2,949over 2 years agoCommand-line tool and Python library to efficiently diff rows across two different databases

awesome-mysql / Schema

common_schema130over 6 years agoDBA's framework for MySQL, providing a function library, views library and QueryScript interpreter
sys828about 4 years agoA collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage

awesome-mysql / Security

Acra1,368about 2 years agoSQL database protection suite: strong selective encryption, SQL injections prevention, intrusion detection system

awesome-mysql / Server

MariaDB5,752almost 2 years agoCommunity developed fork of MySQL server
MySQL Server & MySQL Cluster10,964almost 2 years agoOfficial Oracle's MySQL server & MySQL Cluster distribution
Percona Server1,164almost 2 years agoAn enhanced, drop-in MySQL replacement
TiDB37,447almost 2 years agoA distributed HTAP database compatible with the MySQL protocol

awesome-mysql / Sharding

Jetpants1,135over 9 years agoAn automation suite for managing large range sharding clusters, by Tumblr
Vitess18,777almost 2 years agovitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services

awesome-mysql / Toolkits

gh-ost12,468almost 2 years agoGitHub's online schema migration for MySQL
go-mysql4,630almost 2 years agoA pure go library to handle MySQL network protocol and replication
MySQL Utilities269almost 7 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 Toolkit1,190over 1 year agoa 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
UnDROP389about 3 years agoa tool to recover data from dropped or corrupted InnoDB tables

Resources / e-books

Database Systems Lecture Noteslecture 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-exercise1,352almost 3 years agocontains 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: