mycli — New command line interface for MySQL


mycli is a new command line interface tool for MySQL. It features syntax highlighting and auto-completion of commands plus the ability edit commands with Emacs or VI.

So who could benefit from mycli? If you need prompting to complete commands, fat finger as you type, or just want to add some color highlights as you work with your MySQL server then try mycli. Screenshot of mycli

You can even save save favorite queries. So if you have Python on your system and are looking for a new command line tool please take a look at mycli.

2 Responses to mycli — New command line interface for MySQL

  1. I noticed that mycli behaves better than the regular mysql client when dealing with multibyte characters and characters with a width of 0 or 2. (CJK and combining characters)
    Also with “\T fancy_grid” it will use unicode drawing symbols (similar to https://bugs.mysql.com/bug.php?id=77279 )
    It will also switch to using less as a pager when the output doesn’t fit the screen.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s