"Six months ago, everyone was talking about MCPs. And I was like, screw MCPs. Every MCP would be better as a CLI."

— Peter Steinberger, Founder of OpenClaw Watch on YouTube (~2:39:00) | Lex Fridman Podcast #491

Amazon Athena CLI

Production-ready CLI for the Amazon Athena Query API. Run SQL queries and manage databases and workgroups directly from your terminal.

Installation

npm install -g @ktmcp-cli/awsathena

Configuration

awsathena config set accessKeyId YOUR_AWS_ACCESS_KEY_ID
awsathena config set secretAccessKey YOUR_AWS_SECRET_ACCESS_KEY
awsathena config set region us-east-1

Usage

Queries

# Run a SQL query
awsathena queries run --sql "SELECT * FROM my_table LIMIT 10" --database my_db --output s3://my-bucket/results/

# Check query status
awsathena queries get <execution-id>

# List recent queries
awsathena queries list
awsathena queries list --workgroup primary

# Stop a running query
awsathena queries stop <execution-id>

# Get query results
awsathena queries results <execution-id>
awsathena queries results <execution-id> --limit 100

Databases

# List all databases
awsathena databases list
awsathena databases list --catalog AwsDataCatalog

# Get database details
awsathena databases get my_database

# Create a database
awsathena databases create new_database --output s3://my-bucket/results/

Workgroups

# List workgroups
awsathena workgroups list

# Get workgroup details
awsathena workgroups get primary

# Create a workgroup
awsathena workgroups create my-team --description "My team workgroup" --output s3://my-bucket/results/

JSON Output

All commands support --json:

awsathena queries get <id> --json
awsathena databases list --json | jq '.[].Name'
awsathena queries results <id> --json

License

MIT