mycli

mycli is a command-line interface for MySQL and compatible databases including MariaDB, Percona, TiDB, and Apache Doris. It enhances the standard terminal experience with several productivity features: - Smart Auto-completion: Provides context-sensitive suggestions for SQL keywords, tables, views, columns, and enums. - Visual Enhancements: Includes syntax highlighting via Pygments and pretty-printed tabular data with colors. - Search and Navigation: Supports fuzzy history search and output exploration using fzf. - Query Management: Supports multiline queries and favorite queries with positional or named parameters using Jinja. - Data Processing: Integrates Polars for dataframe transforms, plots, and Parquet exports. - Advanced Integration: Supports querying LLMs with schema-derived context and storing passwords in the system keyring. - Connectivity: Supports SSL connections and shell-style trailing redirects ($>, $>>, $|).