MCP Solutions

AWS Athena MCP

Active

A Model Context Protocol (MCP) server for running AWS Athena queries. This server enables AI assistants to execute SQL queries against your AWS Athena databases and retrieve results.

Updated 8/8/2025
Key Features

What makes this MCP server special

Execute a SQL query using AWS Athena
Check the status of a query execution
Retrieve results for a completed query
List all saved (named) queries in Athena

Requirements

npx
Server Information

Status

Active

Version

1.0.0

License

MIT

Author

https://github.com/lishenxydlgzs

Installation Guide
Get started with this MCP server in minutes

1. Install the Package

-

2. Configuration

{
  "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"
      }
    }
  }
}

3. Usage Example

-