About

Mycli is maintained by a friendly bunch of more than 100 contributors.

Our founding author is Amjith Ramanujam.

Our lead maintainer is Roland Walker.

The goal of this project is to provide a user-friendly alternative to the default mysql shell.

Mycli supports

• Auto-completion as you type for SQL keywords as well as tables, views and columns in the database.
• Fuzzy history search using fzf.
• Syntax highlighting using Pygments.
• Smart-completion (enabled by default) will suggest context-sensitive completion.
  • SELECT * FROM <tab> will only show table names.
  • SELECT * FROM users WHERE <tab> will only show column names.
• Support for multiline queries.
• Favorite queries with optional positional parameters. Save a query using \fs <alias> <query> and execute it with \f <alias>.
• Timing of sql statements and table rendering.
• Logging every query and its results to a file (disabled by default).
• Pretty printing of tabular data (with colors!).
• Support for SSL connections.
• Shell-style trailing redirects with $>, $>> and $| operators.
• Support for querying LLMs with context derived from your schema.
• Support for storing passwords in the system keyring.

Mycli creates a config file ~/.myclirc on first run; you can use the options in that file to configure the above features, and more.

Some features are only exposed as key bindings.

Contact

Github - https://github.com/dbcli/mycli

Responsibilities

We will

• Be nice.
• Be courteous.
• Be respectful.
• Have an open mind.
• Never be condescending.
• Never discriminate (even if you like Emacs and Java).

If we ever fail one of the tenets above, please let us know.