mycli

A powerful command line client for MySQL that transforms your database workflow with intelligent autocompletion and syntax highlighting. As you type SQL queries, mycli suggests relevant keywords, table names, views, and columns based on your current context.

Key capabilities include:

• Context-aware autocompletion - Suggestions adapt to what you're typing (table names after FROM, column names after WHERE)
• Syntax highlighting - Color-coded SQL syntax for better readability using Pygments
• Fuzzy history search - Quickly find and reuse previous queries with fzf integration
• Multiline query support - Write complex queries across multiple lines
• Query timing and results - See execution time and beautifully formatted tabular output with colors
• Favorite queries - Save frequently used queries with optional parameters for quick execution
• SSL connection support - Secure connections to remote MySQL servers
• Shell-style redirects - Pipe query results using $>, $>>, and $| operators
• Password management - Store credentials securely in system keyring
• Query logging - Optional logging of all queries and results to file
• LLM integration - Query language models with schema context

Mycli works on macOS and Linux (Python 3.10+), with community support for various package managers including Homebrew, apt, dnf, and AUR. Configuration is handled through ~/.myclirc file created on first run, giving you fine-grained control over features and behavior.