Dynamodb Table Designer

What it does

This skill helps design DynamoDB tables by generating table schemas based on user-provided descriptions. It can create primary keys, secondary indexes, and define data types for attributes within the table. The generated schema is ready to be implemented directly into your AWS environment.

When to use it

• You need a DynamoDB table designed but aren't sure where to start with schema definition.
• You want to quickly prototype different DynamoDB table structures for an application.
• You are exploring optimal data modeling approaches for specific use cases within DynamoDB.
• You’re refactoring existing DynamoDB tables and need assistance generating a new schema.

Key capabilities

• Generates DynamoDB table schemas.
• Defines primary keys (partition and sort).
• Creates secondary indexes.
• Specifies attribute data types.

Example prompts

• "Design a DynamoDB table to store user profiles, including name, email, and address."
• "Create a DynamoDB schema for order information with attributes like order ID, customer ID, date, and total amount."
• “Generate a DynamoDB table for storing product catalog data, including product name, description, price, and category.”

Tips & gotchas

The quality of the generated schema depends heavily on the clarity and detail provided in your prompt. Be specific about the attributes you need and any relationships between them to ensure an optimal design.