Amazon RDS Aurora Serverless é um banco de dados relacional totalmente gerenciado que inicia, encerra e escala a capacidade automaticamente conforme as necessidades da aplicação. Ele permite executar bancos SQL na nuvem sem gerenciar servidores de banco de dados.
Com o RDS Aurora Serverless, você pode:
- Consultar dados: Executar consultas SQL flexíveis nas suas tabelas
- Inserir novos registros: Adicionar dados ao banco automaticamente
- Atualizar registros existentes: Modificar dados nas tabelas com filtros personalizados
- Excluir registros: Remover dados indesejados com critérios precisos
- Executar SQL bruto: Rodar qualquer comando SQL válido suportado pelo Aurora
No Zoen, a integração do RDS permite que seus agentes trabalhem com bancos Amazon Aurora Serverless de forma segura e programática. As operações suportadas incluem:
- Query: Executar SELECT e outras consultas SQL para buscar linhas do banco
- Insert: Inserir novos registros em tabelas com dados estruturados
- Update: Alterar dados em linhas que correspondam às condições especificadas
- Delete: Remover registros de uma tabela por filtros ou critérios personalizados
- Execute: Rodar SQL bruto para cenários avançados
Esta integração permite que seus agentes automatizem uma ampla gama de operações de banco sem intervenção manual. Ao conectar o Zoen ao Amazon RDS, você pode criar agentes que gerenciam, atualizam e recuperam dados relacionais nos seus workflows — tudo sem lidar com infraestrutura ou conexões de banco.
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 (e.g., arn:aws:rds:us-east-1:123456789012:cluster:my-cluster) |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name to connect to (e.g., mydb, production_db) |
query | string | Yes | SQL SELECT query to execute (e.g., SELECT * FROM users WHERE status = :status) |
| 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 (e.g., arn:aws:rds:us-east-1:123456789012:cluster:my-cluster) |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name to connect to (e.g., mydb, production_db) |
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 (e.g., arn:aws:rds:us-east-1:123456789012:cluster:my-cluster) |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name to connect to (e.g., mydb, production_db) |
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 (e.g., arn:aws:rds:us-east-1:123456789012:cluster:my-cluster) |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name to connect to (e.g., mydb, production_db) |
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 (e.g., arn:aws:rds:us-east-1:123456789012:cluster:my-cluster) |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name to connect to (e.g., mydb, production_db) |
query | string | Yes | Raw SQL query to execute (e.g., CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(255))) |
| 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 (e.g., arn:aws:rds:us-east-1:123456789012:cluster:my-cluster) |
secretArn | string | Yes | ARN of the Secrets Manager secret containing DB credentials |
database | string | No | Database name to connect to (e.g., mydb, production_db) |
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 |