DynamoDB designer tool

How it works

NoSQL Workbench from AWS works really well. However, I found the process of setuping up tables unnecessary hard.

I came with the idea, that the table and schema would be generated from the text input. You can set up your primary key and other GSI indexes. Also, you can click on these indexes and aggregate data into partitions.

Usage:

• By default primary key is always the first column (without any sortkey).
• Columns are always defined in the first line of the text such as "PK, SK, type" will generate three columns with a name PK, SK and type
• Text "#pk, $sk" will create column - primary key with name #pk and connected sort key $sk to this primary key
• You can create global secondary index with text "##pk2, $$sk2". The most important part is the count of the # and $, because they are matching together with the cound of these characters inside the name
• If you want to create more GSIs, just use more of these:
  ##pk1, $$sk1, ###thirdPK, $$$thirdSK, ####fourthXYZ, $$$$fourth_SK

• Try this example:
  (Copy and paste to the input above)

  #pk, $sk, ##pk1, $$sk2, info
  User-A, INFO, score, 3, Additional information
  User-A, Connection
  User-B, INFO, score, 4, Additional information
  User-C, INFO, score, 5, Additional information
  User-D, INFO, score, 1, Additional information
  

  Table is created with your data and indexes. Take a look at header of the table. The primary key and GSI indexes are clickable. By clicking on them, you activate aggregating data by this index (also sort by the appropriate sort key). With this way, you can explore access patterns much easier.
  Pretty cool hah?

What's missing:

• Items can be sorted by sort key only by string type for now
• For now, it can't sort items in table by another sort key (local secondary index)