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, or queryExecutionId if timeout reached.
Check the status of a query execution. Parameters: queryExecutionId (string). Returns: state (string), stateChangeReason (string), submissionDateTime (datetime), completionDateTime (datetime), statistics (object).
Retrieve results for a completed query. Parameters: queryExecutionId (string), maxRows (optional integer, default: 1000, max: 10000). Returns: Full query results if successful, 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: Same behavior as run_query: full results or execution ID.
