A dynamodb-admin Alternative for Local and Live DynamoDB
dynamodb-admin is the free,
MIT-licensed web GUI most developers reach for when they spin up
DynamoDB Local or LocalStack. You run it as a small
Node server (npm install -g dynamodb-admin), point it at an endpoint, and browse
your local tables. It's excellent at that one job. This page is for when you've
outgrown it — and want a client that handles local and live AWS tables, with
filtering, inline editing, and a SQL Workbench. DynoTable is a cross-platform
desktop DynamoDB client built around that Workbench.
What dynamodb-admin is good at
dynamodb-admin's README describes it plainly: a "GUI for DynamoDB Local, dynalite, localstack etc." (README). It's the right tool when you're working against a local endpoint:
- Free and open source (MIT), so there's nothing to buy and nothing to license (licence).
- Zero install friction —
npm install -g dynamodb-adminand you have a web UI onlocalhost:8001(the default--port), pointed by default athttp://localhost:8000(README). - A Docker image — the official
aaronshaf/dynamodb-adminimage on Docker Hub drops straight into adocker-composenext toamazon/dynamodb-local. It readsHOST,PORT,BASE_PATHandDYNAMO_ENDPOINTenv vars (README), so it wires cleanly into a containerized dev stack. - Create, browse and edit tables through a simple web interface while you develop, without touching the AWS Console.
By default it sets accessKeyId / secretAccessKey to the dummy values key and
secret and the region to us-east-1
(README) — which tells you
exactly what it's built for: the local-development inner loop.
Can dynamodb-admin connect to live AWS DynamoDB?
Technically yes — and this is the most common thing people try once a local-only admin UI isn't enough. You override the endpoint and supply real credentials:
# Point dynamodb-admin at a real region instead of localhost
AWS_REGION=eu-west-1 \
AWS_ACCESS_KEY_ID=AKIA... \
AWS_SECRET_ACCESS_KEY=... \
dynamodb-admin --dynamo-endpoint=https://dynamodb.eu-west-1.amazonaws.comOr pass --skip-default-credentials so it stops injecting the dummy key/secret
and falls back to the standard AWS SDK credential resolution instead
(README).
That works, but it's off the happy path. dynamodb-admin's documented options are the endpoint, host, port, base path and a credentials toggle (README) — there's no connection manager, no profile picker, no SSO. Switching accounts or regions means stopping the Node process and relaunching it with different env vars. Fine for an occasional peek at a prod table; friction as a daily driver across several accounts.
Where dynamodb-admin stops
The boundary shows up as your work moves beyond a single local table:
- Live AWS tables are off the happy path. As above — you can point it at a real region, but it's documented and defaulted around DynamoDB Local, with no saved connections or profile switching.
- No relational queries. Like any visual browser, it lists and edits items in
one table. It can't join two tables,
GROUP BY, or compute aCOUNT/SUM, because DynamoDB has no relational query engine underneath. dynamodb-admin doesn't add one — and neither does PartiQL: itsSELECTgrammar takes a singleFROMtable with noJOIN,GROUP BY, or aggregate functions (AWS PartiQLSELECTreference) (see PartiQL vs SQL). - It's a browser tab on a server you run. No native desktop app, no saved
connections across projects, no integrated credential chain — you keep a Node
process (or container) running and bookmark
localhost.
None of these are bugs. They're the edge of a deliberately small local-dev tool. The question is whether your workflow has crossed it.
What you gain moving to a full DynamoDB client
A desktop DynamoDB client closes the gap two ways. First, one app for local and live: the same UI connects to DynamoDB Local, LocalStack and your real AWS accounts, reading your standard AWS credential chain (profiles, SSO, env vars) instead of relaunching a server per environment. Second, a real query surface on top of browsing — key and filter conditions, inline editing, PartiQL, and SQL.
DynoTable connects to local and live DynamoDB from one desktop app, using the AWS profiles and access keys you already have. Your data stays in DynamoDB, so there's nothing to migrate. On top of browsing and inline editing, its headline feature is the SQL Workbench.
SQL within DynamoDB's access-pattern rules
A plain visual client — dynamodb-admin included — scans and filters a single table.
It can't join two tables, group rows, or aggregate, because DynamoDB exposes no
relational engine — even PartiQL's SELECT is single-FROM with no JOIN,
GROUP BY, or aggregates
(AWS PartiQL SELECT reference).
DynoTable's SQL Workbench compiles SQL — INNER/LEFT JOIN,
GROUP BY, COUNT, SUM and friends — down to DynamoDB's real Query / Scan
operations on the client. You write relational-shaped SQL; DynoTable plans it
against your keys and GSIs, so it stays within DynamoDB's access-pattern rules
rather than pretending the table is relational. If you've hit the wall where even
PartiQL stops, SQL for DynamoDB and the
PartiQL vs SQL guide explain what's missing and how the
Workbench fills it.
-- The kind of query a single-table browser can't express:
SELECT u.email, COUNT(o.id) AS orders, SUM(o.total) AS revenue
FROM Users u
JOIN Orders o ON o.userId = u.id
GROUP BY u.email;Building those key and filter conditions by hand is fiddly; the free
DynamoDB Expression Builder generates the
KeyConditionExpression / FilterExpression and attribute-name/value maps for you —
no install required.
Does DynoTable work with DynamoDB Local like dynamodb-admin?
Yes — DynoTable runs against your local endpoints when you want it to, so it isn't a "live-only" replacement. See connecting to DynamoDB Local and LocalStack for the endpoint and fake-credentials setup. It covers the same local inner loop dynamodb-admin does, plus the live tables and queries it can't.
Honest take: when dynamodb-admin is enough
If you only ever browse a local DynamoDB instance during development, want something free and open source, and never need to touch live tables or run a JOIN, dynamodb-admin is the pragmatic choice — keep it. DynoTable is a paid desktop app; it earns its place when you work across local and live accounts, want saved connections and your real AWS credential chain, or have hit a query a single-table browser can't express.
Download DynoTable for macOS, Windows or Linux, point it at the same profile you use today, and run a query you couldn't express before. See pricing for current plans, and DynoTable as a DynamoDB GUI for the broader picture.
FAQ
Is DynoTable a dynamodb-admin alternative?
For local-only development, dynamodb-admin is free and excellent. DynoTable is the alternative when you also need live AWS tables, saved connections through your AWS credential chain, and a SQL Workbench that runs JOINs, GROUP BY and aggregates — none of which a single-table local browser provides.
Can dynamodb-admin connect to live AWS DynamoDB?
Technically yes — you override --dynamo-endpoint to a real region and supply
credentials (with --skip-default-credentials and the standard AWS env vars
(README)). But it's built and
defaulted around DynamoDB Local, with no connection manager or profile switching, so
live use is off the happy path.
Is there a dynamodb-admin Docker image?
Yes — aaronshaf/dynamodb-admin is published on
Docker Hub and configured via
the HOST, PORT, BASE_PATH and DYNAMO_ENDPOINT env vars, so it sits next to
amazon/dynamodb-local in a docker-compose
(README). DynoTable is a
desktop app, not a container, so there's no image to run — it connects directly to
your local endpoint or live account.
Does DynoTable work with DynamoDB Local like dynamodb-admin?
Yes. DynoTable connects to local endpoints — DynamoDB Local and LocalStack — as well as live AWS accounts, from the same desktop app. See the local connection guide.
Can dynamodb-admin run SQL or join tables?
No. dynamodb-admin browses and edits one table at a time; it has no SQL surface, and
DynamoDB itself has no relational engine — even PartiQL's SELECT is single-FROM
with no JOIN, GROUP BY, or aggregates
(AWS PartiQL SELECT reference) —
so JOIN, GROUP BY and
aggregates aren't possible without a client that plans them. DynoTable's
SQL Workbench compiles those down to DynamoDB's real Query / Scan operations.
Related
- Browse the full comparison hub for every DynoTable alternative.
- See also DynoTable as a DynamoDB GUI.
- New to local DynamoDB? Read DynamoDB Local and connecting to DynamoDB Local & LocalStack.
- Need relational queries? See SQL for DynamoDB, DynamoDB JOIN and DynamoDB GROUP BY.
Last verified 2026-06-10. dynamodb-admin is MIT-licensed open-source software by its respective authors; referenced here for identification only.