MCP.so
登录

@lishenxydlgzs/aws-athena-mcp

@lishenxydlgzs

代码仓库

关于 @lishenxydlgzs/aws-athena-mcp

MCP server to run AWS Athena queries

基本信息

分类

云与基础设施

许可证

MIT

运行时

node

传输方式

stdio

发布者

lishenxydlgzs

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is @lishenxydlgzs/aws-athena-mcp?

A Model Context Protocol (MCP) server that enables AI assistants to execute SQL queries against AWS Athena databases and retrieve results. It is built for developers and data analysts who want to query their Athena data through natural language interactions.

How to use @lishenxydlgzs/aws-athena-mcp?

Configure AWS credentials via CLI, environment variables, or IAM role. Add the server to your MCP configuration with the required OUTPUT_S3_PATH environment variable. The server provides five tools: run_query, get_status, get_result, list_saved_queries, and run_saved_query. Run it using npx -y @lishenxydlgzs/aws-athena-mcp.

Key features of @lishenxydlgzs/aws-athena-mcp

  • Execute SQL queries on AWS Athena
  • Retrieve results synchronously or asynchronously with query execution IDs
  • Check query status and statistics using execution IDs
  • List and run saved (named) queries from Athena
  • Configurable query timeout, retry behavior, and workgroup
  • Supports AWS credentials via CLI, environment variables, or IAM roles

Use cases of @lishenxydlgzs/aws-athena-mcp

  • List all databases and tables in your Athena environment
  • Preview table schemas and sample rows with natural language
  • Run analytical queries with filtering, aggregation, and ordering
  • Retrieve results from long-running queries later via execution ID
  • Execute predefined saved queries by their ID

FAQ from @lishenxydlgzs/aws-athena-mcp

What AWS credentials are needed?

You need AWS credentials with appropriate Athena and S3 permissions, plus an S3 bucket for query results.

What environment variables are required?

OUTPUT_S3_PATH is required. Optional variables include AWS_REGION, AWS_PROFILE, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, ATHENA_WORKGROUP, QUERY_TIMEOUT_MS, MAX_RETRIES, and RETRY_DELAY_MS.

How many rows can be returned per query?

The default maximum is 1000 rows, with a hard maximum of 10,000 rows. You can set maxRows in the tool parameters.

What happens if a query times out?

If the query does not complete within the configured timeout (default 5 minutes), the tool returns only the queryExecutionId so you can later retrieve results using get_status and get_result.

评论

云与基础设施 分类下的更多 MCP 服务器

Kubernetes MCP Server

reza-gholizade

Manage Your Kubernetes Cluster with k8s mcp-server

170

Firebase MCP

gannonh

🔥 Model Context Protocol (MCP) server for Firebase.

247

MCP Server Kubernetes

Flux159

MCP Server for kubernetes management commands

1.5K

AWS MCP Servers

awslabs

Open source MCP Servers for AWS

9.4K

MCP Gateway

mcp-ecosystem

🧩 MCP Gateway - A lightweight gateway service that instantly transforms existing MCP Servers and APIs into MCP servers with zero code changes. Features Docker deployment and management UI, requiring no infrastructure modifications.

2.2K