MySQL Shell is an advanced interactive client for developing, administering and maintaining MySQL systems. It goes considerably beyond the traditional command-line client by combining an interactive SQL environment with scripting interfaces and specialised administration APIs.
The shell can be used interactively by database administrators or incorporated into repeatable scripts. Its utilities cover common operational jobs such as copying databases, logical backups, restores, migration assessment and management of highly available deployments, making it suitable for both individual servers and more complex MySQL environments.
This is free and open source software.
Key Features
- Provides interactive SQL, JavaScript and Python execution modes from the same shell.
- Includes logical dump and load utilities for instances, schemas and individual tables.
- Uses multiple threads to improve backup, restore and copy performance.
- Can include or exclude selected database objects during data-transfer operations.
- Supports compression and checksums for dump and load workflows.
- Can copy database content directly between MySQL systems.
- Includes tools for assessing whether an installation is ready for an upgrade.
- Provides AdminAPI commands for configuring and managing InnoDB Cluster.
- Manages InnoDB ReplicaSet and ClusterSet deployments from an integrated administrative interface.
- Includes utilities for handling MySQL binary log backups and restoration workflows.
- Can work with cloud object storage when moving large database dumps.
- Provides facilities for migration to MySQL HeatWave environments.
- Includes management functions for MySQL REST Service configuration.
- Offers extensive built-in command and API help without requiring users to leave the shell.
Website: github.com/mysql/mysql-shell
Support:
Developer: Oracle and the MySQL team
License: GNU General Public License v2.0
MySQL Shell is written in C++. Learn C++ with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.