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 the weekly newsletter and never miss out on new tips, tutorials, and more.

Laravel News Partners

Laravel Jobs

Senior PHP/Laravel Developer: Your Dream Work Environment
Remote
iPhone Photography School
In-house Laravel Developer.
Gold Coast / Australia
MXstore
Laravel Developer
Oak Brook, IL
Tidal Commerce
Senior Backend Engineer
Santa Monica only
Saatchi Art
Senior Laravel Developer
San Francisco
Stitch Labs
Senior Software Developer
South Jordan, UT
Lendio
Full-Stack Developer
Paris, France
Wingly