mycli
Rich MySQL terminal client with auto-completion, syntax highlighting, and dataframes.
Homepage: https://mycli.net
Documentation: https://mycli.net/docs
Mycli is known to be compatible with
Postgres equivalent
Release 2.x
Release 2.0.0 has breaking changes!
Quick Start
If you already know how to install Python packages, then you can install mycli
via pip. This package is always up to date.
You might need sudo on Linux.
pip install --upgrade 'mycli[all]'
or, on macOS (pygments is optional but recommended):
brew update && brew install mycli pygments
or, on Debian or Ubuntu (fzf and pygments are optional but recommended):
sudo apt-get install mycli fzf python3-pygments
Usage
See
mycli --help
Features
- Auto-completion as you type for SQL keywords as well as tables, views, columns, enums, and more!
- Fuzzy history search using fzf.
- Output explorer using fzf or other tools.
- 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 positional or named parameters using Jinja. Save a query using
/fs <alias> <query>and execute it with/f <alias>or/f <alias> --key=value. - Timing of sql statements and table rendering.
- Log every query and its results to a file (disabled by default).
- Pretty print tabular data with colors.
- Support for SSL connections.
- Shell-style trailing redirects with
$>,$>>and$|operators. - Polars dataframe transforms and plots with
.|, and Parquet saves with.>. - Support for querying LLMs with context derived from your schema using
/llm. - Support for storing passwords in the system keyring.
- Integrations with: SSH, Kubernetes, Vault, and Boundary.
Mycli creates a config file ~/.myclirc on the 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.
Contributions
If you're interested in contributing to this project, first of all we would like to extend our heartfelt gratitude. We've written a small doc to describe how to get mycli running in a development setup.
https://github.com/dbcli/mycli/blob/main/CONTRIBUTING.md
Additional Install Instructions
Shell Completions
If installed via Homebrew, shell completions may already be configured.
Otherwise, to configure shell completions for the current session, execute a command like this:
eval "$(mycli --completions SHELL)"
replacing SHELL with bash, zsh, or fish, depending on your choice of
shell.
To permanently install shell completions, the above command may be added to your
~/.bashrc, ~/.zshrc, or ~/.config/fish/config.fish. To speed up login
time, the output of mycli --completions SHELL may be saved to a file and
loaded with source.
Alternative Install Methods
These are some alternative ways to install mycli that are not managed by our team but provided by OS package maintainers. OS packages could be considerably out of date.
If present, the fzf package can be used for fuzzy history search, and as an
output "explorer" with the \x special command. pygmentize can be used for
syntax highlighting within the fuzzy history search. The less package is
also expected, but almost always already installed.
Arch, Manjaro
You can install the mycli package available in the AUR. fzf and
python-pygments are optional but recommended:
yay -S mycli fzf python-pygments
Debian, Ubuntu
On Debian and Ubuntu distributions, you can easily install the mycli package
using apt. The fzf and python3-pygments packages are optional but
recommended:
sudo apt-get install mycli fzf python3-pygments
Fedora
Fedora has a package available for mycli; install it using dnf. The fzf and
python-pygments packages are optional but recommended:
sudo dnf install mycli fzf python-pygments
Docker
The images on Dockerhub are out of date. ghcr.io is preferred. Example:
docker run -it ghcr.io/dbcli/mycli:latest mycli --help
Windows
Option 1: Native Windows
Install the less pager, for example by scoop install less.
Install the fzf fuzzy finder, for example by scoop install fzf.
Follow the instructions on this blog post: https://web.archive.org/web/20221006045208/https://www.codewall.co.uk/installing-using-mycli-on-windows/
The libraries used in mycli are Windows-compatible, but there are known limitations according to the test suite. The basics work without any modifications, but this configuration isn't supported software at this time.
PRs to address shortcomings on Windows would be welcome!
Option 2: WSL
Mycli is more compatible with WSL than with native Windows, though still not 100% perfect. This is a good option for using mycli on Windows.
With WSL, you are probably using an Ubuntu distribution, in which case recommended dependencies can be installed by
sudo apt-get install fzf python3-pygments
and mycli can be installed by apt-get or by pip (recommended):
pip install --upgrade 'mycli[all]'
PRs to complete WSL support would be welcome!
Thanks
This project was funded through Kickstarter. Our thanks to the backers who supported the project.
A special thanks to Jonathan Slenders for creating Python Prompt Toolkit, which is quite literally the backbone library, that made this app possible. Jonathan has also provided valuable feedback and support during the development of this app.
Click is used for command line option parsing and printing error messages.
Thanks to PyMysql for a pure Python adapter to MySQL databases.
Compatibility
Mycli is tested on macOS (full), Linux (full), Windows (partial), and WSL (partial), and requires Python 3.10 or better.
To connect to MySQL versions earlier than 5.5, you may need to set the
following in ~/.myclirc:
[connection]
# character set for connections without --charset being set at the CLI
default_character_set = utf8
or use --charset=utf8 when invoking mycli.
Configuration and Usage
For more information on using and configuring mycli, check out our documentation.
Common topics include:
2 maintainers
Release files for mycli 2.22.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| mycli-2.22.0.tar.gz | 835.9 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| mycli-2.22.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 1.0 MB
Release files / mycli-2.22.0.tar.gz
| Download URL | mycli-2.22.0.tar.gz |
|---|---|
| Size | 835.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
30d7c1a3537db17efb9d0c5ad9df7c1d78bf23011ee9daae320301a7b0c65bbd
|
|
BLAKE2b-256 checksum How to use checksums |
df148564d0cf6ea5737ad128fdcf59996a96aeaa0dca6dd7f4e58b92a4a3a838
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 9, 2026.
Transparency logRelease files / mycli-2.22.0-py3-none-any.whl
| Download URL | mycli-2.22.0-py3-none-any.whl |
|---|---|
| Size | 186.4 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
7db42ffd92e2c342547e3c089cb3e000afb49a5148fbce34e06fc0448ce66876
|
|
BLAKE2b-256 checksum How to use checksums |
55b665a881f9aae12df5d0f37cfaaedab5463eaf5378ed4ee72b36b2088a126b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 9, 2026.
Transparency log
