On the recordRead 8 Oct 202614 facts
mycli
Plans and prices
mycli
Free
Open-source command-line MySQL client
Read 8 Oct 2026 · mycli.net
On the record
- Autocomplete
- It provides context-sensitive auto-completion for SQL statements.mycli.net · read 8 Oct 2026
- Connection security
- The default SSL mode prefers SSL for TCP/IP connections but can fall back to cleartext; server certificate verification is disabled by default.mycli.net · read 8 Oct 2026
- Credential storage
- It can store and retrieve passwords using the system keyring, but keyring use is disabled by default.mycli.net · read 8 Oct 2026
- Database compatibility
- It is compatible with MySQL, MariaDB, Percona, TiDB, and Apache Doris.mycli.net · read 8 Oct 2026
- Dependencies
- A pager such as less is essentially required; fzf is optional and recommended for fuzzy history search.mycli.net · read 8 Oct 2026
- History search
- It supports fuzzy history search, for which fzf is recommended but not required.mycli.net · read 8 Oct 2026
- Installation
- The maker recommends installing with pip or, on macOS, Homebrew.mycli.net · read 8 Oct 2026
- LLM support
- LLM support is available as an optional extra installed with the [all] package option.mycli.net · read 8 Oct 2026
- Output
- Batch and execute output can use default, CSV, TSV, or table formats.mycli.net · read 8 Oct 2026
- Product
- mycli is a command-line interface for MySQL.mycli.net · read 8 Oct 2026
- Query editing
- It supports multi-line SQL input, with a semicolon required to end statements when multi-line mode is enabled.mycli.net · read 8 Oct 2026
- Safety
- The default configuration enables warnings before potentially destructive SQL statements such as DROP, DELETE, or TRUNCATE.mycli.net · read 8 Oct 2026
- Supported systems
- The project is tested on macOS and Linux, runs on Python 3.10 or later, and has known limitations on Windows and WSL.mycli.net · read 8 Oct 2026
- Windows limitation
- Native Windows basics work, but the maker says this configuration is not supported software at this time.mycli.net · read 8 Oct 2026
