AWS Athena MCP Server

Enables AI assistants to execute SQL queries against AWS Athena databases, check query status, retrieve results, and manage saved queries with support for both local and remote deployment via Lambda.

→ ZackFairTS/athena_mcp_server · listed on glama

Install from

Glama

M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.

// key findings

⚠️

Known vulnerabilities in dependencies: 2 high

Affects packages this MCP installs at runtime. Upgrade or remove the affected dependency.

✅

No credential exfiltration, no sensitive file access, no obfuscation

Static analysis found nothing flowing your secrets to unexpected places.

✅

Open source with a license and README

Anyone can audit the code, the license is declared, and the publisher documents what it does.

🔐

You'll be asked for 1 credential: COGNITO_CLIENT_SECRET

These are read from process.env at runtime. Make sure you trust where they’ll be sent.

// required environment variables

This server reads these from process.env. You'll be asked to provide them before it can run.

configAPI_ENDPOINT— apiEndpoint: process.env.!,

configATHENA_WORKGROUP— "": "default_workgroup", // Optional: specify the Athena WorkGroup

configAWS_PROFILE— "": "default", // Default: 'default' profile

configAWS_REGION— "": "us-east-1", // Default: AWS CLI default region

configCDK_DEFAULT_ACCOUNT

configCDK_DEFAULT_REGION

configCOGNITO_CLIENT_ID— clientId: process.env.!,

🔐 secretCOGNITO_CLIENT_SECRET— clientSecret: process.env.!,

configCOGNITO_TOKEN_URL— tokenUrl: process.env.!,

configOUTPUT_S3_PATH— "": "s3://your-bucket/athena-results/",

// full audit trail

The full breakdown of what we checked, the deductions that landed, the network hosts, the dependency advisories, and concrete fix guidance is available to verified publishers.

// improvement guidance — verified publishers only

We have 4 concrete improvements we can share with the publisher of this MCP. Each comes with specific guidance to raise the trust score.

// embed badge in your README

[![M8ven Score](https://m8ven.ai/badge/mcp/zackfairts-athena-mcp-server-1yoto2)](https://m8ven.ai/mcp/zackfairts-athena-mcp-server-1yoto2)

commit: 7c44f399d03cc731396d9ca1b884e6782b4e0406

code hash: 9e47116659feffdffd734826ffe82f2c7134fe0d5f16d2ed3d9a27928cdf4979

verified: 4/18/2026, 6:52:53 PM

view raw JSON →