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.
Nessuna recensione ancora. Sii il primo a recensire!
Accedi per unirti alla conversazione
Highlight AIExecute a SQL query using AWS Athena. Parameters: database (string), query (string), maxRows (optional integer, default: 1000, max: 10000). Returns full query results or queryExecutionId if timeout reached.
Check the status of a query execution. Parameters: queryExecutionId (string). Returns state, stateChangeReason, submissionDateTime, completionDateTime, and statistics.
Retrieve results for a completed query. Parameters: queryExecutionId (string), maxRows (optional integer, default: 1000, max: 10000). Returns full query results or error if 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.
