dynamodb-designer

Design DynamoDB table schemas with primary keys, GSI/LSI indexes, and capacity planning.

1|Updated Feb 14, 2026
One-click install
npx skills add https://github.com/ynitto/sandbox --skill dynamodb-designer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dynamodb-designer
Source: https://github.com/ynitto/sandbox/tree/main/.github/skills/dynamodb-designer
Command: npx skills add https://github.com/ynitto/sandbox --skill dynamodb-designer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

DynamoDB table design is critical to achieving scalable performance and predictable costs. This skill guides you in crafting schemas that avoid hot partitions, choose effective primary keys, and plan indexing strategies for your workloads.

Core Features & Use Cases

  • Table design guidance for scalable primary keys and access patterns.
  • Index strategy with GSI/LSI recommendations to support common queries.
  • Transactional and capacity planning guidance for safe, predictable performance.
  • Use cases include user profiles, activity logs, and transactional data across services.

Quick Start

Create a DynamoDB table design plan aligned with your application's query patterns, then implement an indexed schema with appropriate capacity settings.

Frequently Asked Questions about dynamodb-designer

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

FAQPage Schema
How do I design DynamoDB tables to avoid hot partitions?

To design DynamoDB tables that avoid hot partitions, you must choose scalable primary keys that distribute traffic evenly across your data. This approach minimizes contention and maximizes query efficiency for high-throughput workloads.

When should I use GSI vs LSI for DynamoDB query optimization?

You should choose GSI vs LSI for DynamoDB query optimization based on your access patterns, using GSIs for querying across different partition keys and LSIs for sorting within a partition. This strategy ensures your indexes support common query requirements.

What is the best way to model transactional data in DynamoDB?

The best way to model transactional data in DynamoDB involves structuring your schema to support transactional operations while planning capacity for predictable performance. This ensures safe, consistent writes and reads for transactional workloads.

How do I structure a DynamoDB schema for user profiles and activity logs?

Structuring a DynamoDB schema for user profiles and activity logs requires aligning table structure with your application's specific query patterns. This enables efficient retrieval and scalable management of user and activity data across services.

Does DynamoDB table design require capacity planning for NoSQL workloads?

Yes, DynamoDB table design requires capacity planning for NoSQL workloads to achieve predictable performance and control costs. Planning your capacity settings ensures safe operation under scalable access patterns.