Amazon RDS

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

Amazon RDS

On this page