Does this skill support multi-table designs?

While it can be adapted, it is specifically optimized for single-table design patterns, which is the recommended best practice for DynamoDB performance and scalability.

Can I use this for an existing DynamoDB table?

Yes, the skill can analyze existing table designs to help you safely integrate new entities or additional access patterns into your current production schema.

How does it handle complex sorting requirements?

The skill designs composite sort keys (SK) using techniques like zero-padding and hierarchical prefixes to support precise range queries and specific sorting needs.

What is the input for the DynamoDB Table Design skill?

It requires an access patterns markdown file, typically generated by the dynamodb-access-patterns skill, detailing how data will be read and written in your application.

DynamoDB Table Designer

Name: DynamoDB Table Designer
Author: walis85300

bywalis85300

•

数据库管理

Designs optimized DynamoDB single-table structures by mapping complex access patterns to efficient primary keys, GSIs, and query operations.

This skill automates the complex process of DynamoDB single-table design, transforming business access patterns into a concrete technical schema. It guides developers through grouping entities into item collections, designing hierarchical primary and sort keys with standard separators, and strategically implementing Global Secondary Indexes (GSIs) to minimize costs. By mapping every specific access pattern to a concrete DynamoDB operation, it ensures 100% data model coverage and provides a robust foundation for generating production-ready query interfaces.

主要功能

01Automated entity grouping into optimized item collections based on data relationships

02Advanced PK/SK design using industry-standard composite key and separator conventions

034 GitHub stars

04Comprehensive mapping of every access pattern to specific DynamoDB operations

05Strategic GSI overloading to minimize infrastructure costs and stay within limits

06Built-in validation against NoSQL best practices including sparse indexes and zero-padding

使用场景

01Converting application requirements into a high-performance single-table schema

02Refactoring existing database structures to support new multi-entity access patterns

03Designing complex hierarchical data models with range queries and sorted results

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add walis85300/marketplace dynamodb-table-design

For use in Claude.ai and ChatGPT

Download Skill