This MCP server enables AI assistants to execute SQL queries against AWS Athena databases and retrieve results. Developed by Shen Li, it integrates with the AWS SDK to provide a standardized interface for Athena operations. The server is particularly useful for applications requiring large-scale data analysis, business intelligence, or integration with AWS data lakes.
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIExecute a SQL query using AWS Athena. Parameters: database (string), query (string), maxRows (optional integer, default: 1000, max: 10000). Returns full query results if completed within timeout, otherwise returns queryExecutionId.
Check the status of a query execution. Parameters: queryExecutionId (string). Returns state, stateChangeReason, submissionDateTime, completionDateTime, and statistics of the query execution.
Retrieve results for a completed query. Parameters: queryExecutionId (string), maxRows (optional integer, default: 1000, max: 10000). Returns full query results if completed successfully, or an error if the query failed or is still running.
List all saved (named) queries in Athena. Returns an array of saved queries with id, name, and optional description.
Run a previously saved query by its ID. Parameters: namedQueryId (string), databaseOverride (optional string), maxRows (optional integer, default: 1000), timeoutMs (optional integer, default: 60000). Returns full results or execution ID.
