data-review

Reviews data persistence designs for performance and reliability issues.

6|1|Updated Mar 30, 2026
One-click install
npx skills add https://github.com/wesleyosantos91/multi-agents --skill data-review-wesleyosantos91
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-review
Source: https://github.com/wesleyosantos91/multi-agents/tree/main/devin/.devin/skills/data-review
Command: npx skills add https://github.com/wesleyosantos91/multi-agents --skill data-review-wesleyosantos91

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about data-review

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I review my DynamoDB data model to prevent hot partitions and ensure idempotency?

To review your DynamoDB data model for hot partitions and idempotency, validate your schema design and access patterns against your specific query plans. This prevents performance regressions by ensuring idempotent operations and proper key distribution.

What is the best way to choose between DynamoDB and RDS Aurora for my access patterns?

Choosing between DynamoDB and RDS Aurora requires evaluating your access patterns to justify the database selection. Reviewing data persistence ensures clear rationale for either schema based on how your application reads and writes data.

How do I optimize SQL queries to avoid N+1 behavior and full table scans in RDS?

To optimize SQL queries and avoid N+1 behavior and full table scans in RDS, review your query plans and index strategy. Validating relational indexes against your access patterns ensures optimized query performance and correctness.

Does my database design need RDS Proxy configuration for Lambda integration?

Your database design needs RDS Proxy configuration for Lambda integration to manage connection pooling and prevent connection exhaustion. Reviewing this runtime integration guidance ensures operational readiness for serverless compute environments.

When do I need to validate backup and KMS encryption requirements for my data persistence layer?

You need to validate backup, PITR, and KMS encryption requirements for your data persistence layer during operational readiness checks. Reviewing these configurations ensures production reliability and security compliance for your database.