AWS Athena MCP Server

@vipink1203

代码仓库

基本信息

分类

云与基础设施

传输方式

stdio

作者

vipink1203

关于 AWS Athena MCP Server

AWS Athena MCP Server

#aws-athena#mcp-server #n8n-integration

AWS Athena MCP Server 配置

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

{
  "mcpServers": {
    "aws-athena-mcp-server": {
      "command": "python",
      "args": [
        "main.py"
      ]
    }
  }
}

AWS Athena MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

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

概览

What is AWS Athena MCP Server?

The AWS Athena MCP Server implements the Model Context Protocol to provide a standardized way for n8n AI agents to query AWS Athena and retrieve data. It allows agents to list available databases and tables, get table schemas and metadata, and execute SQL queries with results.

How to use AWS Athena MCP Server?

Install dependencies (pip install -r requirements.txt), set AWS credentials and environment variables (e.g., AWS_REGION, ATHENA_OUTPUT_LOCATION), then run python main.py. Alternatively, build a Docker image and run it, or deploy to Amazon EKS using the provided Kubernetes manifests.

Key features of AWS Athena MCP Server

Simple API for n8n AI agent integration with Athena
Built-in health checks and monitoring
Configurable via environment variables
Containerized for easy deployment
Kubernetes-ready with sample EKS manifests

Use cases of AWS Athena MCP Server

AI agents querying Athena for analytics or reporting
Automated data retrieval from AWS Athena within n8n workflows
Listing available databases and tables for dynamic schema exploration
Executing ad-hoc SQL queries and returning results to an AI agent

常见问题

What AWS permissions are required?

AWS credentials must have appropriate Athena permissions (e.g., for query execution and S3 output location access).

How is the server configured?

The server uses environment variables including `AWS_REGION`, `ATHENA_CATALOG`, `ATHENA_DATABASE`, `ATHENA_WORKGROUP`, `ATHENA_OUTPUT_LOCATION`, `HOST`, and `PORT` (default 8050).

Where are query results stored?

Results are written to the S3 location specified in the `ATHENA_OUTPUT_LOCATION` environment variable, which is required.

What transports or protocols does the server use?

The server implements the Model Context Protocol (MCP) over HTTP and is designed to communicate with n8n AI agents.

Is the server limited to n8n?

The README explicitly states it is designed for integration with n8n AI agents, though it implements a standard MCP interface.

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

🐳 docker-mcp

QuantGeekDev

A docker MCP Server (modelcontextprotocol)

490

Cloudflare MCP Server

cloudflare

3.9K

YesTechie — UniFi Network & Security Integrator

YesTechie

YesTechie builds enterprise UniFi networks, cameras, access control, cabling and Wi-Fi for businesses nationwide from its California HQ. Agents can read real project case studies and practical configuration guides, price