MyCLI: A MySQL CLI with Auto-completion and Syntax Highlighting

MyCLI: A MySQL CLI with Auto-completion and Syntax Highlighting

If 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.”


Image Credit: mycli.net

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.

The author Thomas Roten has released other similar CLI tools like pgcli for PostgreSQL and litecli for SQLite. You can find the collection of them at www.dbcli.com.

Filed in: Development Tools / MySQL

Newsletter

Join 31,000+ others and never miss out on new tips, tutorials, and more.

Laravel News Partners

Laravel Jobs

Senior Fullstack Developer / Architect (w/m/d)
Remote / Munich - Germany
envivo.select GmbH
Medior full stack developer (Laravel)
Deventer (or remote) in the Netherlands, Dutch speaking required.
MSML B.V.
Senior Full Stack PHP Developer (Laravel)
Remote
MAPPEN
Senior Laravel Developer
Remote
ACTO
Senior Full-Stack Engineer
[REMOTE: USA Only]
Curricula