SQL

MySQL Shell – advanced client and administration console

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
DBeaverUniversal database tool
phpMyAdminMySQL web administration tool
MySQL WorkbenchComplete visual database design tool
mycliCommand line interface for MySQL, MariaDB, and Percona
gh-ostGitHub's Online Schema Migrations for MySQL
Beekeeper Studio Cross-platform SQL editor and database manager
usqlCommand-line database client
sqlitlazygit of SQL databases
MySQLTunerAnalyse MySQL performance and suggest configuration changes
HarlequinEasy, fast, and beautiful database client for the terminal
DbGateDatabase manager for MySQL, PostgreSQL, MongoDB
Percona ToolkitEssential command-line utilities for MySQL
SQuirreL SQL ClientGraphical SQL client written in Java
AdminerFull-featured tool for managing content in MySQL database
dblabInteractive client for PostgreSQL, MySQL, SQLite3, and more
MyDumperParallel utilities for fast MySQL database backups and restores
AntaresSQL client based on Electron.js and Vue.js
XtraBackupBackup utility for MySQL
innotopReal-time, advanced investigation tool
SkeemaManage MySQL and MariaDB schema changes
vi-sqlTerminal SQL client for browsing, querying and editing databases
MySQL ShellAdvanced MySQL console for scripting and database administration
SequelerNative Linux SQL client built in Vala and Gtk

Read our verdict in the software roundup.


Best Free and Open Source Software LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.

We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more.

Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion.

Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted