Amazon AWS DynamoDB Desktop Client - Does one exist? [closed]

Question

Been looking around on the web for one of these, but I'm only finding node.js/ruby hosted implementations.

I'm keen to have a DynamoDB app, something like that of the navicat ilk that comes with an msi installer to get running quickly.

Maybe there's a valid reason as to why one of these doesn't exist yet?

Concupiscence

Could you please comment on the hosted implementations you are referring to? This would ease comparing the desired feature set, thanks. – Timbre

Helping for the newcomers, 1. Amazon just released workbench here aws.amazon.com/tr/about-aws/whats-new/2019/09/… There is also a tool called 'dynobase' , it has a free version. dynobase.dev If you want new features you can ask the developer, he is on reddit. reddit.com/r/aws/comments/dg0o9e/… – Wan

docs.aws.amazon.com/amazondynamodb/latest/developerguide/… – Plumbery

The official one from amazon is NoSQL Workbench: docs.aws.amazon.com/amazondynamodb/latest/developerguide/… – Sucking

Disclaimer: I'm creator of this software. Try dynobase.dev – Firebreak

Answer 1

I'm not aware of a dedicated desktop application for using Amazon DynamoDB from Windows yet.

However, the AWS Toolkits for Eclipse and Visual Studio both allow you to create tables, insert and edit data, initiate table scans, and more, straight from your local development environment (see the introductory post AWS Toolkits for Eclipse and Visual Studio Now Support DynamoDB).

So depending on your use case this might be all you need (or even better, if this is targeting a development scenario).

---

Update

The AWS team has just announced the option to Explore Your DynamoDB Tables Using the AWS Management Console as well:

You can now view and modify the contents of your DynamoDB tables from within the AWS Management Console. With the addition of this new feature, you can learn by doing -- trying out a number of DynamoDB features without even writing any code. You can create a table, add some items, and see them in the table, all through a very clean and simple user interface.

This is obviously a very convenient addition to the rich client options referenced in my initial answer above, please check out the post itself for a short illustrated tour to help you get started.

Timbre

Thanks - would use the VS plugin, but turns out that AWS now has a DynamoDB database explorer built in to the console. Handy! – Concupiscence

@ChrisWard: That's indeed very handy and I've added that information to a related answer yesterday accordingly, but refrained from doing so here due to the explicit request for a Desktop Client - given it triggered you closing the case I might as well add it here too though, thanks :) – Timbre

Neither toolkit seems to support editing List or Map values - a big problem if you are using dynamodb as a document store – Devaughn

docs.aws.amazon.com/amazondynamodb/latest/developerguide/… – Plumbery

@SteffenOpel You should update the answer to point this docs.aws.amazon.com/amazondynamodb/latest/developerguide/… – Dermot

Answer 2

If you are using DynamoDB local for development you can use the built-in DynamoDB shell: http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Tools.DynamoDBLocal.Shell.html

http://localhost:8000/shell

UPDATE: Amazon does also provide an official client: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.html

Feldman

It's unfortunate that it doesn't allow you to connect to a remote database. – Klaraklarika

And doesn't have a simple way to navigate through data but is script-based – Breazeale

Even more unfortunate, the page doesn't exist anymore. – Whacky

For local DynamoDBs you can also use Dynobase - dynobase.dev/dynamodb-local-admin-gui – Firebreak

Amazon now has an official client for accessing DynamoDB databases called NoSQL Workbench, installable directly or via brew/Chocolatey/etc. – Kopeck

FWIW, sqlite clients got me the data access I needed. – Inflight

Answer 3

RazorSQL Database GUI Tool for Amazon DynamoDB

http://razorsql.com/articles/razorsql_amazon_dynamodb.html

Laudanum

too bad it costs $100 per license – Vegetarian

and it's slow and error-prone – Perverted

Also from what I could gather the importing doesn't work. – Australia

and if you want to delete everything you need to select it one by one. They don't provide select all feature which is very frustrating. I need to delete everything before testing my feature and I have to select each row one by one. I can write a script to delete everything but if you are providing a utility and charging for it. You must provide everything – Minhminho

Answer 4

Amazon provides a local client for DynamoDb. It's a java jar and it runs on Linux and Windows.

It starts a server that binds to port 8000 at localhost (or you can specify another port when you start the server).

Download and unpack the desktop client, change the endpoint inside your app to localhost:8000, and then you can use the desktop client for DynamoDb.

Here you can download and read about installing the dynamodb desktop client.

Dorella

Unless the link has changed, that doesn't seem to be a desktop client; it is a local implementation of the DynamoDB protocol that doesn't allows you to write apps that use Dynamo without actually connecting to AWS (for development/testing purposes). – Mackie