Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

mycli

mycli.net

  • Free plan
  • Windows
  • macOS
  • Linux
7.3 Club score Visit mycli.net

What mycli is

mycli is a free command-line interface for MySQL-compatible databases on Linux, macOS, and Windows. It works with MySQL, MariaDB, Percona, TiDB, and Apache Doris. SQL entry provides context-sensitive completion and multi-line editing; in multi-line mode, a semicolon ends a statement. Fuzzy history search helps locate earlier queries, with fzf recommended but optional. Batch and execute output can use default, CSV, TSV, or table formats. The default configuration warns before potentially destructive commands such as DROP, DELETE, and TRUNCATE. Passwords can be stored and retrieved through the system keyring, although that function starts disabled. For TCP/IP connections, the default SSL mode prefers SSL but may fall back to cleartext, and server certificate verification is disabled by default. The project runs on Python 3.10 or later and is tested on macOS and Linux. Installation is recommended through pip or Homebrew on macOS. A pager such as less is essentially required, and optional LLM support comes with the all package option.

Who it suits

mycli suits developers and database administrators who prefer terminal-based SQL work across supported database systems. Linux and macOS users are the primary supported audience; Windows and WSL have stated limitations.

Good to know, and what to watch

  • Works with five listed database systems
  • Context-sensitive SQL auto-completion
  • Fuzzy query-history search
  • CSV, TSV, table, and default output
  • Warnings before destructive SQL
  • Windows configuration is not supported software
  • WSL has known limitations
  • Server certificates are not verified by default
  • A pager such as less is essentially required

mycli

Free

Free plan

The verdict

mycli provides focused terminal SQL editing, history search, output choices, and safety warnings at no cost. Its strongest support is on macOS and Linux, while Windows, WSL, pager requirements, and default connection settings need attention.

What the maker publishes

Autocomplete
It provides context-sensitive auto-completion for SQL statements. source
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. source
Credential storage
It can store and retrieve passwords using the system keyring, but keyring use is disabled by default. source
Database compatibility
It is compatible with MySQL, MariaDB, Percona, TiDB, and Apache Doris. source
Dependencies
A pager such as less is essentially required; fzf is optional and recommended for fuzzy history search. source
History search
It supports fuzzy history search, for which fzf is recommended but not required. source
Installation
The maker recommends installing with pip or, on macOS, Homebrew. source
LLM support
LLM support is available as an optional extra installed with the [all] package option. source
Output
Batch and execute output can use default, CSV, TSV, or table formats. source
Product
mycli is a command-line interface for MySQL. source
Query editing
It supports multi-line SQL input, with a semicolon required to end statements when multi-line mode is enabled. source
Safety
The default configuration enables warnings before potentially destructive SQL statements such as DROP, DELETE, or TRUNCATE. source
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. source
Windows limitation
Native Windows basics work, but the maker says this configuration is not supported software at this time. source

Checked against the maker's pages on 8 Oct 2026.