# 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 ```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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-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 - **Package manager page:** - **Version:** 2.0.0 - **Source summary:** CLI for MySQL with auto-completion and syntax highlighting - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** BSD-3-Clause - **Source archive:** - **Last updated:** 2026-07-04T23:22:13Z - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - mycli (cli) - mycli (alias) ## Dependencies - certifi - cryptography - libyaml - pydantic - python@3.14 ## Build dependencies - rust ## Uses from macOS - libffi ## Install behavior - Post-install hook: not defined - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-08 - Package-manager version: 2.0.0 - Package-manager updated: 2026-07-04 - Local data: ok - Upstream repository: https://www.mycli.net/ - info: Release/tag comparison is only available for GitHub repositories. ## 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 ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** mycli - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## 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-3.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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Interactive CLI for MySQL Database with auto-completion and syntax highlighting | https://mycli.net - dnf - python3-mycli+llm - 1.66.0-3.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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Metapackage for python3-mycli: llm extras | https://mycli.net - dnf - python3-mycli+ssh - 1.66.0-3.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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-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 ## Related links - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Networking and protocol packages](https://www.automicvault.com/pkg/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [Database and data packages](https://www.automicvault.com/pkg/database-data-tools/) - Matched database, SQL, migration, or data-store metadata. - [python@3.14](https://www.automicvault.com/pkg/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [rust](https://www.automicvault.com/pkg/brew/rust/) - Build dependency declared by Homebrew. - [percona-toolkit](https://www.automicvault.com/pkg/brew/percona-toolkit/) - Shares av.db curated category or tags: cli, data, mariadb, mysql, percona. - [dolphie](https://www.automicvault.com/pkg/brew/dolphie/) - Shares av.db curated category or tags: cli, data, mariadb, mysql. - [mysql-to-sqlite3](https://www.automicvault.com/pkg/brew/mysql-to-sqlite3/) - Shares av.db curated category or tags: cli, data, mariadb, mysql. - [mysqltuner](https://www.automicvault.com/pkg/brew/mysqltuner/) - Shares av.db curated category or tags: cli, data, mariadb, mysql. - [percona-server](https://www.automicvault.com/pkg/brew/percona-server/) - Shares av.db curated category or tags: cli, data, mysql, percona. - [skeema](https://www.automicvault.com/pkg/brew/skeema/) - Shares av.db curated category or tags: cli, data, mariadb, mysql. - [automysqlbackup](https://www.automicvault.com/pkg/brew/automysqlbackup/) - Shares av.db curated category or tags: cli, data, mysql. - [dumpling](https://www.automicvault.com/pkg/brew/dumpling/) - Shares av.db curated category or tags: cli, data, mysql. - [litecli](https://www.automicvault.com/pkg/brew/litecli/) - Local metadata places this package in an adjacent workflow. Shared terms: auto, auto-completion, autocomplete, certifi, cli. - [iredis](https://www.automicvault.com/pkg/brew/iredis/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, client, data, database, database-client. ## Combined YAML source View the package source record on GitHub. [combined/mycli.yml](https://github.com/automic-vault/db/blob/main/combined/mycli.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated configuration and credential file locations - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph