Aws AthenaSAFE
MCP server to run AWS Athena queries
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
- 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)
- 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
}
}
}
}- The server provides the following tools:
run_query: Execute a SQL query using AW
63db66a159ebOBSERVED · 2026-10-08Connect
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 mcp add aws-athena-mcp -- npx -y @lishenxydlgzs/[email protected]
{
"mcpServers": {
"aws-athena-mcp": {
"command": "npx",
"args": [
"-y",
"@lishenxydlgzs/[email protected]"
]
}
}
}Exposed tools (5)
3 read · 2 write · 0 destructive.
| Tool | Risk | Description |
|---|---|---|
get_result | read | Get results for a completed query. Returns error if query is still running. |
get_status | read | Get the current status of a query execution |
list_saved_queries | read | List all saved (named) Athena queries available in your AWS account. |
run_query | write | Execute a SQL query using AWS Athena. Returns full results if query completes before timeout, otherwise returns queryExecutionId. |
run_saved_query | write | Execute a saved (named) Athena query by its query ID. |
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.
| Layer | What it checks | Result |
|---|---|---|
| L0 | Provenance & inventory | PASS |
| L1 | Static analysis of the code | PASS |
| L2 | Instruction surface (what it tells the agent) | PASS |
| L3 | Class-specific surface | PASS |
| L4 | Behavioural (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)
@aws-sdk/client-athena, @aws-sdk/credential-provider-node, @modelcontextprotocol/sdk, @types/node, typescript
Gates applied: no_behavioural_pass.
63db66a159ebfull audit observations/trust-audit/mcp-server/lishenxydlgzs__aws-athena.json · Report an issue / request a re-scanAudit history
Every audit this server has had. A grade with a past is a grade somebody is still checking.
| Date | Source | Verdict | Grade | Score | Change |
|---|---|---|---|---|---|
| 2026-10-08 | 63db66a159eb | SAFE | B | 89 | first audit |
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.