A curated list of awesome frameworks, libraries, tools, and resources for MySQL, a popular open-source relational database management system.
- Libraries and Clients
- GUI Tools
- Backup and Migration
- Optimization and Monitoring
- Replication and Clustering
- Learning Resources
- Books
- Community
- Contribute
- License
- MySQL Connector/J - The official JDBC driver for MySQL, providing Java connectivity.
- MySQL Connector/Python - The official MySQL driver for Python.
- Sequelize - A Node.js ORM for MySQL, PostgreSQL, SQLite, and MSSQL.
- SQLAlchemy - A Python SQL toolkit and Object-Relational Mapping (ORM) library that supports MySQL.
- mysql2 - A fast, modern MySQL client for Node.js.
- Django MySQL - Extensions for integrating MySQL with the Django web framework.
- MySQL Workbench - The official MySQL GUI for designing, developing, and managing MySQL databases.
- phpMyAdmin - A popular web-based MySQL administration tool.
- DBeaver - A free, universal database tool that supports MySQL and other databases.
- HeidiSQL - A lightweight and fast MySQL GUI client for Windows.
- DataGrip - A powerful database IDE by JetBrains, supporting MySQL and other databases.
- mysqldump - The built-in MySQL backup tool for exporting databases.
- Percona XtraBackup - A free and open-source hot backup utility for MySQL.
- MyDumper - A high-performance MySQL backup tool.
- Flyway - A database migration tool that supports MySQL and other databases.
- Liquibase - An open-source database schema change management tool.
- MySQLTuner - A script that provides performance tuning recommendations for MySQL.
- Percona Toolkit - A set of advanced command-line tools for MySQL, including query optimization.
- pg_chameleon - A tool for replicating MySQL databases into PostgreSQL.
- PMM (Percona Monitoring and Management) - A comprehensive monitoring tool for MySQL.
- Zabbix - An open-source monitoring software that can track MySQL performance metrics.
- MySQL Replication - The official MySQL documentation on replication for setting up master-slave architectures.
- Galera Cluster - A synchronous multi-master cluster for MySQL.
- Percona XtraDB Cluster - A high availability and high scalability solution for MySQL.
- ProxySQL - A high-performance MySQL proxy for connection pooling, load balancing, and query routing.
- Vitess - A database clustering system for horizontal scaling of MySQL.
- MySQL Documentation - The official MySQL reference documentation.
- MySQL Tutorial - A comprehensive guide to MySQL, including queries, functions, and administration.
- Leetcode: MySQL Problems - Practice SQL queries with MySQL challenges on Leetcode.
- Learn MySQL in 10 Minutes - Quick exercises for learning MySQL basics.
- SQLZoo - An interactive platform for practicing SQL queries, including MySQL.
- High Performance MySQL by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko - A comprehensive guide to MySQL performance tuning.
- Learning MySQL by Seyed M.M. Hosseini and Vinicius M. Grippa - A beginner’s guide to mastering MySQL.
- MySQL Cookbook by Paul DuBois - A collection of practical MySQL solutions and examples.
- SQL Antipatterns by Bill Karwin - A guide to avoiding common SQL and database design mistakes.
- SQL Performance Explained by Markus Winand - A book focused on optimizing SQL queries.
- MySQL Forums - The official MySQL community forum.
- Stack Overflow: MySQL - A Q&A site for MySQL-related questions.
- Reddit: r/MySQL - A subreddit for MySQL discussions and questions.
- Planet MySQL - A blog aggregator for MySQL-related posts and updates.
- Slack: MySQL Community - A Slack group for MySQL discussions (invitation may be required).
Contributions are welcome. Please ensure your submission fully follows the requirements outlined in CONTRIBUTING.md, including formatting, scope alignment, and category placement.
Pull requests that do not adhere to the contribution guidelines may be closed.