DynamoDB JSON converter

Paste an item as plain JSON or DynamoDB JSON — get the other format, or a ready PartiQL statement.

{
  "AnimalType": {
    "S": "Dog"
  },
  "Name": {
    "S": "Fido"
  },
  "Age": {
    "N": "8"
  },
  "Colors": {
    "L": [
      {
        "S": "White"
      },
      {
        "S": "Brown"
      },
      {
        "S": "Black"
      }
    ]
  }
}

Runs in your browser. Nothing you type is sent anywhere.

How this works

Do this against your live database in Tablyne.

DynamoDB GUI →

FAQ

Why does DynamoDB JSON store numbers as strings? +

To avoid precision loss across languages and JSON parsers — DynamoDB's number type supports up to 38 significant digits, more than a JSON double can hold exactly.

Can this convert sets (SS/NS/BS)? +

Yes, when converting DynamoDB JSON to plain JSON — sets become arrays. Plain JSON has no set type, so converting the other way always produces a List (L), same as the AWS SDK's own marshaller. Converting to PartiQL instead renders them as PartiQL sets.

What happens with a huge N value or binary (B/BS) data? +

An integer too large for a JS number refuses to convert to plain JSON (to avoid silently rounding it) but still converts fine to DynamoDB JSON or PartiQL, where it keeps its exact digits. Binary has no PartiQL literal at all (AWS's own docs: "Only supported through code"), so PartiQL output refuses with a clear message instead of guessing.

Does this call AWS or my table? +

No. It only transforms the text you paste, entirely in your browser.