Skip to main content
Glama
ZackFairTS

AWS Athena MCP Server

by ZackFairTS

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
AWS_REGIONNoAWS region for Athenaus-east-1
AWS_PROFILENoAWS CLI profile to usedefault
MAX_RETRIESNoMaximum number of retry attempts100
OUTPUT_S3_PATHYesS3 path for Athena query results (e.g., s3://your-bucket/athena-results/)
RETRY_DELAY_MSNoDelay between retries in milliseconds500
ATHENA_WORKGROUPNoAthena WorkGroup to usedefault_workgroup
QUERY_TIMEOUT_MSNoQuery timeout in milliseconds300000
AWS_ACCESS_KEY_IDNoAWS access key ID
AWS_SESSION_TOKENNoAWS session token
AWS_SECRET_ACCESS_KEYNoAWS secret access key

Tools

Functions exposed to the LLM to take actions

NameDescription
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

run_saved_query

Execute a saved (named) Athena query by its query ID.

list_saved_queries

List all saved (named) Athena queries available in your AWS account.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/ZackFairTS/athena_mcp_server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server