aws-athena-mcp

MIT License

129

Overview InspectNew Schema Related Servers Reviews Score

run_query

Execute SQL queries on AWS Athena to retrieve data from AWS Glue catalog. Manages query execution with configurable timeout and row limits for efficient data access.

Instructions

Execute a SQL query using AWS Athena. Returns full results if query completes before timeout, otherwise returns queryExecutionId.

Input Schema

Name	Required	Description
`database`	Yes	The Athena database to query
`maxRows`	No	Maximum number of rows to return (default: 1000)
`query`	Yes	SQL query to execute
`timeoutMs`	No	Timeout in milliseconds (default: 60000)

Input Schema (JSON Schema)

{
  "properties": {
    "database": {
      "description": "The Athena database to query",
      "type": "string"
    },
    "maxRows": {
      "description": "Maximum number of rows to return (default: 1000)",
      "maximum": 10000,
      "minimum": 1,
      "type": "number"
    },
    "query": {
      "description": "SQL query to execute",
      "type": "string"
    },
    "timeoutMs": {
      "description": "Timeout in milliseconds (default: 60000)",
      "minimum": 1000,
      "type": "number"
    }
  },
  "required": [
    "database",
    "query"
  ],
  "type": "object"
}

You must be authenticated.

Other Tools from aws-athena-mcp

Related Tools

get_result
@lishenxydlgzs/aws-athena-mcp
get_status
@lishenxydlgzs/aws-athena-mcp
athena_create_cloudtrail_table
@Brucedh/aws-ireveal-mcp
athena_query_events
@Brucedh/aws-ireveal-mcp
es-info
@imlewc/elasticsearch7-mcp-server
execute_sql
@HenkDz/selfhosted-supabase-mcp

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/lishenxydlgzs/aws-athena-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server