Alternatives to mycli

A command-line MySQL client with auto-completion, syntax highlighting and fuzzy history search. The listings below can replace it for an important use case. Each note says what changes if you switch.

Replacements

Listings that take over the same core job as mycli.

  • usql

    Use one command-line interface for many database systems.

    FreeOpen sourceWindowsmacOSLinux

    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.

    FreeOpen sourceCommand line

    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.

    FreeOpen sourceWindowsmacOSLinux

    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.

    FreeOpen sourceWindowsmacOSLinux

    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.

    FreeOpen sourceWindowsmacOSLinuxCommand line

    Harlequin is a full terminal SQL IDE with adapters for Postgres, SQLite, DuckDB and more, installed through Python.

Similar software

Related functionality, not a direct replacement.