Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Amazon Athena website screenshot

Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

agent ready

Real signal across most facets with visible, nameable gaps — the contract exists but is thin, or the portal is good while governance and commercial terms are absent.

Kin Score

API Evangelist profiles Amazon Athena the way a machine reads it — 340 machine-readable artifacts across 8 APIs, pulled from the provider's own public surface and indexed so a developer, an analyst, or an AI agent can evaluate it against every other provider on the network.

Every provider in the network is reduced to the same set of machine-readable artifacts — OpenAPI contracts, event specifications, GraphQL schemas, runnable collections, pricing and rate-limit signals, security posture, OAuth scopes, and the agent surfaces (MCP servers and skills) that let software drive the API on its own. We profile them because the interface is the part of a company you can actually inspect: it is a truer signal of what a provider does than any marketing page. From those artifacts we compute the Kin Score — Amazon Athena scores 47.3/100 (developing), with a separate agent-readiness read of 48/100 (agent ready). The full breakdown is below, followed by every artifact we hold — each card links through to its machine-readable definition on apis.io.

Kin Score

This is the API Evangelist rating — a single, repeatable read computed from the artifacts on this page. Green fill is points earned; the red track is points possible, so every bar shows earned-versus-possible at a glance.

Kin Score Kin Score How this is scored →
scored 2026-07-27 · rubric v0.5
Composite quality — 47.3/100 · developing
Contract Quality 19.0 / 25
Developer Ergonomics 2.2 / 20
Commercial Clarity 5.8 / 20
Operational Transparency 2.7 / 13
Governance 8.8 / 12
Discoverability 8.8 / 10
Agent readiness — 48/100 · agent ready
Machine-Readable Contract 18 / 18
Agentic Access Contract 15 / 15
MCP Server 0 / 12
Machine-Readable Auth 10 / 10
Idempotency 0 / 9
Stable Error Semantics 0 / 8
Request/Response Examples 0 / 7
Rate-Limit Signaling 7 / 7
Typed Event Surface 0 / 6
Agent Skills 0 / 5
Well-Known Catalog 0 / 4
Consent & Bot Identity 0 / 3

How we profile Amazon Athena

Each block below is one kind of artifact we hold for Amazon Athena. For each we say what it is and why it earns a place in the profile, then list every one we've indexed — capped at two rows, scroll within the panel for the rest.

APIs 8

Each API is captured as its own OpenAPI definition — every operation, parameter, and response. This is the single most useful machine-readable description of what an API does, and it's what lets us score, lint, mock, and generate against it without asking the provider for anything.

Individual APIs this provider publishes, each with its own machine-readable definition.

Amazon Athena Data Catalogs API

Operations for managing data catalogs

Amazon Athena Databases API

Operations for listing databases in a data catalog

Amazon Athena Named Queries API

Operations for creating and managing saved SQL queries

Amazon Athena Prepared Statements API

Operations for managing prepared SQL statements

Amazon Athena Query Executions API

Operations for running and managing SQL query executions

Amazon Athena Table Metadata API

Operations for listing and getting table metadata

Amazon Athena Tags API

Operations for managing resource tags

Amazon Athena Work Groups API

Operations for managing Athena work groups

Scroll within the panel for all 8 ·

Open Collections 1

Open, tool-agnostic collections carry the same runnable value as Postman without locking you to one client — the portable, forkable form of the same exercise.

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

Amazon Athena API

OPEN COLLECTION

Pricing Plans 1

Pricing is part of the interface. Machine-readable plans tell you what a tier costs and includes before you commit — one of the six things the Kin Score reads for commercial clarity.

Published pricing tiers and plan structures.

Rate Limits 1

Rate limits are the difference between a demo that works and a production integration that doesn't fall over. Publishing them is an operational-transparency signal — and a hard requirement for any agent that plans its own throughput.

Documented rate limits and quota policies.

Amazon Athena Rate Limits

