mycli
A command-line MySQL client with auto-completion, syntax highlighting and fuzzy history search.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
1 more ways to get mycli
Package managers
- Homebrew
brew install mycli
About mycli
mycli is a terminal client for MySQL that adds auto-completion, syntax highlighting, fuzzy history search and LLM support to the interactive prompt. It works with MySQL, MariaDB, Percona, TiDB and Apache Doris, and accepts connection details as options or as a mysql:// URL.
It installs with pip or Homebrew; fzf is recommended for fuzzy history search, and the less pager is required. Release 2.0.0 includes breaking changes, so check the changelog when upgrading. It suits anyone who queries MySQL-compatible databases from the terminal.
Strengths
- Auto-completion and syntax highlighting for SQL
- Fuzzy history search with fzf
- Works with MySQL, MariaDB, Percona, TiDB and Apache Doris
Limitations
- Terminal only, no graphical interface
- Version 2.0.0 introduced breaking changes
Details
- Pricing
- FreeFree and open source.
- License
- Open source, license not stated
- Developer
- The DBCLI contributors
- Platforms
- Command line
- How it runs
- Downloadable app
- Account
- Not required
- Best suited for
- Querying MySQL and MariaDB from the terminal
- Categories
- CLI tools, Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to mycli
Compare allSoftware that can replace mycli for an important use case, and what changes if you switch.
usql
Use one command-line interface for many database systems.
usql provides one command-line interface for MySQL and many other databases, though driver availability and feature support vary by database.
dblab
An open-source terminal UI client for browsing and querying PostgreSQL, MySQL, SQLite and other databases.
dblab is a terminal UI client for browsing and querying MySQL, PostgreSQL and SQLite, with saved connection configs, rather than a line-based prompt with fuzzy history.
LazySQL
Browse and query databases through a terminal interface.
LazySQL offers a cross-platform terminal interface for browsing tables as well as querying, but the project describes itself as alpha software.
rainfrog
Query databases through a terminal editor with history and favorites.
rainfrog is a terminal query editor with history, favorites and table inspection, though its database drivers vary in support and stability.
Harlequin
A SQL IDE that runs in the terminal, with adapters for DuckDB, SQLite, Postgres and more.
Harlequin is a full terminal SQL IDE with adapters for Postgres, SQLite, DuckDB and more, installed through Python.
Similar software
Related functionality, not necessarily a direct replacement.
pgcli
A command-line PostgreSQL client with auto-completion and syntax highlighting.
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
MySQL Workbench
Oracle's desktop application for developing SQL, administering MySQL servers and analysing query performance.
MyDumper
A multi-threaded command-line tool for logical backup and restore of MySQL and MariaDB databases.
Sequel Ace
A free, open-source macOS app for managing and querying MySQL and MariaDB databases.
HeidiSQL
A long-running Windows client for MariaDB, MySQL, SQL Server, PostgreSQL, SQLite and Firebird, small and quick.
