{"repo":"dbcli/athenacli","free":true,"listed":false,"github":"https://github.com/dbcli/athenacli","clone":"git clone https://github.com/dbcli/athenacli.git","description":"AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting.","language":"Python","stars":228,"topics":["aws-cli","athena-cli","aws-athena","python","bigdata","syntax-highlighting","autocompletion","cli","command-line"],"license":"BSD-3-Clause","category":"cli-tools","readme_excerpt":"Introduction AthenaCLI is a command line interface (CLI) for the Athena service that can do auto-completion and syntax highlighting, and is a proud member of the dbcli community. Quick Start Install Install via pip If you already know how to install python packages, then you can simply do: Install via brew Homebrew users can install by: If you don't know how to install python packages, please check the Install page for more options (e.g docker) Config A config file is automatically created at /.athenacli/athenaclirc at first launch (run athenacli). See the file itself for a description of all available options. Below 4 variables are required. If you are a user of aws cli, you can refer to awsconfig file to see how to reuse credentials configuration of aws cli. or you can also use environment variables: Create a table You can find examples/create table.sql here. Run a query REPL Features - Auto-completes as you type for SQL keywords as well as tables and columns in the database. - Syntax highlighting. - Smart-completion will suggest context-sensitive completion. - SELECT FROM will only show table names. - SELECT FROM users WHERE will only show column names. - Pretty prints tabular data and various table formats. - Some special commands. e.g. Favorite queries. - Alias support. Column completions will work even when table names are aliased. Please refer to the Features page for the screenshots of above features. Usages Please go to the Usages for detailed information on how to u","default_branch":null,"files":null,"tree":[],"storefront":"/r/dbcli","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dbcli/athenacli/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}