aws-athena-mcp

run_query

Execute SQL queries on AWS Athena to retrieve data from AWS Glue catalog. Manages query execution with configurable timeout and row limits for efficient data access.

Instructions

Execute a SQL query using AWS Athena. Returns full results if query completes before timeout, otherwise returns queryExecutionId.

Input Schema

NameRequiredDescriptionDefault
databaseYesThe Athena database to query
maxRowsNoMaximum number of rows to return (default: 1000)
queryYesSQL query to execute
timeoutMsNoTimeout in milliseconds (default: 60000)

Input Schema (JSON Schema)

{ "properties": { "database": { "description": "The Athena database to query", "type": "string" }, "maxRows": { "description": "Maximum number of rows to return (default: 1000)", "maximum": 10000, "minimum": 1, "type": "number" }, "query": { "description": "SQL query to execute", "type": "string" }, "timeoutMs": { "description": "Timeout in milliseconds (default: 60000)", "minimum": 1000, "type": "number" } }, "required": [ "database", "query" ], "type": "object" }

You must be authenticated.

Other Tools from aws-athena-mcp

Related Tools

ID: 0i7dhkex6t