macOS
Homebrewverified · 100%
brew install myclilocal Homebrew formula metadata
MacPortsverified · 94%
sudo port install mycliMacPorts ports tree · databases/mycli/Portfile · source: api.github.com
brew
Install mycli with Homebrew, apk, apt, dnf, MacPorts, Nix
CLI for MySQL with auto-completion and syntax highlighting. Version 2.0.0 via Homebrew; verified 2026-07-04.
install
Additional install commands
Linux
Alpine Linux apkverified · 92%
sudo apk add mycliAlpine Linux edge package indexes · mycli · source: dl-cdn.alpinelinux.org
Debian aptverified · 92%
sudo apt install mycliDebian stable package indexes · mycli · source: deb.debian.org
Fedora dnfverified · 92%
sudo dnf install mycliFedora Rawhide package metadata · mycli · source: dl.fedoraproject.org
Nixverified · 92%
nix profile install nixpkgs#myclinixpkgs package indexes · pkgs/by-name/my/mycli/package.nix · source: api.github.com
overview
Package summary
CLI for MySQL with auto-completion and syntax highlighting
Project links
Commands and aliases
- mycli
history
Project history and usage
mycli is a modern terminal client for MySQL-family databases created in the dbcli ecosystem. Amjith Ramanujam introduced the project in 2015 as mysql-cli, a MySQL counterpart to pgcli, and funded the initial work through a Kickstarter campaign. The DBCLI project later grouped mycli with related command-line database clients such as pgcli and mssql-cli.
Project history
The project README defines mycli as a MySQL command-line client with auto-completion and syntax highlighting, compatible with MySQL, MariaDB, Percona, TiDB, and Apache Doris. Its practical appeal is in interactive database work: context-sensitive completion for SQL keywords and schema objects, Pygments-based highlighting, multiline queries, favorite queries, query timing, formatted table output, SSL support, keyring-backed password storage, and a ~/.myclirc configuration file.
How it is used
mycli's adoption is visible both in its GitHub footprint and its packaging spread: it is installable through pip, Homebrew, Debian/Ubuntu, Fedora, and other distribution channels. Its package-manager niche is the friendlier drop-in terminal client for developers and DBAs who still want a shell workflow but prefer completion and display ergonomics closer to newer REPLs.
Sources
security posture
No protected-tool coverage found yet
No matching local secret-handling manifest was found for mycli. Nucleus package metadata is still published here so future coverage has a stable package URL.
Install behavior
- No Homebrew post-install hook is recorded in formula metadata.
- Homebrew bottle metadata is available for 6 platform targets.
- Installs with 5 runtime dependencies.
- Build metadata lists 1 build dependencies.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
local files
Configuration and credential file locations
These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.
Configuration files
Config paths the tool may read or write during local use.
- Unix
~/.myclirc~/.config/mycli/myclirc
Credential files
Credential-bearing paths to review before unattended agent runs.
- Unix
~/.myclirc~/.config/mycli/myclirc
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
mycli | cli | global executable |
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-07-08
manager version2.0.0
manager updated2026-07-04
local dataok
upstreamnot checked
latest detectednot detected
- infoRelease/tag comparison is only available for GitHub repositories.https://www.mycli.net/none confidence
install metadata
Package metadata
| Package key | brew:mycli |
|---|---|
| Version | 2.0.0 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/mycli |
| Homepage | https://www.mycli.net/ |
| Repository | https://github.com/dbcli/mycli |
| Upstream docs | https://www.mycli.net/docs |
| License | BSD-3-Clause |
| Source archive | https://files.pythonhosted.org/packages/a0/12/51a3f9e14bf6ed514153de115aabb3a629e5fae3ba8b27eb808ee5c0e430/mycli-2.0.0.tar.gz |
| Last updated | 2026-07-04T23:22:13Z |
| Pulse | updated |
| Dependencies | certifi, cryptography, libyaml, pydantic, python@3.14 |
| Build dependencies | rust |
| Uses from macOS | libffi |
| Bottle | available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | not defined |
| Service | none declared |
registry facts
Source database details
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | mycli |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
source database matches
Other package-manager records
Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.
Debian apt95%
mycli 1.31.2-1
CLI for MySQL/MariaDB with auto-completion and syntax highlighting
sudo apt install mycli- Section: database
- Architecture: all
- 14 dependencies
- normalized package name match
- Matched by: Mycli
Nix95%
mycli
nix profile install nixpkgs#mycli- normalized package name match
- Matched by: Mycli
Ubuntu apt95%
mycli 1.27.0-1
CLI for MySQL/MariaDB with auto-completion and syntax highlighting
sudo apt install mycli- Section: universe/database
- Architecture: all
- 15 dependencies
- normalized package name match
- Matched by: Mycli
apk95%
mycli 1.66.0-r0
MySQL CLI with autocompletion and syntax highlighting
sudo apk add mycli- License: BSD-3-Clause
- Architecture: x86_64
- Source Package: mycli
- 1 dependencies
- 1 provides
- normalized package name match
- Matched by: Mycli
apk95%
mycli-pyc 1.66.0-r0
Precompiled Python bytecode for mycli
sudo apk add mycli-pyc- License: BSD-3-Clause
- Architecture: x86_64
- Source Package: mycli
- 1 dependencies
- normalized package name match
- Matched by: Mycli
dnf95%
mycli 1.66.0-3.fc45
Interactive CLI for MySQL Database with auto-completion and syntax highlighting
sudo dnf install mycli- License: LicenseRef-Callaway-BSD
- Category: Unspecified
- Architecture: noarch
- Source Package: mycli
- 3 dependencies
- 6 provides
- normalized package name match
- Matched by: Mycli
dnf95%
python3-mycli+llm 1.66.0-3.fc45
Metapackage for python3-mycli: llm extras
sudo dnf install python3-mycli+llm- License: LicenseRef-Callaway-BSD
- Category: Unspecified
- Architecture: noarch
- Source Package: mycli
- 3 dependencies
- 5 provides
- normalized package name match
- Matched by: Mycli
dnf95%
python3-mycli+ssh 1.66.0-3.fc45
Metapackage for python3-mycli: ssh extras
sudo dnf install python3-mycli+ssh- License: LicenseRef-Callaway-BSD
- Category: Unspecified
- Architecture: noarch
- Source Package: mycli
- 3 dependencies
- 5 provides
- normalized package name match
- Matched by: Mycli
MacPorts95%
mycli
sudo port install mycli- normalized package name match
- Matched by: Mycli
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- Geiger risk classifier
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated configuration and credential file locations
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment