Visual query builder

Queries youcan read.

Build key conditions and filters as pills that know your key schema. Dynomatic compiles the optimal native expression underneath and lands the results in a table you can edit in place.

No expression syntax required. Pills know your key schema: real attribute names and typed values, not #placeholders and :bindings. Dynomatic compiles the optimal expression underneath, in the open.

Query when you can, Scan when you mean to. The builder reads your table's key schema and indexes, offers the access paths that exist, and never quietly downgrades a Query into a Scan.

Edit in place, type-aware. Every DynamoDB type gets the right inline editor. Numbers stay numbers, booleans toggle, sets stay sets, and composite keys stay locked until you say otherwise.

Open any item as JSON. The Edit JSON sheet sits beside the table with the whole item in plain JSON, and one toggle flips it to the exact DynamoDB shape, typed attribute values and all. The typed shape is also the only place to create sets (SS, NS, BS) and big ints, because plain JSON can't express them: a set is indistinguishable from a list, and numbers past 2⁵³ lose precision.

Nothing writes until you say so. Edits stage into a pending set with a visible diff. Review every change, revert any of them, and commit when it is right, with prod labeled in red the whole way.

The builder, up close

01Key conditions

PK and SK pills with every operator DynamoDB supports, validated against your key schema.

02Filter expressions

Stack filters with AND and OR, grouped visually, compiled to a single native expression.

03Index aware

Primary and every GSI and LSI, listed with their key attributes so you pick a path, not a guess.

04JSON sheet

Open any item as JSON beside the table, edit either view, and both stay in sync.

05Capacity per query

RCU, item count, and latency on every run, recorded in command history.

06Export anywhere

Results to JSON, CSV, the clipboard, or straight to S3, one menu away.

Schema detectedKeys, types, and indexes read from the table itself.
Optimal expressionsThe compiled request is always visible and always native.
Staged writesEvery edit reviewed before it touches the table.
Template variablesPin values per environment and retarget a query in one switch.

Build your firstquery in minutes.