Beekeeper Studio From $9/mo · Free plan 9.4 Visit mycli
mycli.net
Spec sheet
- Product
- mycli is a command-line interface for MySQL.Read 8 Oct 2026 · mycli.net
- Autocomplete
- It provides context-sensitive auto-completion for SQL statements.Read 8 Oct 2026 · mycli.net
- 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.Read 8 Oct 2026 · mycli.net
- Credential storage
- It can store and retrieve passwords using the system keyring, but keyring use is disabled by default.Read 8 Oct 2026 · mycli.net
- Database compatibility
- It is compatible with MySQL, MariaDB, Percona, TiDB, and Apache Doris.Read 8 Oct 2026 · mycli.net
- Dependencies
- A pager such as less is essentially required; fzf is optional and recommended for fuzzy history search.Read 8 Oct 2026 · mycli.net
- History search
- It supports fuzzy history search, for which fzf is recommended but not required.Read 8 Oct 2026 · mycli.net
- Installation
- The maker recommends installing with pip or, on macOS, Homebrew.Read 8 Oct 2026 · mycli.net
- LLM support
- LLM support is available as an optional extra installed with the [all] package option.Read 8 Oct 2026 · mycli.net
- Output
- Batch and execute output can use default, CSV, TSV, or table formats.Read 8 Oct 2026 · mycli.net
- Query editing
- It supports multi-line SQL input, with a semicolon required to end statements when multi-line mode is enabled.Read 8 Oct 2026 · mycli.net
- Safety
- The default configuration enables warnings before potentially destructive SQL statements such as DROP, DELETE, or TRUNCATE.Read 8 Oct 2026 · mycli.net
- 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.Read 8 Oct 2026 · mycli.net
- Windows limitation
- Native Windows basics work, but the maker says this configuration is not supported software at this time.Read 8 Oct 2026 · mycli.net
Plans and prices
mycli Free Open-source command-line MySQL client Read 8 Oct 2026 · mycli.net
Where Specifiction places it
- Database Client Software#28 of 537.7
- SQL Query Tools#18 of 317.7
Alternatives to mycliAll alternatives →
Beekeeper Studio From $9/mo · Free plan 9.4 Visit 
MySQL Free plan 9.0 Visit 
Outerbase Studio From $9/mo · Free plan 8.9 Visit 
CloudBeaver From $85.42/mo · Free plan 8.7 Visit