2 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals let a buyer model the financial operations of an API before it's live. We profile them for the same reason we profile pricing: the money is part of the contract.

Cost, billing, and metering signals for API financial operations.

Features 10

The notable capabilities this provider advertises, captured as structured features so they can be searched and compared instead of read one landing page at a time.

Notable capabilities this provider offers.

Serverless SQL query execution against Amazon S3 data
Pay-per-query pricing with no infrastructure management
Support for standard ANSI SQL with complex joins and window functions
Integration with AWS Glue Data Catalog for schema management
Named queries for saving and reusing SQL statements
Work groups for query isolation and cost management
Prepared statements for parameterized query execution
Multiple data format support including Parquet, ORC, JSON, CSV
Query result caching for improved performance and cost reduction
Fine-grained access control with IAM and Lake Formation

Scroll within the panel for all 10 ·

Semantic Vocabularies 1

JSON-LD contexts give the data shared meaning across APIs. We profile them because semantics are what let a machine reconcile 'customer' here with 'customer' somewhere else.

JSON-LD contexts and semantic vocabularies used across these APIs.

Amazon Athena Context

11 classes · 0 properties

JSON-LD

Spectral Rules 2

Governance rulesets we run against this provider's specs — the automated checks behind parts of the score. Profiling them makes the quality bar explicit and re-runnable, not a matter of opinion.

Amazon Athena API Rules

6 rules · 5 warnings

SPECTRAL

Amazon Athena API Rules

26 rules · 13 errors · 13 warnings

SPECTRAL

JSON Schema 99

Standalone JSON Schema definitions describe the data models behind the API. We profile them so the shapes are validatable on their own — useful long after a single request is forgotten.

Standalone JSON Schema definitions for this provider's data models.

Amazon Athena Query Execution

11 properties

JSON SCHEMA

AthenaError

0 properties

JSON SCHEMA

BatchGetNamedQueryInput

0 properties

JSON SCHEMA

BatchGetNamedQueryOutput

0 properties

JSON SCHEMA

BatchGetQueryExecutionInput

0 properties

JSON SCHEMA

BatchGetQueryExecutionOutput

0 properties

JSON SCHEMA

ColumnInfo

0 properties

JSON SCHEMA

Column

0 properties

JSON SCHEMA

CreateDataCatalogInput

0 properties

JSON SCHEMA

CreateDataCatalogOutput

0 properties

JSON SCHEMA

CreateNamedQueryInput

0 properties

JSON SCHEMA

CreateNamedQueryOutput

0 properties

JSON SCHEMA

CreatePreparedStatementInput

0 properties

JSON SCHEMA

CreatePreparedStatementOutput

0 properties

JSON SCHEMA

CreateWorkGroupInput

0 properties

JSON SCHEMA

CreateWorkGroupOutput

0 properties

JSON SCHEMA

DataCatalog

0 properties

JSON SCHEMA

DataCatalogSummary

0 properties

JSON SCHEMA

Database

0 properties

JSON SCHEMA

Datum

0 properties

JSON SCHEMA

DeleteDataCatalogInput

0 properties

JSON SCHEMA

DeleteDataCatalogOutput

0 properties

JSON SCHEMA

DeleteNamedQueryInput

0 properties

JSON SCHEMA

DeleteNamedQueryOutput

0 properties

JSON SCHEMA

DeletePreparedStatementInput

0 properties

JSON SCHEMA

DeletePreparedStatementOutput

0 properties

JSON SCHEMA

DeleteWorkGroupInput

0 properties

JSON SCHEMA

DeleteWorkGroupOutput

0 properties

JSON SCHEMA

EncryptionConfiguration

0 properties

JSON SCHEMA

EngineVersion

0 properties

JSON SCHEMA

GetDataCatalogInput

0 properties

JSON SCHEMA

GetDataCatalogOutput

0 properties

JSON SCHEMA

GetDatabaseInput

0 properties

JSON SCHEMA

GetDatabaseOutput

