mycli
A command-line interface for MySQL with auto-completion, syntax highlighting, fuzzy search
mycli is a command-line interface for MySQL-compatible databases, including MySQL, MariaDB, Percona, TiDB, and Apache Doris. It provides an alternative to the default mysql shell, with features such as auto-completion for SQL keywords, tables, views, and columns, syntax highlighting via Pygments, fuzzy history search using fzf, multiline queries, named favorite queries with positional parameters, query logging, pretty-printed tabular output, SSL connections, shell-style trailing redirects, and LLM querying with schema context.
It also supports smart context-sensitive completion, statement timing, password storage in the system keyring, and configuration through a ~/.myclirc file. Installation is available via pip or Homebrew, with fzf and Pygments as optional but recommended dependencies. The tool offers batch and execute modes, output formats including table, CSV, and TSV, checkpoint and resume for batch scripts, and various connection and SSL options. It is open source, with source code and a bug tracker hosted on GitHub.
5 alternatives to mycli
Ranked by how well each tool replaces mycli: shared features, audience, price and popularity.
A free software tool written in PHP for administering MySQL and MariaDB over the web.
Covers 0 of 15 key features and has a free plan.
Free planOpen source61 out of 100 matchFreeA command line interface for Postgres with auto-completion and syntax highlighting.
Covers 3 of 15 key features.
Open source60 out of 100 match—Get started with MongoDB using Studio 3T Community Edition, your free starter tool
Covers 1 of 15 key features and has a free plan.
Free plan52 out of 100 matchContact sales- 51 out of 100 match—