aws-athena-mcp
by lishenxydlgzs
Verified
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| AWS_REGION | No | AWS region to use. Defaults to AWS CLI default region. | AWS CLI default region |
| AWS_PROFILE | No | AWS CLI profile to use. Defaults to 'default'. | default |
| MAX_RETRIES | No | Maximum number of retries for a query. Defaults to 100. | 100 |
| OUTPUT_S3_PATH | Yes | The S3 path where Athena query results will be stored. Required. | |
| RETRY_DELAY_MS | No | Delay in milliseconds between retries. Defaults to 500ms. | 500 |
| QUERY_TIMEOUT_MS | No | Query timeout in milliseconds. Defaults to 300000ms (5 minutes). | 300000 |
| AWS_ACCESS_KEY_ID | No | AWS access key. Optional. | |
| AWS_SESSION_TOKEN | No | AWS session token. Optional. | |
| AWS_SECRET_ACCESS_KEY | No | AWS secret key. Optional. |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| run_query | Execute a SQL query using AWS Athena. Returns full results if query completes before timeout, otherwise returns queryExecutionId. |
| get_result | Get results for a completed query. Returns error if query is still running. |
| get_status | Get the current status of a query execution |