AWS Athena
Summary
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.
Available Actions(5)
run_query
Execute 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 timed out.
get_status
Check the status of a query execution. Parameters: queryExecutionId (string). Returns state, stateChangeReason, submissionDateTime, completionDateTime, and statistics.
get_result
Retrieve results for a completed query. Parameters: queryExecutionId (string), maxRows (optional integer, default: 1000, max: 10000). Returns full query results if completed successfully, or error if it failed or is still running.
list_saved_queries
List all saved (named) queries in Athena. Returns an array of saved queries with id, name, and optional description.
run_saved_query
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.
Avis de la Communauté
Aucun avis encore. Soyez le premier à donner votre avis !
Connectez-vous pour rejoindre la conversation