The new shell

The new MySQL shell, also known as Mysqlsh, is a new CLI but with a lot of horsepower. It has three modes - Structured Query Language, JavaScript, and Python. So if you have libraries in either of the two latter languages, you can use them from the shell. Plus, you can save scripts for later use.

There is a parallel bulk loader that can import CSV, TSV, and JSON data extremely quickly included in the built-in utilities. There is also an upgrade checker that can help you update from MySQL 5.7 to 8.0, which will point out conflicts with reserved words and other potential problems.

As an added bonus, there is a vastly expanded help command and command completion.