aws_dynamodb_query
Query AWS DynamoDB tables using key condition expressions to retrieve items as JSON objects, with support for filters, indexes, and sorting.
Instructions
Query a DynamoDB table using a key condition expression. Items are returned deserialized as plain JSON objects.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| profile | No | AWS profile name from ~/.aws/config (e.g., 'default', 'production') | |
| region | No | AWS region override (e.g., 'us-east-1', 'sa-east-1') | |
| table_name | Yes | DynamoDB table name | |
| key_condition_expression | Yes | Key condition (e.g., 'pk = :pkval AND begins_with(sk, :skprefix)') | |
| expression_attribute_values | Yes | Values for expression placeholders in DynamoDB format (e.g., {":pkval": {"S": "user#123"}}) | |
| expression_attribute_names | No | Name placeholders for reserved words (e.g., {"#s": "status"}) | |
| filter_expression | No | Additional filter applied after the query | |
| index_name | No | Name of a GSI or LSI to query | |
| limit | No | Maximum items to evaluate | |
| scan_index_forward | No | True for ascending order, False for descending (default: True) |