Skip to main content

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

2.6k
GitHub Stars
109
Curated Resources
21
Categories
5 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.

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

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 109 resources. View the full list on GitHub →