mycli is a MySQL command line client, database administration tool, and SQL query editor. It functions as a terminal interface for executing queries and managing MySQL connections, incorporating an integrated assistant that uses large language models to generate and analyze SQL statements based on the current database schema.
The tool provides specialized query authoring capabilities, including context-sensitive syntax suggestions, fuzzy-matching identifier completion for tables and columns, and the ability to handover query buffers to external system text editors. It distinguishes its connectivity through SSH tunneling to remote servers and the use of system-native keyrings for encrypted credential management.
Broad capabilities include batch query execution with session persistence, database activity logging for auditing, and the redirection of result sets via shell-style operators. The interface supports formatted tabular output, custom prompt styling, and the management of favorite queries with positional parameters.