# Install athenacli with Homebrew CLI tool for AWS Athena service. Version 1.7.0 via Homebrew; verified 2026-05-12. ## Install ```sh sudo av install brew:athenacli ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install athenacli ``` Evidence: local Homebrew formula metadata ## Package facts - **Package key:** brew:athenacli - **Package manager:** Homebrew - **Package manager page:** - **Version:** 1.7.0 - **Source summary:** CLI tool for AWS Athena service - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** BSD-3-Clause - **Source archive:** - **Last updated:** 2026-05-12T10:27:30Z - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - athenacli (cli) - athenacli (alias) ## Dependencies - python@3.14 ## Install behavior - Post-install hook: not defined - Bottle: available on all ## Freshness - Page generated: 2026-07-08 - Package-manager version: 1.7.0 - Package-manager updated: 2026-05-12 - Local data: ok - Upstream repository: https://athenacli.readthedocs.io/en/latest/ - info: Release/tag comparison is only available for GitHub repositories. ## Project history and usage AthenaCLI is a dbcli-style terminal client for Amazon Athena. It brings the pgcli/mycli interaction model--SQL completion, syntax highlighting, table-aware suggestions, favorite queries, and pretty tabular output--to AWS Athena users who prefer a local REPL over the AWS console. ### Project history The official README presents AthenaCLI as a command-line interface for AWS Athena and says it is a member of the dbcli community. Its credits are unusually explicit: the author thanks pgcli and mycli, says AthenaCLI was created based on a clone of mycli, and credits PyAthena as the pure-Python Athena adapter underneath the tool. That lineage explains the shape of the project. AthenaCLI is less an isolated AWS wrapper than a specialization of the Python prompt-toolkit/dbcli ecosystem for a cloud query service, keeping the familiar database-shell ergonomics while adding Athena-specific credentials, region, S3 staging directory, workgroup, and profile handling. ### Adoption history The README and install docs list pip, Docker, and Homebrew installation paths. In package-manager terms, this is a narrower project than ATF or Atlantis, but it still crossed the threshold from Python package to Homebrew formula, which is meaningful for data engineers who install query clients as ordinary command-line tools. The input confirms Homebrew packaging for the formula. No broad official downstream history was found beyond the project docs and repository tags, so adoption claims should stay modest. ### How it is used AthenaCLI can start an interactive REPL for an optional database name or execute SQL with -e and exit. The usage docs cover connecting with AWS credentials, region, S3 staging directory, workgroup, and AWS profile, while the README shows quick examples for creating a table, running a SELECT, and saving favorite queries. On first launch, AthenaCLI creates ~/.athenacli/athenaclirc. The README documents required AWS access key, secret key, region, S3 staging directory, and workgroup settings, and also documents environment-variable alternatives. ### Why package nerds care AthenaCLI is a good example of the dbcli pattern spreading beyond traditional databases. For package collectors, the interesting bit is the dependency stack and UX lineage: prompt-toolkit and mycli ideas repackaged for a serverless AWS SQL engine. It also shows why some data CLI tools carry credentials in their own rc files even when they can reuse AWS CLI-style environment variables or profiles. ### Timeline - Undated: AthenaCLI was created as a dbcli-community Athena client inspired by pgcli/mycli and based on a clone of mycli. - Undated: Official docs documented pip, Docker, and Homebrew installation paths. - Release tags: The official Git repository exposes tags from v0.1.1 through v1.7.0. ### Related projects - pgcli and mycli are direct UX and code-lineage influences. - PyAthena provides the Python Athena adapter credited by the project. - Amazon Athena is the target query service. ### Sources - - - ## Security Notes No matching local secret-handling manifest was found for athenacli. 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: ~/.athenacli/athenaclirc ## Credential files - Unix: ~/.athenacli/athenaclirc ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** athenacli - **Version Scheme:** 0 - **Revision:** 1 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## Related links - [Cloud CLI packages](https://www.automicvault.com/pkg/cloud-clis/) - Belongs to a cloud or infrastructure command family. - [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. - [python@3.14](https://www.automicvault.com/pkg/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [anyquery](https://www.automicvault.com/pkg/brew/anyquery/) - Shares av.db curated category or tags: cli, data, sql. - [apache-drill](https://www.automicvault.com/pkg/brew/apache-drill/) - Shares av.db curated category or tags: cli, data, sql. - [apgdiff](https://www.automicvault.com/pkg/brew/apgdiff/) - Shares av.db curated category or tags: cli, data, sql. - [beanquery](https://www.automicvault.com/pkg/brew/beanquery/) - Shares av.db curated category or tags: cli, data, sql. - [cql](https://www.automicvault.com/pkg/brew/cql/) - Shares av.db curated category or tags: cli, data, sql. - [csvq](https://www.automicvault.com/pkg/brew/csvq/) - Shares av.db curated category or tags: cli, data, sql. - [datafusion](https://www.automicvault.com/pkg/brew/datafusion/) - Shares av.db curated category or tags: cli, data, sql. - [dolt](https://www.automicvault.com/pkg/brew/dolt/) - Shares av.db curated category or tags: cli, data, sql. - [prestodb](https://www.automicvault.com/pkg/brew/prestodb/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, python, python-3-14, sql. - [adios2](https://www.automicvault.com/pkg/brew/adios2/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, python, python-3-14. ## Combined YAML source View the package source record on GitHub. [combined/athenacli.yml](https://github.com/automic-vault/db/blob/main/combined/athenacli.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 - cross-ecosystem install command graph