aws-athena-mcpServer

lishenxydlgzs
GitHub
AWSAthenaMCP

Loading subscription status...

๐Ÿ’ก Description

An MCP server for executing AWS Athena queries. This server allows AI assistants to run SQL queries on AWS Athena databases and retrieve results.

๐Ÿ“ JSON Entries

{
  "mcpServers": [
    {
      "mcp_server_name": {
        "env": {
          "AWS_ACCESS_KEY_ID": "<SECRET_AWS_ACCESS_KEY_ID>",
          "AWS_SECRET_ACCESS_KEY": "<SECRET_AWS_SECRET_ACCESS_KEY>"
        },
        "args": [
          "database",
          "query",
          "maxRows"
        ],
        "command": "run_query"
      }
    }
  ]
}

๐Ÿ› ๏ธ Tools

run_queryget_resultget_status

โšก Features

  • Execute SQL queries on AWS Athena
  • Get query execution status
  • Retrieve results of completed queries
  • List saved queries
  • Run saved queries

๐Ÿ’ฌ Example Queries

  • List all databases in Athena
  • Show me all tables in the default database
  • What's the schema of the asin_sitebestimg table?
  • Show some rows from my_database.mytable
  • Find the average price by category for in-stock products