Skip to main content

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

2.6k
GitHub Stars
106
Curated Resources
21
Categories
6 hours ago
Last Refreshed
AnalysisBackupBenchmarkingBinlog-ReplicationChatOpsConfigurationConnectorsDeploymentDevelopmentGUIHAMCPProxyReplicationSchemaSecurityServerShardingToolkitse-booksIncubating

Use this list with your AI agent

Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:

"Show me security resources from awesome-mysql"

Installation instructions →

What's inside

Security

  • Acra

    SQL database protection suite: strong selective encryption, SQL injections prevention, intrusion detection system.

  • myanon

    Streaming 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.

  • myldapsync

    Synchronize MySQL or MariaDB users with users in an LDAP directory.

GUI

  • Adminer

    Database management in a single PHP file.

  • DBeaver

    A cross-platform SQL and NoSQL database client.

  • HeidiSQL

    MySQL GUI frontend for Windows.

  • ILLA Cloud

    Low-code internal tool builder integrated with Mysql, can be used as GUI for Mysql.

  • 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.

Analysis

  • Anemometer

    Box SQL slow query monitor.

  • Dolphie

    a modern terminal tool for real-time analytics into MySQL/MariaDB & ProxySQL

  • 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

  • mysql-statsd

    A Python daemon to collect information from MySQL and send it via StatsD to Graphite.

Connectors

  • 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.

Schema

  • common_schema

    DBA's framework for MySQL, providing a function library, views library and QueryScript interpreter.

  • sys

    A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage. See

Development

  • cover_me

    code coverage tool for mysql stored procedures and functions

  • dbsafe

    Pre-execution safety analysis for MySQL DDL/DML operations

  • Flywaydb

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

  • 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

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

    contains several SQL exercises, including the schema description figure, SQL code to build schema, questions and solutions in SQL. Based on wikibook

Backup

  • 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.

Showing a sample of 106 resources. View the full list on GitHub →