0 properties

JSON SCHEMA

GetNamedQueryInput

0 properties

JSON SCHEMA

GetNamedQueryOutput

0 properties

JSON SCHEMA

GetPreparedStatementInput

0 properties

JSON SCHEMA

GetPreparedStatementOutput

0 properties

JSON SCHEMA

GetQueryExecutionInput

0 properties

JSON SCHEMA

GetQueryExecutionOutput

0 properties

JSON SCHEMA

GetQueryResultsInput

0 properties

JSON SCHEMA

GetQueryResultsOutput

0 properties

JSON SCHEMA

GetQueryRuntimeStatisticsInput

0 properties

JSON SCHEMA

GetQueryRuntimeStatisticsOutput

0 properties

JSON SCHEMA

GetTableMetadataInput

0 properties

JSON SCHEMA

GetTableMetadataOutput

0 properties

JSON SCHEMA

GetWorkGroupInput

0 properties

JSON SCHEMA

GetWorkGroupOutput

0 properties

JSON SCHEMA

ListDataCatalogsInput

0 properties

JSON SCHEMA

ListDataCatalogsOutput

0 properties

JSON SCHEMA

ListDatabasesInput

0 properties

JSON SCHEMA

ListDatabasesOutput

0 properties

JSON SCHEMA

ListNamedQueriesInput

0 properties

JSON SCHEMA

ListNamedQueriesOutput

0 properties

JSON SCHEMA

ListPreparedStatementsInput

0 properties

JSON SCHEMA

ListPreparedStatementsOutput

0 properties

JSON SCHEMA

ListQueryExecutionsInput

0 properties

JSON SCHEMA

ListQueryExecutionsOutput

0 properties

JSON SCHEMA

ListTableMetadataInput

0 properties

JSON SCHEMA

ListTableMetadataOutput

0 properties

JSON SCHEMA

ListTagsForResourceInput

0 properties

JSON SCHEMA

ListTagsForResourceOutput

0 properties

JSON SCHEMA

ListWorkGroupsInput

0 properties

JSON SCHEMA

ListWorkGroupsOutput

0 properties

JSON SCHEMA

NamedQuery

0 properties

JSON SCHEMA

PreparedStatement

0 properties

JSON SCHEMA

PreparedStatementSummary

0 properties

JSON SCHEMA

QueryExecutionContext

0 properties

JSON SCHEMA

QueryExecution

0 properties

JSON SCHEMA

QueryExecutionStatistics

0 properties

JSON SCHEMA

QueryExecutionStatus

0 properties

JSON SCHEMA

QueryRuntimeStatisticsRows

0 properties

JSON SCHEMA

QueryRuntimeStatistics

0 properties

JSON SCHEMA

QueryRuntimeStatisticsTimeline

0 properties

JSON SCHEMA

QueryStagePlanNode

0 properties

JSON SCHEMA

QueryStage

0 properties

JSON SCHEMA

ResultConfiguration

0 properties

JSON SCHEMA

ResultConfigurationUpdates

0 properties

JSON SCHEMA

ResultSetMetadata

0 properties

JSON SCHEMA

ResultSet

0 properties

JSON SCHEMA

Row

0 properties

JSON SCHEMA

StartQueryExecutionInput

0 properties

JSON SCHEMA

StartQueryExecutionOutput

0 properties

JSON SCHEMA

StopQueryExecutionInput

0 properties

JSON SCHEMA

StopQueryExecutionOutput

0 properties

JSON SCHEMA

TableMetadata

0 properties

JSON SCHEMA

TagResourceInput

0 properties

JSON SCHEMA

TagResourceOutput

0 properties

JSON SCHEMA

Tag

0 properties

JSON SCHEMA

UnprocessedNamedQueryId

0 properties

JSON SCHEMA

UnprocessedQueryExecutionId

0 properties

JSON SCHEMA

UntagResourceInput

0 properties

JSON SCHEMA

UntagResourceOutput

