Amazon RDS Aurora Serverless is a fully managed relational database that automatically starts up, shuts down, and scales capacity based on your application's needs. It allows you to run SQL databases in the cloud without managing database servers.
With RDS Aurora Serverless, you can:
- Query data: Run flexible SQL queries across your tables
- Insert new records: Add data to your database automatically
- Update existing records: Modify data in your tables using custom filters
- Delete records: Remove unwanted data using precise criteria
- Execute raw SQL: Run any valid SQL command supported by Aurora
In Sim, the RDS integration enables your agents to work with Amazon Aurora Serverless databases securely and programmatically. Supported operations include:
- Query: Run SELECT and other SQL queries to fetch rows from your database
- Insert: Insert new records into tables with structured data
- Update: Change data in rows that match your specified conditions
- Delete: Remove records from a table by custom filters or criteria
- Execute: Run raw SQL for advanced scenarios
This integration allows your agents to automate a wide range of database operations without manual intervention. By connecting Sim with Amazon RDS, you can build agents that manage, update, and retrieve relational data within your workflows—all without handling database infrastructure or connections.
Usage Instructions
Integrate Amazon RDS Aurora Serverless into the workflow using the Data API. Can query, insert, update, delete, and execute raw SQL without managing database connections.
Tools
rds_query
Execute a SELECT query on Amazon RDS using the Data API
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
region | string | Yes | AWS region (e.g., us-east-1) |
accessKeyId | string | Yes | AWS access key ID |
secretAccessKey | string | Yes | AWS secret access key |
resourceArn | string | Yes | ARN of the Aurora DB cluster |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name (optional) |
query | string | Yes | SQL SELECT query to execute |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Array of rows returned from the query |
rowCount | number | Number of rows returned |
rds_insert
Insert data into an Amazon RDS table using the Data API
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
region | string | Yes | AWS region (e.g., us-east-1) |
accessKeyId | string | Yes | AWS access key ID |
secretAccessKey | string | Yes | AWS secret access key |
resourceArn | string | Yes | ARN of the Aurora DB cluster |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name (optional) |
table | string | Yes | Table name to insert into |
data | object | Yes | Data to insert as key-value pairs |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Array of inserted rows |
rowCount | number | Number of rows inserted |
rds_update
Update data in an Amazon RDS table using the Data API
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
region | string | Yes | AWS region (e.g., us-east-1) |
accessKeyId | string | Yes | AWS access key ID |
secretAccessKey | string | Yes | AWS secret access key |
resourceArn | string | Yes | ARN of the Aurora DB cluster |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name (optional) |
table | string | Yes | Table name to update |
data | object | Yes | Data to update as key-value pairs |
conditions | object | Yes | Conditions for the update (e.g., {"id": 1}) |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Array of updated rows |
rowCount | number | Number of rows updated |
rds_delete
Delete data from an Amazon RDS table using the Data API
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
region | string | Yes | AWS region (e.g., us-east-1) |
accessKeyId | string | Yes | AWS access key ID |
secretAccessKey | string | Yes | AWS secret access key |
resourceArn | string | Yes | ARN of the Aurora DB cluster |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name (optional) |
table | string | Yes | Table name to delete from |
conditions | object | Yes | Conditions for the delete (e.g., {"id": 1}) |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Array of deleted rows |
rowCount | number | Number of rows deleted |
rds_execute
Execute raw SQL on Amazon RDS using the Data API
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
region | string | Yes | AWS region (e.g., us-east-1) |
accessKeyId | string | Yes | AWS access key ID |
secretAccessKey | string | Yes | AWS secret access key |
resourceArn | string | Yes | ARN of the Aurora DB cluster |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name (optional) |
query | string | Yes | Raw SQL query to execute |
Output
| Parameter | Type | Description |
|---|---|---|
message | string | Operation status message |
rows | array | Array of rows returned or affected |
rowCount | number | Number of rows affected |
Notes
- Category:
tools - Type:
rds