@lishenxydlgzs/aws-athena-mcp
@lishenxydlgzs
About @lishenxydlgzs/aws-athena-mcp
MCP server to run AWS Athena queries
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"athena": {
"command": "npx",
"args": [
"-y",
"@lishenxydlgzs/aws-athena-mcp"
],
"env": {
"OUTPUT_S3_PATH": "s3://your-bucket/athena-results/",
"AWS_REGION": "us-east-1",
"AWS_PROFILE": "default",
"AWS_ACCESS_KEY_ID": "",
"AWS_SECRET_ACCESS_KEY": "",
"AWS_SESSION_TOKEN": "",
"ATHENA_WORKGROUP": "default_workgroup",
"QUERY_TIMEOUT_MS": "300000",
"MAX_RETRIES": "100",
"RETRY_DELAY_MS": "500"
}
}
}
}Tools
No tools detected
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
What is @lishenxydlgzs/aws-athena-mcp?
A Model Context Protocol (MCP) server that enables AI assistants to execute SQL queries against AWS Athena databases and retrieve results. It is built for developers and data analysts who want to query their Athena data through natural language interactions.
How to use @lishenxydlgzs/aws-athena-mcp?
Configure AWS credentials via CLI, environment variables, or IAM role. Add the server to your MCP configuration with the required OUTPUT_S3_PATH environment variable. The server provides five tools: run_query, get_status, get_result, list_saved_queries, and run_saved_query. Run it using npx -y @lishenxydlgzs/aws-athena-mcp.
Key features of @lishenxydlgzs/aws-athena-mcp
- Execute SQL queries on AWS Athena
- Retrieve results synchronously or asynchronously with query execution IDs
- Check query status and statistics using execution IDs
- List and run saved (named) queries from Athena
- Configurable query timeout, retry behavior, and workgroup
- Supports AWS credentials via CLI, environment variables, or IAM roles
Use cases of @lishenxydlgzs/aws-athena-mcp
- List all databases and tables in your Athena environment
- Preview table schemas and sample rows with natural language
- Run analytical queries with filtering, aggregation, and ordering
- Retrieve results from long-running queries later via execution ID
- Execute predefined saved queries by their ID
FAQ from @lishenxydlgzs/aws-athena-mcp
What AWS credentials are needed?
You need AWS credentials with appropriate Athena and S3 permissions, plus an S3 bucket for query results.
What environment variables are required?
OUTPUT_S3_PATH is required. Optional variables include AWS_REGION, AWS_PROFILE, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, ATHENA_WORKGROUP, QUERY_TIMEOUT_MS, MAX_RETRIES, and RETRY_DELAY_MS.
How many rows can be returned per query?
The default maximum is 1000 rows, with a hard maximum of 10,000 rows. You can set maxRows in the tool parameters.
What happens if a query times out?
If the query does not complete within the configured timeout (default 5 minutes), the tool returns only the queryExecutionId so you can later retrieve results using get_status and get_result.
Frequently asked questions
What AWS credentials are needed?
You need AWS credentials with appropriate Athena and S3 permissions, plus an S3 bucket for query results.
What environment variables are required?
`OUTPUT_S3_PATH` is required. Optional variables include `AWS_REGION`, `AWS_PROFILE`, `AWS_ACCESS_KEY_ID`, `AWS_SECRET_ACCESS_KEY`, `AWS_SESSION_TOKEN`, `ATHENA_WORKGROUP`, `QUERY_TIMEOUT_MS`, `MAX_RETRIES`, and `RETRY_DELAY_MS`.
How many rows can be returned per query?
The default maximum is 1000 rows, with a hard maximum of 10,000 rows. You can set `maxRows` in the tool parameters.
What happens if a query times out?
If the query does not complete within the configured timeout (default 5 minutes), the tool returns only the `queryExecutionId` so you can later retrieve results using `get_status` and `get_result`.
Basic information
More Cloud & Infrastructure MCP servers
Lambda MCP Server Demo (Streamable HTTP)
mikegc-awsCreates a simple MCP tool server with "streaming" HTTP.
Run Model Context Protocol (MCP) servers with AWS Lambda
awslabsRun existing Model Context Protocol (MCP) stdio-based servers in AWS Lambda functions
Kilo IoT Platform
Kilo IoTYour AI can finally reach the physical world. Kilo is an AI-first IoT platform for commercial and industrial operations, and this connector hands a live deployment to the AI client you already use. Not an export. Not a
container-use
aluzzardiDevelopment environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.
AWS Model Context Protocol (MCP) Server
alexei-ledA lightweight service that enables AI assistants to execute AWS CLI commands (in safe containerized environment) through the Model Context Protocol (MCP). Bridges Claude, Cursor, and other MCP-aware AI tools with AWS CLI for enhanced cloud infrastructure management.
Comments