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 Quality Assurance Engineer
Remote
Bisnow Media
Senior PHP/Laravel Developer: Your Dream Work Environment
Remote
iPhone Photography School
Senior Software Engineer
Remote or San Francisco
Curology
Laravel Developer
Las Vegas, NV
V Shred
R&D Developer
Denver, CO
booj
Full-Stack Developer
Paris, France
Wingly
Full Stack Developer
Remote US-Only
atlasMind