What can you do with the AWS Athena integration?

LiveContext exposes 37 operations on AWS Athena, covering prepared statement, data catalog, resource tag and batch get named query. Common uses include audit resource tags, update a stored SQL query and remove cost allocation tags.

LiveContext

All integrations

AWS Athena integration

Amazon Athena interactive query service API. Run SQL queries against data in S3, manage workgroups, named queries, and query executions for serverless data analytics.

37 toolsCustom authAPI docs

Connect AWS Athena How integrations work

Common AWS Athena use cases

audit resource tags
update a stored SQL query
remove cost allocation tags
inspect a prepared statement's SQL
tag workgroups for cost allocation
analyze query execution performance
clean up unused prepared statements
deregister an external data catalog
register a Lambda-backed data source
create reusable parameterized queries

What you can do with AWS Athena

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Prepared statement, 6 operations

POSTbatch_get_prepared_statement
Retrieves details for up to 256 prepared statements in a single request. Returns full PreparedStatement objects and any unprocessed names.
POSTcreate_prepared_statement
Creates a prepared statement with parameterized SQL for reuse. Parameters are filled at execution time via ExecutionParameters in StartQueryExecution.
POSTdelete_prepared_statement
Deletes a prepared statement from the specified workgroup.
POSTget_prepared_statement
Retrieves a prepared statement by name from the specified workgroup, including its SQL and description.
POSTlist_prepared_statements
Lists all prepared statements in the specified workgroup with their names and last modified times.
POSTupdate_prepared_statement
Updates the SQL query or description of an existing prepared statement in a workgroup.

Data catalog, 3 operations

POSTcreate_data_catalog
Creates and registers a new data catalog (LAMBDA, GLUE, HIVE, or FEDERATED type) for use with Athena queries.
POSTdelete_data_catalog
Deletes a data catalog by name. The built-in AwsDataCatalog cannot be deleted.
POSTupdate_data_catalog
Updates the configuration, description, or Lambda parameters of an existing data catalog.

Resource tag, 3 operations

POSTlist_tags_for_resource
Lists all tags associated with an Athena workgroup or data catalog, identified by its ARN.
POSTtag_resource
Adds tags to an Athena workgroup or data catalog resource identified by its ARN.
POSTuntag_resource
Removes specified tags from an Athena workgroup or data catalog resource.

Batch get named query, 1 operation

POSTbatch_get_named_query
Returns the details of a single named query or a list of up to 50 queries, which you provide as an array of query ID strings.

Batch get query execution, 1 operation

POSTbatch_get_query_execution
Returns the details of a single query execution or a list of up to 50 query executions.

Create named query, 1 operation

POSTcreate_named_query
Creates a named query in the specified workgroup. Named queries allow you to store and run SQL queries that you use regularly.

Create work group, 1 operation

POSTcreate_work_group
Creates a workgroup with the specified name. A workgroup lets you manage users, workloads, and query settings.

Database, 1 operation

POSTlist_databases
Lists the databases in the specified data catalog.

Delete named query, 1 operation

POSTdelete_named_query
Deletes the named query if you have access to the workgroup in which the query was saved.

Delete work group, 1 operation

POSTdelete_work_group
Deletes the workgroup with the specified name. The primary workgroup cannot be deleted.

Get data catalog, 1 operation

POSTget_data_catalog
Returns the specified data catalog.

Get database, 1 operation

POSTget_database
Returns a database object for the specified database and data catalog.

Get named query, 1 operation

POSTget_named_query
Returns information about a single named query or a list of up to 50 queries that you provide.

Get query execution, 1 operation

POSTget_query_execution
Returns information about a single execution of a query if you have access to the workgroup in which the query ran.

Get query result, 1 operation

POSTget_query_results
Streams the results of the specified query execution stored as a paginated list of result rows in Amazon S3.

Get table metadata, 1 operation

POSTget_table_metadata
Returns table metadata for the specified catalog, database, and table.

Get work group, 1 operation

POSTget_work_group
Returns information about the workgroup with the specified name.

List data catalog, 1 operation

POSTlist_data_catalogs
Lists the data catalogs in the current Amazon Web Services account.

List engine version, 1 operation

POSTlist_engine_versions
Returns a list of engine versions that are available to choose from, including the Auto option.

List named query, 1 operation

POSTlist_named_queries
Provides a list of available query IDs only for queries saved in the specified workgroup.

List query execution, 1 operation

POSTlist_query_executions
Provides a list of available query execution IDs for the queries in the specified workgroup.

List table metadata, 1 operation

POSTlist_table_metadata
Lists the metadata for the tables in the specified database and data catalog.

List work group, 1 operation

POSTlist_work_groups
Lists available workgroups for the account.

Named query, 1 operation

POSTupdate_named_query
Updates a named query in the specified workgroup. The NamedQueryId, Name, and QueryString are all required.

Query runtime statistics, 1 operation

POSTget_query_runtime_statistics
Returns detailed runtime statistics for a query execution including timeline, rows processed, and output stage breakdown.

Start query execution, 1 operation

POSTstart_query_execution
Runs the SQL query statements contained in the QueryString. Execution parameters may be set for the query.

Stop query execution, 1 operation

POSTstop_query_execution
Stops a query execution. Athena automatically retains query results for 45 days.

Update work group, 1 operation

POSTupdate_work_group
Updates the workgroup with the specified name. The workgroup's Name cannot be changed.

Use AWS Athena from Claude Code, Cursor or Codex

Connect AWS Athena in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its AWS Athena operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect AWS Athena

Create your workspace
Sign up free. Nothing to install.
Connect AWS Athena once
Add your AWS Athena connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.

AWS Athena integration FAQ

What can you do with the AWS Athena integration?: LiveContext exposes 37 operations on AWS Athena, covering prepared statement, data catalog, resource tag and batch get named query. Common uses include audit resource tags, update a stored SQL query and remove cost allocation tags.