@lishenxydlgzs/aws-athena-mcp

MCP server to run AWS Athena queries

Catalog onlyCatalog onlySTDIO

Overview

aws-athena-mcp is a Model Context Protocol (MCP) server designed to run AWS Athena queries, enabling AI assistants to execute SQL queries against AWS Athena databases and retrieve results.

To use aws-athena-mcp, configure your AWS credentials, add the server to your MCP configuration, and utilize the provided tools to run queries, check query status, and retrieve results.

Execute SQL queries against AWS Athena databases - Check the status of query executions - Retrieve results for completed queries - Configurable timeout and retry settings

Running SQL queries to analyze large datasets in AWS Athena.
Integrating with AI assistants to provide data insights on demand.
Automating data retrieval processes for reporting and analytics.

Add to your AI client

Use these steps to connect @lishenxydlgzs/aws-athena-mcp in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "aws-athena-mcp-lishenxydlgzs": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-athena-mcp-lishenxydlgzs"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "aws-athena-mcp-lishenxydlgzs": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-athena-mcp-lishenxydlgzs"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "aws-athena-mcp-lishenxydlgzs": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-athena-mcp-lishenxydlgzs"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "aws-athena-mcp-lishenxydlgzs": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-athena-mcp-lishenxydlgzs"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "aws-athena-mcp-lishenxydlgzs": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-athena-mcp-lishenxydlgzs"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "aws-athena-mcp-lishenxydlgzs": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-athena-mcp-lishenxydlgzs"
      ]
    }
  }
}

FAQ

What are the requirements to use aws-athena-mcp?

You need Node.js >= 16, AWS credentials with appropriate Athena permissions, and an S3 bucket for query results.

Can I run complex SQL queries?

Yes! You can run complex SQL queries including filtering and aggregation.

Is there a limit on the number of rows returned?

Yes, the maximum number of rows returned is configurable, with a default of 1000.

Research and data