athena

Name: athena
Availability: InStock
Author: David

Run SQL queries against S3 data using Amazon Athena.

3|Updated Mar 16, 2026

Search Tags:#aws #sql #s3 #athena #query-history #workgroups #named-queries

Ready to run

npx skills add https://github.com/david-2814/claw-aws --skill athena

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: athena
Source: https://github.com/david-2814/claw-aws/tree/main/skills/athena
Command: npx skills add https://github.com/david-2814/claw-aws --skill athena

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyzing large datasets stored in S3 can be cumbersome without a scalable, serverless SQL engine. This skill enables executing SQL queries against S3 data using Amazon Athena, managing workgroups, saved queries, and query history to streamline analytics workflows.

Core Features & Use Cases

Interactive SQL querying against data in S3 using Athena.
Manage workgroups, stored queries, and query history for repeatable analytics.
Use case: quickly validate data patterns or generate insights across multiple datasets with minimal setup.

Quick Start

Install and configure AWS CLI, then run an Athena query against a sample dataset to verify connectivity and performance.

Frequently Asked Questions about athena

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run SQL queries against S3 data using Amazon Athena?▼

To run SQL queries against S3 data using Amazon Athena, you need AWS CLI v2 with configured IAM permissions for Athena, S3, and Glue, plus a Glue Data Catalog to manage table schemas for serverless querying.

Can I manage Athena workgroups and query history for multi-user environments?▼

Yes, you can manage Athena workgroups and query history for multi-user environments. Workgroups enable governance and control over query execution, while query history tracks analytics workflows for repeatable insights.

What AWS IAM permissions do I need to query S3 with Athena?▼

Querying S3 with Athena requires IAM permissions for the Athena service, S3 storage, and Glue Data Catalog. AWS CLI v2 must be installed and configured to authenticate requests for scalable, serverless SQL analytics.

How do I save and reuse SQL queries in Athena?▼

You can save and reuse SQL queries in Athena by creating named queries. This feature streamlines repeatable analytics workflows, allowing you to quickly validate data patterns or generate insights across multiple datasets.

What is the best way to validate data patterns stored in S3?▼

The best way to validate data patterns in S3 is using Athena for interactive SQL querying. This serverless approach requires minimal setup, leveraging a Glue Data Catalog to quickly generate insights across large datasets.

Do I need a Glue Data Catalog to run Athena queries on S3?▼

Yes, a configured Glue Data Catalog is required to run Athena queries on S3. It provides the table schema definitions necessary for Athena to execute SQL-based analytics against your raw data stored in S3.