0 properties

JSON SCHEMA

UpdateWorkGroupInput

0 properties

JSON SCHEMA

UpdateWorkGroupOutput

0 properties

JSON SCHEMA

WorkGroupConfiguration

0 properties

JSON SCHEMA

WorkGroupConfigurationUpdates

0 properties

JSON SCHEMA

WorkGroup

0 properties

JSON SCHEMA

WorkGroupSummary

0 properties

JSON SCHEMA

Scroll within the panel for all 99 ·

JSON Structure 98

JSON Structure captures the data shapes in a form built for tooling — a complement to JSON Schema that keeps the model machine-legible.

JSON Structure definitions describing this provider's data shapes.

Athena Athena Error Structure

0 properties

JSON STRUCTURE

Athena Column Info Structure

0 properties

JSON STRUCTURE

Athena Column Structure

0 properties

JSON STRUCTURE

Athena Create Data Catalog Input Structure

0 properties

JSON STRUCTURE

Athena Create Named Query Input Structure

0 properties

JSON STRUCTURE

Athena Create Named Query Output Structure

0 properties

JSON STRUCTURE

Athena Create Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Create Work Group Output Structure

0 properties

JSON STRUCTURE

Athena Data Catalog Structure

0 properties

JSON STRUCTURE

Athena Data Catalog Summary Structure

0 properties

JSON STRUCTURE

Athena Database Structure

0 properties

JSON STRUCTURE

Athena Datum Structure

0 properties

JSON STRUCTURE

Athena Delete Data Catalog Input Structure

0 properties

JSON STRUCTURE

Athena Delete Named Query Input Structure

0 properties

JSON STRUCTURE

Athena Delete Named Query Output Structure

0 properties

JSON STRUCTURE

Athena Delete Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Delete Work Group Output Structure

0 properties

JSON STRUCTURE

Athena Encryption Configuration Structure

0 properties

JSON STRUCTURE

Athena Engine Version Structure

0 properties

JSON STRUCTURE

Athena Get Data Catalog Input Structure

0 properties

JSON STRUCTURE

Athena Get Data Catalog Output Structure

0 properties

JSON STRUCTURE

Athena Get Database Input Structure

0 properties

JSON STRUCTURE

Athena Get Database Output Structure

0 properties

JSON STRUCTURE

Athena Get Named Query Input Structure

0 properties

JSON STRUCTURE

Athena Get Named Query Output Structure

0 properties

JSON STRUCTURE

Athena Get Query Execution Input Structure

0 properties

JSON STRUCTURE

Athena Get Query Results Input Structure

0 properties

JSON STRUCTURE

Athena Get Query Results Output Structure

0 properties

JSON STRUCTURE

Athena Get Table Metadata Input Structure

0 properties

JSON STRUCTURE

Athena Get Table Metadata Output Structure

0 properties

JSON STRUCTURE

Athena Get Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Get Work Group Output Structure

0 properties

JSON STRUCTURE

Athena List Data Catalogs Input Structure

0 properties

JSON STRUCTURE

Athena List Data Catalogs Output Structure

0 properties

JSON STRUCTURE

Athena List Databases Input Structure

0 properties

JSON STRUCTURE

Athena List Databases Output Structure

0 properties

JSON STRUCTURE

Athena List Named Queries Input Structure

0 properties

JSON STRUCTURE

Athena List Named Queries Output Structure

0 properties

JSON STRUCTURE

Athena List Table Metadata Input Structure

0 properties

JSON STRUCTURE

Athena List Work Groups Input Structure

0 properties

JSON STRUCTURE

Athena List Work Groups Output Structure

0 properties

JSON STRUCTURE

Athena Named Query Structure

0 properties

JSON STRUCTURE

Athena Prepared Statement Structure

0 properties

JSON STRUCTURE

Athena Query Execution Context Structure

0 properties

JSON STRUCTURE

Athena Query Execution Status Structure

0 properties

