What problem does it solve?
Data persistence decisions can silently degrade performance and reliability if the database choice, data model, and query patterns are not validated early.
Core Features & Use Cases
- Database choice justification: Evaluates DynamoDB versus RDS/Aurora with clear rationale based on access patterns.
- Data modeling and access pattern validation: Checks schema design, access patterns, and index strategy (GSI/LSI vs relational indexes).
- Query performance and correctness: Targets optimized queries that avoid N+1 behavior and full scans, and ensures idempotency and hot-partition prevention.
- Operational readiness: Covers backup/PITR, KMS encryption, and runtime integration guidance such as Lambda placement and RDS Proxy for connection management.
- Use case fit: Guides reviews when the user provides a specific table, query, or database decision, focusing analysis on that scope.
Quick Start
Ask the AI to review your persistence layer for DynamoDB or RDS, using the provided table schema and the key query patterns you plan to run.