@lishenxydlgzs/aws-athena-mcp
A Model Context Protocol (MCP) server for running AWS Athena queries. This server enables AI assistants to execute SQL queries against your AWS Athena databases and retrieve results.
Usage
- Configure AWS credentials using one of the following methods:
- Add the server to your MCP configuration:
- The server provides the following tools:
run_query: Execute a SQL query using AWS Athena
get_status: Check the status of a query execution
get_result: Retrieve results for a completed query
list_saved_queries: List all saved (named) queries in Athena.
- Returns:
- run_saved_query: Run a previously saved query by its ID.
- Parameters:
- Returns:
Usage Examples
Show All Databases
Message to AI Assistant:
List all databases in AthenaMCP parameter:
List Tables in a Database
Message to AI Assistant:
Show me all tables in the default databaseMCP parameter:
Get Table Schema
Message to AI Assistant:
What's the schema of the asin_sitebestimg table?MCP parameter:
Table Rows Preview
Message to AI Assistant:
Show some rows from my_database.mytableMCP parameter:
Advanced Query with Filtering and Aggregation
Message to AI Assistant:
Find the average price by category for in-stock productsMCP parameter:
Checking Query Status
Getting Results for a Completed Query
Listing Saved Queries
Running a Saved Query
Requirements
- Node.js >= 16
- AWS credentials with appropriate Athena and S3 permissions
- S3 bucket for query results
- Named queries (optional) must exist in the specified
ATHENA_WORKGROUPandAWS_REGION
License
MIT
Repository
@lishenxydlgzs/aws-athena-mcp
A Model Context Protocol (MCP) server for running AWS Athena queries. This server enables AI assistants to execute SQL queries against your AWS Athena databases and retrieve results.
Usage
- Configure AWS credentials using one of the following methods:
- Add the server to your MCP configuration:
- The server provides the following tools:
run_query: Execute a SQL query using AWS Athena
get_status: Check the status of a query execution
get_result: Retrieve results for a completed query
list_saved_queries: List all saved (named) queries in Athena.
- Returns:
- run_saved_query: Run a previously saved query by its ID.
- Parameters:
- Returns:
Usage Examples
Show All Databases
Message to AI Assistant:
List all databases in AthenaMCP parameter:
List Tables in a Database
Message to AI Assistant:
Show me all tables in the default databaseMCP parameter:
Get Table Schema
Message to AI Assistant:
What's the schema of the asin_sitebestimg table?MCP parameter:
Table Rows Preview
Message to AI Assistant:
Show some rows from my_database.mytableMCP parameter:
Advanced Query with Filtering and Aggregation
Message to AI Assistant:
Find the average price by category for in-stock productsMCP parameter:
Checking Query Status
Getting Results for a Completed Query
Listing Saved Queries
Running a Saved Query
Requirements
- Node.js >= 16
- AWS credentials with appropriate Athena and S3 permissions
- S3 bucket for query results
- Named queries (optional) must exist in the specified
ATHENA_WORKGROUPandAWS_REGION
License
MIT