AWS Athena MCP Server

Name: AWS Athena MCP Server
Author: vipink1203

@vipink1203

リポジトリ

AWS Athena MCP Server について

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

基本情報

カテゴリ

クラウドとインフラ

ランタイム

python

トランスポート

stdio

公開者

vipink1203

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは 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

FAQ from AWS Athena MCP Server

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.

「クラウドとインフラ」の他のコンテンツ

Terraform MCP Server

hashicorp

The Terraform MCP Server provides seamless integration with Terraform ecosystem, enabling advanced automation and interaction capabilities for Infrastructure as Code (IaC) development.

1.5K

tfmcp: Terraform Model Context Protocol Tool

nwiizo

🌍 Terraform Model Context Protocol (MCP) Tool - An experimental CLI tool that enables AI assistants to manage and operate Terraform environments. Supports reading Terraform configurations, analyzing plans, applying configurations, and managing state with Claude Desktop integrati

370