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 INTEGER            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 TEXT           Password to connect to the database
  --pass TEXT                   Password to connect to the database
  -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
  --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