@lishenxydlgzs/aws-athena-mcp

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.

Usage

1. Configure AWS credentials using one of the following methods:

• AWS CLI configuration
• Environment variables (AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY)
• IAM role (if running on AWS)

2. Add the server to your MCP configuration:

   {
     "mcpServers": {
       "athena": {
         "command": "npx",
         "args": ["-y", "@lishenxydlgzs/aws-athena-mcp"],
         "env": {
           // Required
           "OUTPUT_S3_PATH": "s3://your-bucket/athena-results/",
           // Optional AWS configuration
           "AWS_REGION": "us-east-1",
           "AWS_PROFILE": "default",
           "AWS_ACCESS_KEY_ID": "",
           "AWS_SECRET_ACCESS_KEY": "",
           "AWS_SESSION_TOKEN": "",
           // Optional server configuration
           "ATHENA_WORKGROUP": "default_workgroup",
           "QUERY_TIMEOUT_MS": "300000",
           "MAX_RETRIES": "100",
           "RETRY_DELAY_MS": "500"
         }
       }
     }
   }
   

3. The server provides the following tools:

• run_query: Execute a SQL query using AWS Athena
• get_status: Check the status of a query execution
• get_result: Retrieve results for a completed query
• list_saved_queries: List all saved (named) queries in Athena.
• run_saved_query: Run a previously saved query by its ID.

Requirements

• Node.js >= 16
• AWS credentials with appropriate Athena and S3 permissions
• S3 bucket for query results
• Named queries (optional) must exist in the specified ATHENA_WORKGROUP and AWS_REGION