mycli

A command‑line client for MySQL provides interactive features such as auto‑completion of SQL keywords, tables, views, and columns, as well as syntax highlighting powered by Pygments. It offers context‑aware suggestions, fuzzy history search via fzf, and support for multiline queries, allowing users to construct and edit statements efficiently. The tool formats query results in colored tables, logs statements optionally, and can time executions.

Developers and database administrators can store favorite queries with aliases, use positional parameters, and redirect output with shell‑style operators. Additional capabilities include SSL connections, password storage in the system keyring, and experimental integration for querying large language models using schema‑derived context. Configuration is managed through a user‑specific file created on first run, and many features are accessible via key bindings.

The client is built on the Python prompt toolkit and Click for option parsing, and uses PyMySQL as a pure‑Python MySQL driver. It runs on macOS and Linux with Python 3.10 or newer, and can be installed via pip, Homebrew, apt, dnf, or other package managers. Windows support is unofficial, but the underlying libraries are compatible.