SingleTable
DynamoDB schema design, done right.
Single-table DynamoDB design is powerful and unforgiving. The wrong key structure means a migration across millions of items. The right one handles every access pattern efficiently at any scale. This site is a library of production-tested patterns, with full PK/SK designs, GSI strategies, and ElectroDB entity code.
Visual schema designer coming soon. → Get notified.
Schema Patterns
- →
Marketplace (Two-Sided)
A complete single-table DynamoDB schema for a two-sided marketplace - buyers, sellers, listings, orders, and mutual reviews. Access patterns, GSIs, and ElectroDB code.
- →
Analytics Events
A production-ready DynamoDB schema for high-volume analytics events with write-sharded ingestion, session aggregation, and TTL-based data lifecycle.
- →
Workflow/State Machine
A production-ready DynamoDB schema for workflow execution with ordered steps, state transitions, and execution history.
- →
Inventory Management
A production-ready DynamoDB schema for inventory management with atomic stock updates, warehouse tracking, and movement history.
- →
Content Management (CMS)
A production-ready DynamoDB schema for a headless CMS with articles, authors, categories, tags, and content versioning.
- →
Booking/Scheduling
A production-ready DynamoDB schema for booking and scheduling with atomic slot reservation, provider availability, and double-booking prevention.
- →
IoT Time-Series
A production-ready DynamoDB schema for IoT device readings with time-range queries, TTL-based data lifecycle, and pre-computed aggregations.
- →
Chat/Messaging
A production-ready DynamoDB schema for chat and messaging with conversations, paginated messages, read receipts, and unread counts.
- →
Social Media Feed
Fan-out on write vs fan-out on read - the two approaches to social feeds in DynamoDB, when to use each, and a production-ready schema with ElectroDB.
- →
E-Commerce Orders
A production-ready DynamoDB schema for e-commerce orders with 8 access patterns, status-based GSI, and full ElectroDB entity definitions.
- →
SaaS Multi-Tenant
A complete single-table DynamoDB schema for SaaS multi-tenant apps. Access patterns, PK/SK design, GSIs, sample data, and ElectroDB entity code.
Guides
Need a schema review?
Async DynamoDB schema reviews - PK/SK design, GSI strategy, ElectroDB entity definitions, and cost analysis. Built from real production systems.
See review tiers →