AWS Athena MCP Server
@vipink1203
About AWS Athena MCP Server
AWS Athena MCP Server
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"aws-athena-mcp-server": {
"command": "python",
"args": [
"main.py"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is AWS Athena MCP Server?
The AWS Athena MCP Server implements the Model Context Protocol to provide a standardized way for n8n AI agents to query AWS Athena and retrieve data. It allows agents to list available databases and tables, get table schemas and metadata, and execute SQL queries with results.
How to use AWS Athena MCP Server?
Install dependencies (pip install -r requirements.txt), set AWS credentials and environment variables (e.g., AWS_REGION, ATHENA_OUTPUT_LOCATION), then run python main.py. Alternatively, build a Docker image and run it, or deploy to Amazon EKS using the provided Kubernetes manifests.
Key features of AWS Athena MCP Server
- Simple API for n8n AI agent integration with Athena
- Built-in health checks and monitoring
- Configurable via environment variables
- Containerized for easy deployment
- Kubernetes-ready with sample EKS manifests
Use cases of AWS Athena MCP Server
- AI agents querying Athena for analytics or reporting
- Automated data retrieval from AWS Athena within n8n workflows
- Listing available databases and tables for dynamic schema exploration
- Executing ad-hoc SQL queries and returning results to an AI agent
FAQ from AWS Athena MCP Server
What AWS permissions are required?
AWS credentials must have appropriate Athena permissions (e.g., for query execution and S3 output location access).
How is the server configured?
The server uses environment variables including AWS_REGION, ATHENA_CATALOG, ATHENA_DATABASE, ATHENA_WORKGROUP, ATHENA_OUTPUT_LOCATION, HOST, and PORT (default 8050).
Where are query results stored?
Results are written to the S3 location specified in the ATHENA_OUTPUT_LOCATION environment variable, which is required.
What transports or protocols does the server use?
The server implements the Model Context Protocol (MCP) over HTTP and is designed to communicate with n8n AI agents.
Is the server limited to n8n?
The README explicitly states it is designed for integration with n8n AI agents, though it implements a standard MCP interface.
More Cloud & Infrastructure MCP servers
container-use
daggerDevelopment environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.
MCP Server Kubernetes
Flux159MCP Server for kubernetes management commands
Run Model Context Protocol (MCP) servers with AWS Lambda
awslabsRun existing Model Context Protocol (MCP) stdio-based servers in AWS Lambda functions
AWS MCP Servers
awslabsOpen source MCP Servers for AWS
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