JSON STRUCTURE

Athena Query Execution Structure

0 properties

JSON STRUCTURE

Athena Query Runtime Statistics Structure

0 properties

JSON STRUCTURE

Athena Query Stage Plan Node Structure

0 properties

JSON STRUCTURE

Athena Query Stage Structure

0 properties

JSON STRUCTURE

Athena Result Configuration Structure

0 properties

JSON STRUCTURE

Athena Result Set Metadata Structure

0 properties

JSON STRUCTURE

Athena Result Set Structure

0 properties

JSON STRUCTURE

Athena Row Structure

0 properties

JSON STRUCTURE

Athena Table Metadata Structure

0 properties

JSON STRUCTURE

Athena Tag Resource Input Structure

0 properties

JSON STRUCTURE

Athena Tag Resource Output Structure

0 properties

JSON STRUCTURE

Athena Tag Structure

0 properties

JSON STRUCTURE

Athena Untag Resource Input Structure

0 properties

JSON STRUCTURE

Athena Untag Resource Output Structure

0 properties

JSON STRUCTURE

Athena Update Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Update Work Group Output Structure

0 properties

JSON STRUCTURE

Athena Work Group Configuration Structure

0 properties

JSON STRUCTURE

Athena Work Group Structure

0 properties

JSON STRUCTURE

Athena Work Group Summary Structure

0 properties

JSON STRUCTURE

Scroll within the panel for all 98 ·

Examples 98

Real request and response payloads are what turn a spec from abstract into obvious — and they're one of the twelve things an agent needs to call an API correctly on the first try.

Example request and response payloads for these APIs.

Athena Column Example

3 fields

EXAMPLE

Athena Database Example

3 fields

EXAMPLE

Athena Datum Example

3 fields

EXAMPLE

Athena Result Set Example

3 fields

EXAMPLE

Athena Row Example

3 fields

EXAMPLE

Athena Tag Example

3 fields

EXAMPLE

Athena Work Group Example

3 fields

EXAMPLE

Scroll within the panel for all 98 ·

Security Posture 3

Authentication, domain security, vulnerability disclosure, and trust-center signals — the evidence that a provider takes security seriously enough to document it. We profile it because you can't govern what you can't see.

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Amazon Athena Authentication

apiKey · 1 scheme

SECURITY

Amazon Athena Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Amazon Athena Vulnerability Disclosure

Hackerone · security.txt · contact published

SECURITY

Agentic Access 1

An x-agentic-access contract marks which operations are safe for an agent to run on its own and which need a human in the loop. It is the difference between an API an agent can use and one it can use safely.

Recommended x-agentic-access execution contracts for AI agents.

Amazon Athena Agentic Access

32 operations · 32 acting · 1 human-in-the-loop

32 operations · 32 acting

AGENTIC

Use Cases 6

What developers actually build with this provider — captured so the catalogue answers 'what is this for', not just 'what does this expose'.

What developers build with this provider.

Analyze log files and clickstream data stored in S3
Run ad-hoc SQL queries on data lake without ETL
Build serverless data pipelines and reporting solutions
Query AWS service logs including CloudTrail, ELB, and VPC Flow Logs
Perform cost analysis on AWS Cost and Usage Reports
Enable self-service analytics for business intelligence teams

Integrations 10

Pre-built integrations with other platforms tell you where this provider already fits in a stack.

Pre-built integrations with other platforms and tools.

Amazon S3
AWS Glue
Amazon QuickSight
AWS Lake Formation
Amazon CloudWatch
AWS IAM
Amazon DynamoDB
AWS Step Functions
Amazon SageMaker
Apache Spark

Scroll within the panel for all 10 ·

Resources

Every other property we hold for Amazon Athena — documentation, portals, status pages, policies, and corporate surface — grouped by the job it does, following the integrator's arc from getting started to running in production.

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

← All providers · Data indexed from github.com/api-evangelist/amazon-athena · machine-readable index on apis.io