mycli

mycli is a modern command-line interface for MySQL databases that significantly enhances the traditional MySQL client experience with intelligent auto-completion and syntax highlighting. Built using Python's prompt_toolkit, it provides context-aware completions that understand SQL syntax - for example, suggesting only table names after FROM clauses and only column names in WHERE conditions.

The tool offers a rich set of features designed to improve database productivity, including multiline query support, favorite query management with parameterization, query timing, and pretty-printed tabular output with colors. It automatically creates a configuration file for customization and supports advanced features like SSL connections, shell-style output redirection, and comprehensive logging of queries and results.

mycli is ideal for database administrators, developers, and anyone who frequently works with MySQL databases from the command line. It serves as a drop-in replacement for the standard MySQL client while providing a significantly more user-friendly and efficient experience. The tool is cross-platform, running on macOS and Linux, and requires Python 3.10 or later.

Installation

# via pip
pip install -U 'mycli[all]'

# via Homebrew
brew install mycli

# via apt
sudo apt-get install mycli