MCPServers
AWS Athena - MCP server logo
9
0

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.

Last Updated: April 17, 2025

Avis de la Communauté

0.0
0 avis
5
0
4
0
3
0
2
0
1
0

Aucun avis encore. Soyez le premier à donner votre avis !

Connectez-vous pour rejoindre la conversation

Coming soon to
HighlightHighlight AI

Langage

TypeScript

Catégories

Tags