DynamoOps
Getting started

Quick start

A five-minute tour: connect to an AWS account, open a table, run a filtered scan, fix a value inline and export the result.

1. Connect to an account

Quick Connect with a region, an AWS CLI profile and an environment tag.
  1. Pick a region and profile

    On the Quick Connect tab, choose your AWS Region, type the name of a profile from ~/.aws/credentials in AWS Profile (or leave default), and optionally tag the connection with an Environment such as Dev or Prod.

  2. Save it for next time

    Tick Save this connection and give it a name like “Staging — eu-west-1”. It will appear under Saved Profiles for one-click reconnects.

  3. Connect

    Click Connect to DynamoDB. DynamoOps validates the connection with a lightweight ListTables call, then shows your tables in the sidebar.

Tip
Need cross-account access or SSO? See Assume Role and AWS SSO. Working locally? See DynamoDB Local and LocalStack.

2. Open a table

Press ⌘+K to focus the sidebar search, type part of a table name and click it. The table opens in a new tab and DynamoOps immediately runs a Scan of the first 50 items. The info bar above the grid shows the item count, partition and sort key, and any secondary indexes.

Open as many tables as you like. Each tab remembers its own query, filters, page and view mode. Switch tabs with ⌘+] and ⌘+[.

Each table opens in its own tab, with its keys and indexes in the info bar.

3. Run a filtered query

Click ⚙ Filters to reveal the query panel. In Scan mode, type a DynamoDB filter expression and its attribute values, then press ⌘+↵.

Filter Expression
attribute_exists(email) AND #status = :active
Expression Attribute Names / Values
{"#status": "status"}
{":active": "active"}

Prefer SQL? Switch to SQL mode and start typing. Autocomplete suggests table names after FROM, attributes after WHERE, and operators after an attribute. The result bar reports how many items were returned, how many were scanned, the consumed RCU and the elapsed time.

A filtered Scan. The result bar shows returned versus scanned items and the RCU consumed.

4. Fix a value inline

Double-click a cell to edit it in place.

Double-click any cell in the table view, change the value and press ↵. DynamoOps writes an UpdateItem for that single attribute and stores the previous version locally so you can diff or restore it later from the 🕐 history button on the row.

5. Export what you see

Click ⬇ JSON or ⬇ CSV. Choose which fields to include, or tick Export entire table to let DynamoOps page through every item behind your current query. The file is saved as <table>_data.json or <table>_data.csv.

Pick the format and fields, or export everything behind the current query.

That is the whole loop. From here, explore the feature guides in the sidebar for the details behind every button, or keep the keyboard shortcuts at hand.

Related