mycli is a command line interface for MySQL which includes auto-completion and syntax highlighting.

Read the install instructions to find out how to get the latest version.

Mycli v2.0.0 has breaking changes!

Major features added in recent months include

• powerful fuzzy history search with fzf (thanks lazmond3!)
• integrated LLMs with the /llm command
• shell-like query-result redirection with trailing $| and $> operators
• system keyring support for saving passwords
• improved batch execution with checkpoint/resume and progress/eta indicator
• many completion improvements, such as leveraging foreign keys (thanks scottnemes!)
• fuzzy completion/correction with RapidFuzz
• SSL modernization (thanks scottnemes!)