# Amazon DynamoDB integration

> NoSQL key-value and document database API: read and write items (GetItem, PutItem, Query, Scan, batch and transactional ops, PartiQL), plus table management, backups, exports/imports, TTL, tags, global tables, and contributor insights.

- Authentication: apiKey

## Tools (57)

- **Batch Execute Statement (PartiQL)**: Run up to 25 PartiQL statements as a batch (not transactional).
- **Batch Get Item**: Read up to 100 items across one or more tables in a single call.
- **Batch Write Item**: Put or delete up to 25 items across one or more tables in a single call.
- **Create Backup**: Create an on-demand backup of a table.
- **Create Global Table**: Create a version-2017 global table spanning multiple Regions.
- **Create Table**: Create a new table with a key schema and optional secondary indexes.
- **Delete Backup**: Delete an existing on-demand backup.
- **Delete Item**: Delete a single item from a table by its primary key.
- **Delete Resource Policy**: Remove the resource-based policy from a table or stream.
- **Delete Table**: Delete a table and all of its items.
- **Describe Backup**: Get details about an on-demand backup.
- **Describe Continuous Backups**: Get continuous-backup and point-in-time-recovery status for a table.
- **Describe Contributor Insights**: Get CloudWatch Contributor Insights status for a table or index.
- **Describe Endpoints**: Get the regional endpoints for DynamoDB request routing.
- **Describe Export**: Get the status and details of a table export.
- **Describe Global Table**: Get details about a version-2017 global table.
- **Describe Global Table Settings**: Get throughput and auto-scaling settings for a version-2017 global table.
- **Describe Import**: Get the status and details of a table import.
- **Describe Kinesis Streaming Destination**: Get the Kinesis Data Streams destinations configured for a table.
- **Describe Limits**: Get the account's provisioned-capacity quotas for the current Region.
- **Describe Table**: Get metadata about a table — key schema, indexes, status, size, and item count.
- **Describe Table Replica Auto Scaling**: Get auto-scaling settings for a table and its global-table replicas.
- **Describe Time To Live**: Get the TTL configuration for a table.
- **Disable Kinesis Streaming Destination**: Stop streaming a table's changes to a Kinesis data stream.
- **Enable Kinesis Streaming Destination**: Start streaming a table's item-level changes to a Kinesis data stream.
- **Execute Statement (PartiQL)**: Run a single PartiQL statement (SELECT, INSERT, UPDATE, or DELETE) against a table.
- **Execute Transaction (PartiQL)**: Run up to 100 PartiQL statements as a single serializable transaction.
- **Export Table To Point In Time**: Export a table snapshot (full or incremental) to an S3 bucket.
- **Get Item**: Read a single item from a table by its primary key.
- **Get Resource Policy**: Retrieve the resource-based policy attached to a table or stream.
- **Import Table**: Create a new table by importing data from S3.
- **List Backups**: List on-demand and system backups for a table or account.
- **List Contributor Insights**: List Contributor Insights summaries for tables and indexes.
- **List Exports**: List export tasks for a table or account.
- **List Global Tables**: List version-2017 global tables in the account.
- **List Imports**: List import tasks for a table or account.
- **List Tables**: List the names of tables in the account and Region.
- **List Tags Of Resource**: List the tags on a DynamoDB table or index.
- **Put Item**: Create a new item or fully replace an existing item with the same primary key.
- **Put Resource Policy**: Attach or replace a resource-based policy on a table or stream.
- **Query**: Read items sharing a partition key value from a table or secondary index.
- **Restore Table From Backup**: Create a new table by restoring from an on-demand backup.
- **Restore Table To Point In Time**: Restore a table to any second within its point-in-time recovery window.
- **Scan**: Read every item in a table or secondary index, optionally filtered.
- **Tag Resource**: Add or overwrite tags on a DynamoDB resource.
- **Transact Get Items**: Atomically read up to 100 items across tables in a single serializable transaction.
- **Transact Write Items**: Atomically put, update, delete, or condition-check up to 100 items in one transaction.
- **Untag Resource**: Remove tags from a DynamoDB resource.
- **Update Continuous Backups**: Enable or disable point-in-time recovery for a table.
- **Update Contributor Insights**: Enable or disable CloudWatch Contributor Insights for a table or index.
- **Update Global Table**: Add or remove Region replicas on a version-2017 global table.
- **Update Global Table Settings**: Update throughput and auto-scaling for a version-2017 global table.
- **Update Item**: Modify attributes of an existing item, or create it if it does not exist.
- **Update Kinesis Streaming Destination**: Change the configuration of a table's Kinesis streaming destination.
- **Update Table**: Modify a table's throughput, billing mode, indexes, streams, or replicas.
- **Update Table Replica Auto Scaling**: Configure auto-scaling for a table and its global-table replicas.
- **Update Time To Live**: Enable or disable TTL-based item expiry on a table.

## Related prompts

- [Weekly customer usage brief from your DynamoDB events](https://www.generalinput.com/prompts/weekly-customer-usage-brief-from-your-dynamodb-events.md)
- [Weekday DynamoDB health check in Slack](https://www.generalinput.com/prompts/weekday-dynamodb-health-check-in-slack.md)
- [Audit failed Stripe payments in DynamoDB with a Slack triage note](https://www.generalinput.com/prompts/audit-failed-stripe-payments-in-dynamodb-with-a-slack-triage-note.md)
- [Nightly DynamoDB table export to Google Sheets](https://www.generalinput.com/prompts/nightly-dynamodb-table-export-to-google-sheets.md)

Connect Amazon DynamoDB in General Input: https://www.generalinput.com/apps/amazon-dynamodb