PartiQL editor

PartiQL thatknows your table.

Write SQL-shaped statements against DynamoDB. Completions follow your cursor, an advisory strip names the access pattern before you run, and one toggle turns the results grid writable with every save staged as a pending change.

Completions that read your schema. Field suggestions with their types follow your cursor through SELECT and WHERE, filtered as you type. Table names, SQL keywords, and DynamoDB functions like BEGINS_WITH and CONTAINS are a keystroke away.

Know the plan before you run. The advisory strip classifies every statement as you write it: GetItem, index query, or scan. A full scan against a production workspace goes red, so you see it before you run it.

Flip the results writable. One toggle adds the key column to the projection and re-runs the statement. Cells edit in place, and every save stages as a pending change instead of writing straight to the table.

Reads and writes, one editor. UPDATE ships through the same editor with the same advisory. Run it, get the confirmation, then re-run your SELECT and watch the row come back changed.

The editor, up close

01Real code editor

CodeMirror underneath: SQL syntax highlighting, bracket matching, and a fast, lightweight feel.

02Schema-aware completions

Fields with their types after SELECT and WHERE, plus table names, SQL keywords, and DynamoDB functions.

03Advisory strip

Every statement classified before it runs: GetItem, index query, or a red full-scan warning on prod.

04One keystroke to run

Run with the button or Cmd/Ctrl+Enter. Large result sets page in via NextToken.

05Editable results

Flip one toggle: the key column joins the projection, the statement re-runs, and cells become editable.

06Capacity tracking

Consumed read and write capacity per execution, so expensive statements stand out immediately.

Schema-awareCompletions read your table, not a keyword list.
Classified up frontGetItem, index query, or scan, named before you run.
Writable resultsOne toggle turns the grid into an editor.
Staged, not firedGrid saves land as pending changes you review.

Run your firststatement in minutes.