Top Open-Source MySQL Tools Every DBA Should Know

Mycli

Mycli is a BSD‑3‑licensed command‑line client for MySQL that provides interactive auto‑completion, syntax highlighting, and multi‑line query editing. It highlights functions and operators inside WHERE clauses, making complex JOIN statements easier to read. Color schemes are configurable, and the intelligent completion engine suggests table and column names after a few characters, reducing the need to remember exact identifiers. Repository: https://github.com/dbcli/mycli

Gh‑ost (GitHub Online Schema Migration)

Gh‑ost is an MIT‑licensed tool that performs online schema changes for MySQL without blocking writes. It reads the binary log (ROW format) from a replica, replays the events on a shadow table, and swaps the tables atomically once the shadow table catches up. Because it avoids triggers, there is no write amplification or metadata lock contention. The migration can be paused and resumed, and it can be run directly on the primary or on a replica for testing. Typical command‑line usage:

gh-ost \
  --user=root \
  --password=secret \
  --host=replica-host \
  --database=mydb \
  --table=orders \
  --alter="ADD COLUMN status VARCHAR(20) NOT NULL" \
  --allow-on-master \
  --verbose

Repository: https://github.com/github/gh-ost

phpMyAdmin

phpMyAdmin is a GPL‑v2‑licensed web application for managing MySQL databases. It allows browsing and editing of databases, tables, views, columns, and indexes; exporting data in many formats; managing users and privileges; and executing ad‑hoc SQL queries through a browser interface. The project is actively maintained and can be deployed from the source repository or via standard package managers.

Repository: https://github.com/phpmyadmin/phpmyadmin

Sqlcheck

Sqlcheck is an Apache‑2.0‑licensed static analysis tool that scans SQL files for anti‑patterns. It classifies findings into four categories—logical database design, physical database design, query issues, and application‑development concerns—and rates each issue as low, medium, or high risk. To use the tool, place the SQL statements in a file (e.g., queries.sql) and run:

sqlcheck -f queries.sql -c config.yaml

The output groups issues by risk level, helping DBAs prioritize performance‑critical problems.

Repository: https://github.com/jarulraj/sqlcheck

Orchestrator

Orchestrator is an Apache‑2.0‑licensed high‑availability management system for MySQL replication topologies. It discovers the replication graph, visualizes master‑slave relationships, and provides a drag‑and‑drop GUI for topology reconfiguration, including safe replica promotion. In failure scenarios, Orchestrator selects an appropriate recovery method and orchestrates primary failover automatically.

Repository: https://github.com/github/orchestrator

Percona Monitoring and Management (PMM)

PMM is an open‑source monitoring platform that integrates several tools—including Orchestrator—to provide metrics, dashboards, and alerts for MySQL, MariaDB, and MongoDB servers. It can be deployed via Docker or binary packages and connects to the monitored instances using standard exporters.