AWS Athena

Prepare an S3 Bucket for Athena Results

• Log in to your AWS Management Console.
• Open the S3 service at https://console.aws.amazon.com/s3/.
• Create a new bucket (or use an existing one) to store Athena query results.
• Take note of the bucket name. Example: your-bucket.

Obtain AWS Access Keys

• Open the AWS Management Console.
• Go to "IAM" (Identity and Access Management) at https://console.aws.amazon.com/iam/.
• In the left sidebar, click "Users" and select your user.
• Go to the "Security credentials" tab.
• Under "Access keys," click "Create access key."
• Copy and save the AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY. (You will only see the secret once!)

Optional: AWS Session Token (if using temporary credentials)

• If your credentials are temporary (such as when using MFA or a federated login), obtain the AWS_SESSION_TOKEN from your authentication process.

Get Your AWS Region

• Identify the region where your Athena and S3 resources are located (e.g., us-east-1).

Get Your Athena Workgroup (Optional)

• If you use a specific Athena workgroup, find its name in the Athena console at https://console.aws.amazon.com/athena/.

Fill In the FastMCP Connection Interface

• Click the “Install Now” button for @lishenxydlgzs/aws-athena-mcp in FastMCP.
• In the connection interface, fill out the following values:
  • OUTPUT_S3_PATH: The URL of your bucket, e.g., s3://your-bucket/athena-results/
  • AWS_REGION (optional): The region code, e.g., us-east-1.
  • AWS_PROFILE (optional): Leave blank unless using a named AWS CLI profile.
  • AWS_ACCESS_KEY_ID: Your AWS access key ID.
  • AWS_SECRET_ACCESS_KEY: Your AWS secret access key.
  • AWS_SESSION_TOKEN (optional): Only if your credentials require it.
  • ATHENA_WORKGROUP (optional): The name of your Athena workgroup.
  • Leave other optional fields at their default values if you are unsure.

Save and Test

• Save the configuration and, if prompted, test the connection to ensure the credentials and permissions are working correctly.