Atlas / MCP servers / lishenxydlgzs / Aws Athena

Aws AthenaSAFE

mcp/lishenxydlgzs/aws-athena

MCP server to run AWS Athena queries

Verdict
SAFE
Grade
B
Trust score
89 /100
Exposed tools
5 3r · 2w · 0d
Transport
stdio
License
MIT
Stars
41
01

Overview

From the repository's own README, as read at the audited commit. Badges and raw HTML are left out.

[](https://lightnow.ai/servers/io.github.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:
  2. AWS CLI configuration
  3. Environment variables (AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY)
  4. IAM role (if running on AWS)
  1. 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",                    // Default: AWS CLI default region
"AWS_PROFILE": "default",                     // Default: 'default' profile
"AWS_ACCESS_KEY_ID": "",                      // Optional: AWS access key
"AWS_SECRET_ACCESS_KEY": "",                  // Optional: AWS secret key
"AWS_SESSION_TOKEN": "",                      // Optional: AWS session token

// Optional server configuration
"ATHENA_WORKGROUP": "default_workgroup",      // Optional: specify the Athena WorkGroup
"QUERY_TIMEOUT_MS": "300000",                 // Default: 5 minutes (300000ms)
"MAX_RETRIES": "100",                         // Default: 100 attempts
"RETRY_DELAY_MS": "500"                       // Default: 500ms between retries
}
}
}
}
  1. The server provides the following tools:
  • run_query: Execute a SQL query using AW
Read from source at commit 63db66a159ebOBSERVED · 2026-10-08
02

Connect

Built from this server's own package name, version and transport as found in its source — not copied from anyone's documentation, so it cannot drift against a page we do not control.

claude-code
claude mcp add aws-athena-mcp -- npx -y @lishenxydlgzs/[email protected]
claude-desktop
{
  "mcpServers": {
    "aws-athena-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@lishenxydlgzs/[email protected]"
      ]
    }
  }
}
03

Exposed tools (5)

3 read · 2 write · 0 destructive.

ToolRiskDescription
get_resultreadGet results for a completed query. Returns error if query is still running.
get_statusreadGet the current status of a query execution
list_saved_queriesreadList all saved (named) Athena queries available in your AWS account.
run_querywriteExecute a SQL query using AWS Athena. Returns full results if query completes before timeout, otherwise returns queryExecutionId.
run_saved_querywriteExecute a saved (named) Athena query by its query ID.
04

Trust audit

SAFEgrade B · trust 89/100 Nothing in the source contradicts what it says it does. Grade A is reserved for packages that have also passed the behavioural sandbox.

LayerWhat it checksResult
L0Provenance & inventoryPASS
L1Static analysis of the codePASS
L2Instruction surface (what it tells the agent)PASS
L3Class-specific surfacePASS
L4Behavioural (sandbox)SKIPPED

What the source does

Filesystem
none-observed
Network
none-observed
Shell
none-observed
Dependencies
not all pinned
Secrets in source
none-found

Findings (1)

LOWSupply chain · supply.unpinned · CWE-829, CWE-1357
package.json
@aws-sdk/client-athena, @aws-sdk/credential-provider-node, @modelcontextprotocol/sdk, @types/node, typescript
Why it matters. 5 dependency range(s) float
Fix. pin exact versions or ship a lockfile

Gates applied: no_behavioural_pass.

Audited 2026-10-08 · audit v0.4.1 · source sha 63db66a159ebfull audit observations/trust-audit/mcp-server/lishenxydlgzs__aws-athena.json · Report an issue / request a re-scan
05

Audit history

Every audit this server has had. A grade with a past is a grade somebody is still checking.

DateSourceVerdictGradeScoreChange
2026-10-0863db66a159ebSAFEB89first audit
06

Questions

What is the Aws Athena MCP server?

MCP server to run AWS Athena queries

What tools does Aws Athena expose?

5 in total: 3 read-only, 2 that write, and 0 that can delete or overwrite. Every one is listed on this page with its risk.

Is Aws Athena safe to connect to an agent?

The audit found nothing in the source that contradicts what it says it does, and graded it B (89/100). Grade A is held back for packages that have also passed a sandboxed behavioural run, which is why a clean server reads B.

What credentials does Aws Athena need?

No credential environment variables were found in its source, so it appears to need none.

How does Aws Athena run?

It speaks stdio, so it runs as a local process your client starts. It is published on npm as @lishenxydlgzs/aws-athena-mcp at 1.0.0.

How current is this page?

The grade is for one exact copy of the source (63db66a159eb), read on 2026-10-08. The repository is watched and re-audited when it changes.

Advertisement