"Dynobase should absolutely be your go to tool for DynamoDB data modeling."
Inventor of Single-Table Design, Director Developer Relations @ MongoDB
7-day free trial. Available for macOS, Linux and Windows
Single-Table Design is a data modeling technique used to represent relational data structures inside a single NoSQL table in DynamoDB. It is about putting all your data in a smart and organized way into one table (not one table per entity type!). Use a combination of primary key and indexes to link the item together and access them in a fast and efficient way.
Planning Access Patterns
Planning how you're going to query your is essential in a single-table design. Dynobase helps you to design your access patterns in a WYSIWYG way.
Designing Your Items
Creating new items is as easy as editing an Excel file. Navigate through table space like through a spreadsheet. Use key bindings you're familiar with from other programs like 'Tab' to cycle through the cells.
It's easy to get lost in the data. Dynobase helps you make sure you're making correct decisions and proactively suggests you to think in collections.
Big single-table models can quickly get overwhelming. Get a bird's-eye view of your model from a different perspective.
Once you're satisfied with your design, you can export it to popular libraries format like OneTable or DynamoDB-Toolbox.
Composite keys are a must in a single-table design. Dynobase helps you in creating composite keys and makes sure they are always up to date, referring to other attributes.
Ready, Steady, Deploy!
All set? Dynobase will help you to deploy your DynamoDB Table to AWS Cloud. Using Infrastructure as Code? Dynobase will export a CloudFormation definition.
Still not convinced? Try it on your own.
First 7 days are on us, no strings attached.
7-day free trial No credit card required Available for macOS, Linux and Windows
I love using Dynobase to explore my tables with a native app rather than going to the AWS console in my browser.
One of my favorite features is the ability to save common queries for simple use later. As you're implementing your data model, I recommend saving queries for each of your application's access patterns to make it easy to debug collections of items later on.
Dynobase is quickly becoming an essential part of working with DynamoDB.
Alex DeBrie, AWS Data Hero
Author of DynamoDBBook.com and DynamoDBGuide.com
Dynobase is by far the most intuitive UI tool I've used for DynamoDB, it's leaps and bounds better than the AWS console and makes it really easy to manage DynamoDB tables in a multi-region, multi-account environment.
It's made my life so much easier and allowed me to focus on the things that actually matter to my clients.
Yan Cui, AWS Serverless Hero
Author of Production-Ready Serverless, Developer Advocate at Lumigo
There are two amazing things about Dynobase.
The first is that it took so long for such a great DynamoDB client to finally arrive and the second is that it was so worth the wait.
Founder & CTO of CloudZero
Endorsed by AWS Community
This will be my default modeling tool from now on. Nice job Rafal.5:14 am · 24 Sep 2021
"Well done! I use Dynobase everyday. Happy customer! 💪3:23 PM · Apr 10, 2020
Frequently Asked Questions
Why is Single Table Design popular in DynamoDB?
Single-table design allows you to minimize the number of tables you have to create, thereby minimizing your infrastructure's operational burden. Instead of scaling, managing, and keeping backups of multiple tables, you can just focus on one.
How to design Single Table Models in DynamoDB?
Planning is essential in a single-table design. You need to know what your data is, how it is related to each other, and most importantly, what your access patterns are - they will dictate how you should design your items. Dynobase helps with that. Our single-table designer allows you to create a schema for your data, plan access patterns and then use it to create a table and export its definition.
Where can I find more information about DynamoDB Single Table Design?
We highly recommend the following resources: