DynamoDB Review
Review DynamoDB for single-table design, GSI/LSI strategies, capacity, DAX, TTL, and Streams.
Key Checks
- All access patterns served by Query or GetItem (flag any Scan in application code)
- Single-table design with entity-type prefixes on PK/SK
- GSI partition key: high cardinality, even distribution; sparse GSIs for subset filtering
- Capacity: on-demand for spiky, provisioned+auto-scaling for predictable (70% target)
- DAX for read-heavy microsecond-latency (eventually consistent only)
- TTL as epoch seconds, filter expired items in queries (deletion is eventual ~48h)
- Streams: idempotent processing, 24h retention, DLQ for Lambda triggers
- BatchWriteItem/BatchGetItem over individual calls, exponential backoff for UnprocessedItems
- Transactions: 2x cost, max 100 items, idempotency token for retries
- Hot partition detection via CloudWatch Contributor Insights
Output
Severity-sorted: CRITICAL, HIGH, MEDIUM, LOW, PASSED.
1---2name: dynamodb-review3description: Review DynamoDB table design, access patterns, capacity planning, and configuration4agent: database-reviewer5argument-hint: "<table-definition-or-access-pattern>"6tags: [database, dynamodb, aws, nosql, performance]7user-invocable: true8---910# DynamoDB Review1112Review DynamoDB for single-table design, GSI/LSI strategies, capacity, DAX, TTL, and Streams.1314## Key Checks15- All access patterns served by Query or GetItem (flag any Scan in application code)16- Single-table design with entity-type prefixes on PK/SK17- GSI partition key: high cardinality, even distribution; sparse GSIs for subset filtering18- Capacity: on-demand for spiky, provisioned+auto-scaling for predictable (70% target)19- DAX for read-heavy microsecond-latency (eventually consistent only)20- TTL as epoch seconds, filter expired items in queries (deletion is eventual ~48h)21- Streams: idempotent processing, 24h retention, DLQ for Lambda triggers22- BatchWriteItem/BatchGetItem over individual calls, exponential backoff for UnprocessedItems23- Transactions: 2x cost, max 100 items, idempotency token for retries24- Hot partition detection via CloudWatch Contributor Insights2526## Output27Severity-sorted: CRITICAL, HIGH, MEDIUM, LOW, PASSED.