"Dynobase should absolutely be your go to tool for DynamoDB data modeling."
Rick Houlihan
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.
![Section image](/static/146111ecc21b0ed048b9e72cd4c149c1/fc1a1/access-patterns.png)
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.
![Section image](/static/58f9bc2bf02673fd899e2071b55cc99f/0c6bd/designing-items.png)
Smart Suggestions
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.
![Section image](/static/da810b636796825c2b5afe32699abca1/2ef76/smart-suggestions.png)
Models View
Big single-table models can quickly get overwhelming. Get a bird's-eye view of your model from a different perspective.
![Section image](/static/0911f716fd03a277b0647d7ff6833cc4/30ad0/models-view.png)
Exporting Models
Once you're satisfied with your design, you can export it to popular libraries format like OneTable or DynamoDB-Toolbox.
![Section image](/static/56bad5649d12c21f693d3887c6047e87/9ea8b/exporting-models.png)
Referential Integrity
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.
![Section image](/static/c70c9c1b02750b5b344e594dca22158d/83a53/referential-integrity.png)
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.
![Section image](/static/0c12cbc5c97a1b5e1d1ce86598ca034f/bda2d/deploy-to-aws.png)
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 avatar](/static/53630854847e0c93d4c42b7cbcd98e36/19e71/alex.jpg)
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 avatar](/static/a243b31bd70faae63b7224b028ced13c/2c84b/yan.png)
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.
![Erik Peterson avatar](/static/8564aa1a79d6cb6be409cbeec40b5b30/e07e1/erik.jpg)
Erik Peterson
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 2021I am FINALLY setting time aside to check out @dynobase!!
Awesome stuff so far: the capacity consumption feedback, and the configurable maximums around paginated reads and page sizes.
Strong work @rafalwilinski 馃挭
As a public service announcement, if you use DynamoDB and you haven't tried Dynobase (https://dynobase.dev)... you should.
1:27 AM 路 Jan 15, 2020"Well done! I use Dynobase everyday. Happy customer! 馃挭
3:23 PM 路 Apr 10, 2020Two things every DynamoDB fan should have.
@alexdebrie's http://DynamoDBBook.com and @rafalwilinski @dynobase client
I was given a license for @dynobase a little while ago, and it's quickly crept into my dev workflow. So much easier to interact with DynamoDB, over the AWS console. I would say if you work with DynamoDB it's a must have tool.
1:55 PM 路 Jul 13, 2020As a frontend developer, I used to be straight up _scared_ of databases 馃槺
Things changed when I started using AWS DynamoDB at work but as awesome as it is - the DynamoDB Web Console is not perfect
@dynobase makes DynamoDB *much* easier to work with 馃コ
If you are interested in a great #DynamoDB client, this one is fantastic.
And no, I am not forsaking #NoSQL Workbench. I just really like the work that the Dynobase team does and they make a great product.
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: