Dynoxide MCP Server: A Local DynamoDB for Coding Agents

• Lists the tables in the database

  Returns the names of all tables in the local DynamoDB emulator database.

  Try: “List all tables.”

  Read · list_tables

• Shows a table's schema and size

  Returns key schema, indexes, item count, size, stream and TTL settings in a flat format meant for assistants.

  Try: “Describe the Orders table.”

  Read · describe_table

• Creates a table

  Creates a table with a key schema and optional indexes, vector indexes, billing mode and tags.

  Try: “Create a Users table keyed by pk and sk.”

  Write · create_table

• Changes a table's settings

  Adds or removes indexes, changes stream settings, billing mode, table class or deletion protection.

  Try: “Add a GSI on email to Users.”

  Delete · update_table

• Deletes a table and its data

  Removes a table with all its data. The server makes an automatic snapshot first so you can restore it.

  Try: “Delete the Scratch table.”

  Delete · delete_table

• Reads one item by key

  Retrieves a single item by its primary key.

  Try: “Get user#1 from Users.”

  Read · get_item

• Inserts or replaces an item

  Writes an item, replacing any item with the same key. Conditional writes are supported.

  Try: “Put an item for user#2 in Users.”

  Write · put_item

• Edits an item's attributes

  Applies an update expression with SET, REMOVE, ADD or DELETE to one item. Condition checks are supported.

  Try: “Increment the login count for user#1.”

  Delete · update_item

• Deletes one item

  Deletes a single item by key, unless the table has deletion protection.

  Try: “Delete user#2 from Users.”

  Delete · delete_item

• Reads up to 100 items

  Fetches items from one or more tables in a single call.

  Try: “Get these 20 users by key.”

  Read · batch_get_item

• Writes or deletes up to 25 items

  Runs up to 25 put or delete operations across tables in one call.

  Try: “Delete these 10 test items.”

  Delete · batch_write_item

• Loads up to 10,000 items fast

  Bulk-inserts items into a table, overwriting items with the same key.

  Try: “Load this seed data into Users.”

  Write · bulk_put_items

• Finds items by key condition

  Queries a table or index with a key condition, filters, projections and paging.

  Try: “Find all orders for customer#5 after January.”

  Read · query

• Reads through a whole table

  Scans a table or index with an optional filter. The tool description tells assistants to prefer query when they know the partition key.

  Try: “Scan Users for accounts with no email.”

  Read · scan

• Finds nearest items in a vector index

  Runs an exact nearest-neighbour search over a vector index and returns the true top results.

  Try: “Find the 5 documents closest to this embedding.”

  Read · search_vectors

• Reads up to 100 items as one snapshot

  Gets several items atomically so they are consistent with each other.

  Try: “Read these three records together.”

  Read · transact_get_items

• Writes up to 100 changes all-or-nothing

  Runs put, update, delete and condition-check actions atomically. All succeed or all fail.

  Try: “Move 10 credits from user#1 to user#2 atomically.”

  Delete · transact_write_items

• Runs a PartiQL statement

  Executes one SELECT, INSERT, UPDATE or DELETE statement written in PartiQL.

  Try: “SELECT * FROM Users WHERE pk = 'user#1'.”

  Delete · execute_partiql

• Runs several PartiQL statements

  Executes a batch of PartiQL statements, which may be reads or writes.

  Try: “Run these three PartiQL inserts.”

  Delete · batch_execute_partiql

• Runs PartiQL statements all-or-nothing

  Executes up to 100 PartiQL statements as one transaction, rolled back if any fails.

  Try: “Run these PartiQL updates as a transaction.”

  Delete · execute_transaction_partiql

• Turns TTL on or off for a table

  Enables or disables Time to Live and sets the attribute holding the expiry time.

  Try: “Enable TTL on Sessions using the expires_at attribute.”

  Write · update_time_to_live

• Shows a table's TTL setting

  Returns the TTL configuration for a table.

  Try: “Is TTL on for Sessions?”

  Read · describe_time_to_live

• Deletes expired items now

  Runs a TTL sweep that deletes expired items from every TTL-enabled table and returns how many were deleted.

  Try: “Run a TTL sweep.”

  Delete · sweep_ttl

• Adds tags to a table

  Adds tags to a table.

  Try: “Tag Users with env=dev.”

  Write · tag_resource

• Removes tags from a table

  Removes tags from a table.

  Try: “Remove the env tag from Users.”

  Delete · untag_resource

• Lists a table's tags

  Returns the tags on a table.

  Try: “What tags does Users have?”

  Read · list_tags_of_resource

• Lists DynamoDB streams

  Lists streams, optionally for one table.

  Try: “List streams for Orders.”

  Read · list_streams

• Shows a stream and its shards

  Returns details about a stream including its shards.

  Try: “Describe the Orders stream.”

  Read · describe_stream

• Opens a stream for reading

  Returns a shard iterator, starting from the oldest record or only new ones.

  Try: “Get a shard iterator from the start of the stream.”

  Read · get_shard_iterator

• Reads stream records

  Reads change records using a shard iterator.

  Try: “Read the latest records from the Orders stream.”

  Read · get_records

• Saves the database state

  Saves a copy of the current database to restore later. At most 20 snapshots are kept.

  Try: “Take a snapshot called before-migration.”

  Write · create_snapshot

• Rolls the database back

  Replaces all current data with the contents of a snapshot.

  Try: “Restore the before-migration snapshot.”

  Delete · restore_snapshot

• Lists saved snapshots

  Shows snapshot names, sizes and creation times, newest first.

  Try: “List my snapshots.”

  Read · list_snapshots

• Deletes a snapshot

  Removes a saved snapshot by name.

  Try: “Delete the old-test snapshot.”

  Delete · delete_snapshot

• Shows database-level info

  Returns storage mode, path, size, table count and, for imported data, any anonymisation notices.

  Try: “Give me an overview of the database.”

  Read · get_database_info

Watch out for

• It can delete tables, items and snapshots

  delete_table, delete_item, restore_snapshot, sweep_ttl and the PartiQL tools remove or overwrite data in the database file. delete_table takes an automatic snapshot first, but point it at a copy of your data, or use --read-only. github.com

• The HTTP mode needs care

  The default is stdio. If you turn on the HTTP mode, keep the default 127.0.0.1 bind and a token. Non-loopback binds require an explicit token, and --no-auth works on loopback only. github.com

• Vector search results can differ from AWS

  The docs say four things about vector search will never match AWS, so a test can pass here and fail there. github.com

Security advisories