Mycli is a modern alternative to the default MySQL client. This tool does to MySQL what bpython does to the standard Python REPL. Mycli will auto-complete keywords, table names, columns, and functions as you type them.

The completion suggestions are context-sensitive. For example, after the SELECT * FROM, only tables from the current database are listed in the completion, rather than every possible keyword under the sun.

1. install some packages:

apt-get install python3-click -y
Code language: Bash (bash)

2. now to install the software

apt-get install mycli -y
Code language: Bash (bash)