Introduction
Dynomate is a desktop client for DynamoDB and Amazon Athena. It uses your AWS profiles to discover resources, open tab-scoped workspaces, and run operations.
New to Dynomate? Install the app and follow the Quick Start. You can start free, and try every feature with a 14-day trial.
What Dynomate does
- Discover DynamoDB and Athena tables by profile and Region.
- Scan, Query, inspect, stage, and apply DynamoDB item changes.
- Import data from JSON, CSV, S3, or another DynamoDB table.
- Download current results and export full tables.
- Create local DynamoDB snapshots and query them with SQL.
- Run Athena SQL with workgroup and S3 output settings.
- Save repeatable DynamoDB and Athena operations as DNML request files.
- Run the same request files from a terminal or CI with
dynomate-cli.
Choose a workflow
Work with a table
Discover a table, run a Scan or Query, inspect rows, and review staged changes.
Query a local snapshot
Export a DynamoDB table to a local artifact and run SQL against the snapshot.
Query Athena
Choose an Athena table, configure a workgroup, and run or cancel SQL.
Run saved requests
Store reusable operations in a local collection folder.
Read and write DNML
Learn the request file format, its expressions and every operation's keys.
Run requests from the CLI
Run a request file from a terminal or CI job with the same runtime as the app.
Understand local data
Request collection files and SQL snapshot artifacts stay on the local filesystem unless you move or share them. Dynomate does not include hosted collection sync, built-in Git operations, or a team workspace. AWS calls go from the desktop app to the AWS endpoints for the selected profile.
Get help
Open JSON Inspector to inspect a selected row. Open Logs to review operation and AWS activity. Use the troubleshooting guide for common authentication, permission, data movement, SQL, Athena, and update failures.