Manage your database with mycli (MySQL & MariaDB)

MyCLI is a control tool for MySQL & MariaDB allowing auto-completion and help to syntax of your SQL command.

Installation

We install management tools of Python packages in order to use pip then we install mycli :


Use

We connect to MySQL via mycli through one of these following methods :

From mycli view, any SQL requests will be highlighted and auto-completed even if there is a syntax error (as ; final).

Auto-completion operates with key words and SQL functions, names from data base and tables.

Alias can be handled as well as the columns of your tables if it is specified like the following example :

The result of your requests is identically shaped as the command less :