aws-athena-mcp

aws-athena-mcp

19

The aws-athena-mcp project provides a Model Context Protocol server enabling AI systems to run SQL queries on AWS Athena databases effectively. It allows users to manage query executions, check statuses, retrieve results, and execute saved queries using Athena.

Overview

  • A Model Context Protocol (MCP) server for running AWS Athena queries.
  • Enables AI assistants to execute SQL queries on AWS Athena databases.
  • Tools provided:
    • run_query: Execute SQL queries.
    • get_status: Check query execution status.
    • get_result: Retrieve completed query results.
    • list_saved_queries: List saved Athena queries.
    • run_saved_query: Execute saved queries.
  • Usage:
    1. Configure AWS credentials through CLI, environment variables, or IAM role.
    2. Add the server to MCP configuration.
  • Requirements:
    • Node.js >= 16
    • AWS credentials with Athena and S3 permissions
    • S3 bucket for results.