# Install mycli with Homebrew, apk, apt, dnf, MacPorts, Nix CLI for MySQL with auto-completion and syntax highlighting. Version 2.9.0 via Homebrew; verified 2026-08-01. Also installable with debian: sudo apt install mycli. ## Install ```sh sudo av install brew:mycli ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install mycli ``` Evidence: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install mycli ``` Evidence: MacPorts ports tree: databases/mycli/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - apk (92%): ```sh sudo apk add mycli ``` Evidence: Alpine Linux edge package indexes: mycli from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz - Debian apt (92%): ```sh sudo apt install mycli ``` Evidence: Debian stable package indexes: mycli from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz - dnf (92%): ```sh sudo dnf install mycli ``` Evidence: Fedora Rawhide package metadata: mycli from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst - Nix (92%): ```sh nix profile install nixpkgs#mycli ``` Evidence: nixpkgs package indexes: pkgs/by-name/my/mycli/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:mycli - **Package manager:** Homebrew - **Version:** 2.9.0 - **Source summary:** CLI for MySQL with auto-completion and syntax highlighting - **Homepage:** - **Last updated:** 2026-08-01T19:23:45Z - **Generated:** 2026-08-03T19:37:03+00:00 ## Executables - mycli (alias) ## Install behavior - Bottle: not available ## Freshness - Page generated: 2026-08-03 - Package-manager version: 2.9.0 ## 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 Notes 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. ## 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 - Unix: ~/.myclirc, ~/.config/mycli/myclirc ## Credential files - Unix: ~/.myclirc, ~/.config/mycli/myclirc ## Other Package-Manager Records - Debian apt - mycli - 1.31.2-1: normalized package name match | Debian stable package indexes: mycli from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | CLI for MySQL/MariaDB with auto-completion and syntax highlighting | https://www.mycli.net - Nix - mycli: normalized package name match | nixpkgs package indexes: pkgs/by-name/my/mycli/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - Ubuntu apt - mycli - 1.27.0-1: normalized package name match | Ubuntu 24.04 LTS package indexes: mycli from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | CLI for MySQL/MariaDB with auto-completion and syntax highlighting | https://www.mycli.net - apk - mycli - 1.66.0-r0: normalized package name match | Alpine Linux edge package indexes: mycli from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | MySQL CLI with autocompletion and syntax highlighting | https://www.mycli.net/ - apk - mycli-pyc - 1.66.0-r0: normalized package name match | Alpine Linux edge package indexes: mycli-pyc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | Precompiled Python bytecode for mycli | https://www.mycli.net/ - dnf - mycli - 1.66.0-4.fc45: normalized package name match | Fedora Rawhide package metadata: mycli from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Interactive CLI for MySQL Database with auto-completion and syntax highlighting | https://mycli.net - dnf - python3-mycli+llm - 1.66.0-4.fc45: normalized package name match | Fedora Rawhide package metadata: python3-mycli+llm from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Metapackage for python3-mycli: llm extras | https://mycli.net - dnf - python3-mycli+ssh - 1.66.0-4.fc45: normalized package name match | Fedora Rawhide package metadata: python3-mycli+ssh from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Metapackage for python3-mycli: ssh extras | https://mycli.net - MacPorts - mycli: normalized package name match | MacPorts ports tree: databases/mycli/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ## Combined YAML source View the package source record on GitHub. [combined/mycli.yml](https://github.com/mxcl/pkgdb/blob/main/combined/mycli.yml) ## Sources - pkg.so package database - Geiger risk classifier - curated configuration and credential file locations - curated package history - pkgdb category and tag curation - external package-manager database matches - cross-ecosystem install command graph