# Using NoSQL Workbench for a Local DynamoDb

In my [previous tutorial](https://pninan.hashnode.dev/how-to-containerize-dynamodb), I taught you how to use [Docker](https://www.docker.com) to spin up a local [DynamoDb](https://aws.amazon.com/dynamodb/). Using a local DynamoDb can be tricky to manage because there is no default utility to manage the database tables. Today, I am going to show you use to use [AWS NoSQL Workbench](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.html) to manage your local DynamoDb. 

## Prerequisite
[Download and install](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.settingup.html) AWS NoSQL Workbench.

## Using NoSQL Workbench

1. Add a new database connection.
![Screen Shot 2021-01-25 at 12.14.24 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552477187/XHmKd7Lq4.png)

2. Click "Data Modeler". Then let's create a data model for the database.
![Screen Shot 2021-01-25 at 12.15.39 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552522386/kJsGiJl0_.png)

3. Create a table.
![Screen Shot 2021-01-25 at 12.16.23 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552782538/A_cgF7F4I.png)

4. Click "Visualize data model".
![Screen Shot 2021-01-25 at 12.16.51 AM 2.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552833650/nmlSvbnjd.png)

5. Commit the model to your local database.
![Screen Shot 2021-01-25 at 12.17.12 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552867631/LDZYE80dc.png)
![Screen Shot 2021-01-25 at 12.17.27 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552894529/rnDajMVmG.png)

6. Open the connection to your local database.
![Screen Shot 2021-01-25 at 12.18.31 AM 2.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552919420/w5gUlCXWq.png)

7. Add data to your table.
![Screen Shot 2021-01-25 at 12.19.49 AM 2.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552950168/uc1C24sYk.png)
![Screen Shot 2021-01-25 at 12.20.12 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552986721/YAHYItMJh.png)
![Screen Shot 2021-01-25 at 12.20.32 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611552997764/RZ214bYWj.png)

8. That's it! Scan your new table.
![Screen Shot 2021-01-25 at 12.37.02 AM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1611553062667/5EkOa6bqo.png)

## Conclusion
This should be enough information to get you started! You can toy around with adding data and preparing queries. This is a very useful tool for modeling your data and creating indexes. I will be preparing more tutorials coming soon! Enjoy -- Cheers!