The aws-athena-mcp server allows AI agents to execute SQL queries on AWS Athena. It provides tools for querying data in S3 using standard SQL, connecting to the AWS Athena API. Developers use it to integrate Athena query capabilities into AI workflows, enabling data analysis and retrieval from S3 data lakes.
The aws-athena-mcp server allows AI agents to execute SQL queries on AWS Athena. It provides tools for querying data in S3 using standard SQL, connecting to the AWS Athena API. Developers use it to integrate Athena query capabilities into AI workflows, enabling data analysis and retrieval from S3 data lakes.
npx -y @lishenxydlgzs/aws-athena-mcpAdd this configuration to your claude_desktop_config.json:
{
"mcpServers": {
"lishenxydlgzs-aws-athena-mcp-npm": {
"command": "npx",
"args": [
"-y",
"npx -y @lishenxydlgzs/aws-athena-mcp"
]
}
}
}Restart Claude Desktop, then ask:
"What tools do you have available from aws-athena-mcp?"
API Key Required
This server requires an API key from aws-athena-mcp. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| AWS-ATHENA-MCP_API_KEY | Yes | Your aws-athena-mcp API key |
"What resources are available in aws-athena-mcp?"
Claude will query available resources and return a list of what you can access.
"Show me details about [specific item] in aws-athena-mcp"
Claude will fetch and display detailed information about the requested item.
"Create a new [item] in aws-athena-mcp with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.