dynamodb-design

Design Amazon DynamoDB tables with key patterns, GSIs, and TTL.

Updated Feb 26, 2026
One-click install
npx skills add https://github.com/engineers-hub-ltd-in-house-project/eh-skills --skill dynamodb-design
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dynamodb-design
Source: https://github.com/engineers-hub-ltd-in-house-project/eh-skills/tree/main/skills/aws-infrastructure/dynamodb-design
Command: npx skills add https://github.com/engineers-hub-ltd-in-house-project/eh-skills --skill dynamodb-design

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the complexities of designing efficient and scalable Amazon DynamoDB tables, helping you avoid common pitfalls and optimize for performance and cost.

Core Features & Use Cases

  • Key Design Patterns: Learn best practices for partition key and sort key design.
  • Global Secondary Indexes (GSI): Understand how to implement GSIs for diverse query patterns.
  • Single Table Design: Master the technique of consolidating multiple entity types into a single table.
  • Capacity Management: Choose between On-Demand and Provisioned capacity, and configure auto-scaling.
  • Data Lifecycle: Implement Time-To-Live (TTL) for automatic data expiration.
  • Event-Driven Architectures: Utilize DynamoDB Streams for real-time data processing.
  • Transactions & Backup: Ensure data consistency with transactions and robust backup strategies.

Quick Start

Use the dynamodb-design skill to generate a Terraform configuration for a DynamoDB table with GSIs and TTL enabled.

Frequently Asked Questions about dynamodb-design

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

FAQPage Schema
What is single table design in DynamoDB and when should I use it?

Single table design in DynamoDB consolidates multiple entity types into one table to optimize query performance. Use this NoSQL data modeling technique when you need diverse access patterns and want to minimize cross-table joins.

How do I design DynamoDB partition keys and sort keys for efficient queries?

Design DynamoDB partition keys to distribute traffic evenly and sort keys to support range queries. Following these key design patterns prevents hot partitions and ensures efficient data retrieval across your NoSQL data models.

How do I configure DynamoDB Global Secondary Indexes using Terraform?

You configure DynamoDB Global Secondary Indexes (GSIs) by writing Terraform HCL to define index keys and projections. This enables diverse query patterns on your table without duplicating data into separate tables.

Should I choose On-Demand or Provisioned capacity mode for my DynamoDB table?

Choose On-Demand capacity for unpredictable workloads and Provisioned capacity with auto-scaling for steady traffic. Proper capacity management ensures your DynamoDB tables remain cost-effective while maintaining performance.

How do DynamoDB Streams work for event-driven architectures?

DynamoDB Streams capture item-level modifications in your table in near real-time. Utilize these streams for event-driven architectures to trigger downstream serverless processing pipelines automatically.

Can I use DynamoDB transactions to ensure data consistency?

Yes, DynamoDB transactions ensure data consistency across multiple items. Apply transactional operations when you need atomic writes or reads across various entities within your NoSQL data modeling workflows.