Amazon RDS
Connect to Amazon RDS via Data API
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.
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.
Execute a SELECT query on Amazon RDS using the Data API
| 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 |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Array of rows returned from the query |
rowCount | number | Number of rows returned |
Insert data into an Amazon RDS table using the Data API
| 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 |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Array of inserted rows |
rowCount | number | Number of rows inserted |
Update data in an Amazon RDS table using the Data API
| 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}) |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Array of updated rows |
rowCount | number | Number of rows updated |
Delete data from an Amazon RDS table using the Data API
| 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}) |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Array of deleted rows |
rowCount | number | Number of rows deleted |
Execute raw SQL on Amazon RDS using the Data API
| 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 |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Array of rows returned or affected |
rowCount | number | Number of rows affected |
Introspect Amazon RDS Aurora database schema to retrieve table structures, columns, and relationships
| 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) |
schema | string | No | Schema to introspect (default: public for PostgreSQL, database name for MySQL) |
engine | string | No | Database engine (aurora-postgresql or aurora-mysql). Auto-detected if not provided. |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
engine | string | Detected database engine type |
tables | array | Array of table schemas with columns, keys, and indexes |
schemas | array | List of available schemas in the database |
