@lishenxydlgzs/aws-athena-mcp

Name: @lishenxydlgzs/aws-athena-mcp
Author: lishenxydlgzs

@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.

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

Supabase MCP Server

coleam00

Supabase MCP server created in Python.

195

🐳 docker-mcp

QuantGeekDev

A docker MCP Server (modelcontextprotocol)

490

Query | MCP server for Supabase

alexander-zuev

Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning, access to logs and much more.

828