dynamodb

The DynamoDB skill provides AI agents with expert-level knowledge to architect and maintain high-performance NoSQL database solutions on AWS. It is designed for cloud engineers, software developers, and system architects who need to build scalable, predictable data layers using AWS managed services. This skill acts as a bridge between high-level architectural requirements and low-level implementation details, covering everything from initial table creation to complex data access patterns.

• Expert guidance on single-table design principles, including effective use of Partition Keys (PK), Sort Keys (SK), and composite key structures.

• Deep technical support for implementing Global Secondary Indexes (GSI) and Local Secondary Indexes (LSI) to optimize read performance.

• Comprehensive code generation capabilities for CRUD operations using the Boto3 SDK for Python and standard AWS CLI commands.

• Strategic advice on capacity management, contrasting Provisioned throughput with On-Demand scaling modes based on workload predictability.

• Troubleshooting assistance for common issues like ProvisionedThroughputExceededException, conditional write failures, and query bottlenecks.

• Use this skill when designing your database schema to ensure efficient data distribution and avoid hot partitions.

• Rely on it for complex query implementations, including filter expressions, projections, and pagination logic to minimize consumed capacity units.

• Utilize the provided patterns for optimistic locking and batch operations to maintain data integrity across distributed microservices.

• Best practices include keeping access patterns in mind before implementation, as DynamoDB requires query-first modeling, unlike traditional RDBMS.

• The skill maintains current knowledge of AWS best practices to ensure that your infrastructure is secure, performant, and cost-effective throughout its lifecycle.