f you use the MySQL command line tool, but also like things like auto-completion and syntax highlighting, you should check out mycli.
According to the project’s website, “mycli is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.”
To get started you can install the tool with PIP, or if you’re on Mac, you can install it with Homebrew:
# You might need sudo pip install mycli # Or with Brew on OS X brew install mycli
The source code of MyCLI is Python, and you can check it out on GitHub at dbcli/mycli. Under the hood, I found that mycli uses an interesting Python library called prompt_toolkit, which is a library for building interactive command line applications with Python.