query_athena
Execute SQL queries on Amazon Athena and retrieve query results in JSON, table, or CSV format to support data analysis and reporting.
Instructions
Execute SQL queries against Amazon Athena and retrieve results
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"query": "<query>"
},
"name": "query_athena"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL query to execute | |
| format | No | Result format (json, table, or csv) | |
| region | No | AWS region (optional, uses default if not specified) | |
| catalog | No | Catalog (Data source) to query (optional, uses AwsDataCatalog if not specified) | |
| profile | No | AWS profile name to use from shared credentials file (optional) | |
| database | No | Database to query (optional, uses default if not specified) |