Introduction
Dynomate is a desktop client for DynamoDB, Amazon Athena and Amazon Aurora DSQL. 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 and Aurora DSQL clusters 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.
- Run SQL on Aurora DSQL clusters, and view and edit table rows.
- Save repeatable DynamoDB, Athena and Aurora DSQL 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.
Connect to Aurora DSQL
Discover a cluster, choose a database role, and test the connection.
Query Aurora DSQL
Run SQL, manage transactions, and view and edit table rows.
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.
For Aurora DSQL clusters, Dynomate stores connections, network settings, imported CA bundles and table descriptions on this computer. It does not store passwords or IAM authentication tokens, and it keeps table rows only in temporary console results. The desktop app connects directly to the cluster over TLS.
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, Aurora DSQL, and update failures.