MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.

Quick Start

If you already know how to install python packages, then you can simply do:

$ pip install mycli

If you're on OS X you can install it via homebrew.

$ brew update && brew install mycli

If you're having trouble with the quick start, check the install page for detailed instructions.


 $ mycli --help
 Usage: mycli [OPTIONS] [DATABASE]

-h, --host TEXT               Host address of the database.
-P, --port TEXT               Port number to use for connection. Honors
-u, --user TEXT               User name to connect to the database.
-S, --socket TEXT             The socket file to use for connection.
-p, --password                Force password prompt.
--pass TEXT                   Password to connect to the database
--ssl-ca PATH                 CA file in PEM format
--ssl-capath TEXT             CA directory
--ssl-cert PATH               X509 cert in PEM format
--ssl-key PATH                X509 key in PEM format
--ssl-cipher TEXT             SSL cipher to use
--ssl-verify-server-cert      Verify server's "Common Name" in its cert
                              against hostname used when connecting. This
                              option is disabled by default
-v, --version                 Version of mycli.
-D, --database TEXT           Database to use.
-R, --prompt TEXT             Prompt format (Default: "\t \u@\h:\d> ")
-l, --logfile FILENAME        Log every query and its results to a file.
--defaults-group-suffix TEXT  Read config group with the specified suffix.
--defaults-file PATH          Only read default options from the given file
--auto-vertical-output        Automatically switch to vertical output mode
                              if the result is wider than the terminal
-t, --table                   Display batch output in table format.
--warn / --no-warn            Warn before running a destructive query.
--local-infile BOOLEAN        Enable/disable LOAD DATA LOCAL INFILE.
--login-path TEXT             Read this path from the login file.
--help                        Show this message and exit.


$ mycli local_database

$ mycli -h localhost -u root app_db

$ mycli mysql://amjith@localhost:3306/django_poll




jweiland Tech Blue Software