AthenaCLI

A terminal client for Amazon Athena with SQL completion and syntax highlighting.

Read the AthenaCLI documentation

View the AthenaCLI source code

Alternatives

About AthenaCLI

AthenaCLI provides a command line interface for running SQL queries against Amazon Athena. Its interactive shell includes syntax highlighting, context aware completion for tables and columns, and formatted query results.

It requires AWS credentials, a region, an S3 staging directory and a workgroup. Queries run against the Athena service, with results staged in S3.

Strengths

  • Completes SQL keywords, tables and columns
  • Highlights syntax and formats query results
  • Supports saved queries and aliases

Limitations

  • Requires AWS credentials and an Amazon Athena service connection

Details

Pricing
FreeThe AthenaCLI client is free and open source under the BSD-3-Clause license; AWS Athena usage may incur charges.
License
BSD-3-Clause
Developer
The dbcli contributors
Platforms
Command line
How it runs
Downloadable app
Account
Required
Works offline
No
Best suited for
AWS Athena users who prefer running queries from a terminal
Last verified
Added
Provenance
Selected from the Homebrew formula

Report a wrong fact or a dead link on this listing