Amazon RDS

Configuration

Query (SELECT)

Operation

Query (SELECT)

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Resource ARN*

arn:aws:rds:us-east-1:123456789:cluster:my-cluster

Secret ARN*

arn:aws:secretsmanager:us-east-1:123456789:secret:my-secret

Database Name

your_database

SQL Query*

sql

SELECT * FROM users WHERE active = true

Query (SELECT) (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

Insert Data

Operation

Insert Data

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Resource ARN*

arn:aws:rds:us-east-1:123456789:cluster:my-cluster

Secret ARN*

arn:aws:secretsmanager:us-east-1:123456789:secret:my-secret

Database Name

your_database

Table Name*

users

Data (JSON)*

json

{\n "name": "John Doe",\n "email": "john@example.com",\n "active": true\n}

Insert Data (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

Update Data

Operation

Update Data

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Resource ARN*

arn:aws:rds:us-east-1:123456789:cluster:my-cluster

Secret ARN*

arn:aws:secretsmanager:us-east-1:123456789:secret:my-secret

Database Name

your_database

Table Name*

users

Update Data (JSON)*

json

{\n "name": "Jane Doe",\n "email": "jane@example.com"\n}

Conditions (JSON)*

json

{\n "id": 1\n}

Update Data (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

Delete Data

Operation

Delete Data

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Resource ARN*

arn:aws:rds:us-east-1:123456789:cluster:my-cluster

Secret ARN*

arn:aws:secretsmanager:us-east-1:123456789:secret:my-secret

Database Name

your_database

Table Name*

users

Conditions (JSON)*

json

{\n "id": 1\n}

Delete Data (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

Execute Raw SQL

Operation

Execute Raw SQL

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Resource ARN*

arn:aws:rds:us-east-1:123456789:cluster:my-cluster

Secret ARN*

arn:aws:secretsmanager:us-east-1:123456789:secret:my-secret

Database Name

your_database

SQL Query*

sql

SELECT * FROM table_name

Execute Raw SQL (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

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.

Notes

Category: tools
Type: rds

Amazon RDS

On this page