AWS Athena MCP Server

@vipink1203

Repository

Basic information

About AWS Athena MCP Server

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

AWS Athena MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

AWS Athena MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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.

Comments

More Cloud & Infrastructure MCP servers

Lium - GPU cloud

Lium

Find, price and rent GPUs on Lium from Claude, ChatGPT, Codex or any MCP client. Search live GPU availability and prices (H100, H200, B200, RTX 4090 and more), estimate provider earnings, and with Sign in with Lium or a

InfraNest

InfraNest watches your websites, servers, domains and SSL certificates. Connect it to Claude, ChatGPT or Cursor and ask what is down or about to expire.

Aws Kb Retrieval Server

modelcontextprotocol

Model Context Protocol Servers

88.2K

OutageDeck

outagedeck

Official OutageDeck MCP server for vendor-published cloud and SaaS status, incident timelines, and observed uptime history.

🐳 docker-mcp

QuantGeekDev

A docker MCP Server (modelcontextprotocol)

490