RDS

00Overview

Manage your Amazon RDS and Aurora databases straight from a flow — provision and delete instances and clusters, start, stop and reboot them, take and restore snapshots, and set up read replicas, proxies, parameter groups and blue/green deployments. Run SQL directly against Aurora with the Data API, including multi-statement transactions, without holding a persistent database connection. Describe actions let a flow inventory what is actually running — instances, clusters, snapshots and their endpoints — so automation can react to the current state of your fleet.

Every field below is exactly what you see in the Flomation editor. Fields marked ● live picker let you choose from a list pulled live from your account — no IDs to look up.

01Connecting RDS

1. Start by choosing how the node signs in with the Authentication dropdown — Access Keys, Assume Role (cross-account) or Managed Role (Credential) — and set Region to the AWS region your databases live in (e.g. eu-west-2). Region is required for every method.
2. Access Keys — in the AWS console open IAM → Users (console.aws.amazon.com/iam), select or create a user, then Security credentials → Create access key. Attach a policy granting the rds: actions you need (add secretsmanager:GetSecretValue as well if you will use the Data API). Paste the values into AWS Access Key and AWS Secret Key, and fill Session Token only when the keys are temporary STS credentials.
3. Assume Role (cross-account) — create an IAM role in your account carrying the RDS permissions, with a trust policy that lets Flomation's own principal call sts:AssumeRole. Put the role's ARN in Role ARN to Assume, and if the trust policy pins an External ID, enter the same value in Assume Role External ID so the two match.
4. Managed Role (Credential) — if your administrator has already saved an AWS role in Flomation, just pick it in the AWS Role Credential field; no keys are entered in the node.
5. For the Access Keys method, store the secret access key as a Flomation environment secret (e.g. rds_secret) rather than typing it inline, then select it in the node's AWS Secret Key field.

02Add

AWS RDS Add Role to DB Cluster

aws/rds/add_role_to_db_cluster · Action

Associate an IAM role with an Aurora DB cluster.

Returns: tool_result

AWS RDS Add Tags

aws/rds/add_tags_to_resource · Action

Add or overwrite tags on an RDS resource (instance, snapshot or cluster).

Returns: tool_result, applied

03Apply

AWS RDS Apply Pending Maintenance Action

aws/rds/apply_pending_maintenance_action · Action

Apply or opt in/out of a pending maintenance action on an RDS resource.

Returns: tool_result, resource

04Batch

AWS RDS Batch Execute Statement

aws/rds/batch_execute_statement · Action

Run one SQL statement with many parameter sets against Aurora Serverless via the Data API.

Returns: tool_result, sets_applied

05Begin

AWS RDS Begin Transaction

aws/rds/begin_transaction · Action

Start an Aurora Data API transaction. Pass the ID to Execute Statement, then Commit or Rollback.

Returns: tool_result, transaction_id

06Cancel

AWS RDS Cancel Export Task

aws/rds/cancel_export_task · Action

Cancel an in-progress RDS snapshot/cluster export task.

Returns: tool_result, export_task

07Commit

AWS RDS Commit Transaction

aws/rds/commit_transaction · Action

Commit an Aurora Data API transaction started with Begin Transaction.

Returns: tool_result, status

08Copy

AWS RDS Copy DB Cluster Snapshot

aws/rds/copy_db_cluster_snapshot · Action

Copy a manual DB cluster snapshot, optionally cross-region or re-encrypted with a new KMS key.

Returns: tool_result, snapshot

AWS RDS Copy DB Snapshot

aws/rds/copy_db_snapshot · Action

Copy a manual RDS DB snapshot, optionally cross-region or re-encrypted with a new KMS key.

Returns: tool_result, snapshot

09Create

AWS RDS Create Blue/Green Deployment

aws/rds/create_blue_green_deployment · Action

Create a blue/green deployment cloning a source DB into a green environment.

Returns: tool_result, deployment

AWS RDS Create Custom DB Engine Version

aws/rds/create_custom_db_engine_version · Action

Create a custom RDS DB engine version from installation media.

Returns: tool_result, engine_version

AWS RDS Create DB Cluster

aws/rds/create_db_cluster · Action

Provision a new Aurora/RDS DB cluster. Add instances to it afterwards.

Returns: tool_result, cluster

AWS RDS Create DB Cluster Endpoint

aws/rds/create_db_cluster_endpoint · Action

Create a custom Aurora DB cluster endpoint (reader or any).

Returns: tool_result, endpoint

AWS RDS Create DB Cluster Parameter Group

aws/rds/create_db_cluster_parameter_group · Action

Create an RDS DB cluster parameter group for an engine family.

Returns: tool_result, parameter_group

AWS RDS Create DB Cluster Snapshot

aws/rds/create_db_cluster_snapshot · Action

Create a snapshot of an Aurora/RDS DB cluster.

Returns: tool_result, snapshot

AWS RDS Create DB Instance

aws/rds/create_db_instance · Action

Provision a new RDS DB instance (standalone or as an Aurora cluster member).

Returns: tool_result, instance

AWS RDS Create Read Replica

aws/rds/create_db_instance_read_replica · Action

Create a read replica of an existing RDS database instance.

Returns: tool_result, instance

AWS RDS Create DB Parameter Group

aws/rds/create_db_parameter_group · Action

Create an RDS DB parameter group for a database engine family.

Returns: tool_result, parameter_group

AWS RDS Create DB Proxy

aws/rds/create_db_proxy · Action

Create an RDS Proxy fronting a database with Secrets Manager credentials.

Returns: tool_result, proxy

AWS RDS Create DB Shard Group

aws/rds/create_db_shard_group · Action

Create an Aurora Limitless DB shard group on a DB cluster.

Returns: tool_result, shard_group

AWS RDS Create DB Snapshot

aws/rds/create_db_snapshot · Action

Create a manual snapshot of an RDS database instance.

Returns: tool_result, snapshot

AWS RDS Create DB Subnet Group

aws/rds/create_db_subnet_group · Action

Create an RDS DB subnet group from a set of EC2 subnet IDs.

Returns: tool_result, subnet_group

AWS RDS Create Event Subscription

aws/rds/create_event_subscription · Action

Create an RDS event notification subscription delivered to an SNS topic.

Returns: tool_result, subscription

AWS RDS Create Global Cluster

aws/rds/create_global_cluster · Action

Create an Aurora global database cluster.

Returns: tool_result, global_cluster

AWS RDS Create Integration

aws/rds/create_integration · Action

Create a zero-ETL integration from an Aurora source to a Redshift target.

Returns: tool_result, integration

AWS RDS Create Option Group

aws/rds/create_option_group · Action

Create an RDS option group for a database engine and major version.

Returns: tool_result, option_group

AWS RDS Create Tenant Database

aws/rds/create_tenant_database · Action

Create a tenant database in a multi-tenant RDS DB instance.

Returns: tool_result, tenant_database

10Delete

AWS RDS Delete Blue/Green Deployment

aws/rds/delete_blue_green_deployment · Action

Delete a blue/green deployment, optionally removing the green environment.

Returns: tool_result, deployment

AWS RDS Delete Custom DB Engine Version

aws/rds/delete_custom_db_engine_version · Action

Delete a custom RDS DB engine version.

Returns: tool_result, engine_version

AWS RDS Delete DB Cluster

aws/rds/delete_db_cluster · Action

Delete an Aurora/RDS DB cluster, with an optional final snapshot.

Returns: tool_result, cluster

AWS RDS Delete DB Cluster Endpoint

aws/rds/delete_db_cluster_endpoint · Action

Delete a custom Aurora DB cluster endpoint.

Returns: tool_result, endpoint

AWS RDS Delete DB Cluster Parameter Group

aws/rds/delete_db_cluster_parameter_group · Action

Delete an RDS DB cluster parameter group.

Returns: tool_result

AWS RDS Delete DB Cluster Snapshot

aws/rds/delete_db_cluster_snapshot · Action

Delete an Aurora/RDS DB cluster snapshot.

Returns: tool_result, snapshot

AWS RDS Delete DB Instance

aws/rds/delete_db_instance · Action

Delete an RDS database instance, with an optional final snapshot.

Returns: tool_result, instance

AWS RDS Delete DB Instance Automated Backup

aws/rds/delete_db_instance_automated_backup · Action

Delete a retained RDS DB instance automated backup by resource id or ARN.

Returns: tool_result, backup

AWS RDS Delete DB Parameter Group

aws/rds/delete_db_parameter_group · Action

Delete an RDS DB parameter group.

Returns: tool_result

AWS RDS Delete DB Proxy

aws/rds/delete_db_proxy · Action

Delete an existing RDS Proxy.

Returns: tool_result, proxy

AWS RDS Delete DB Shard Group

aws/rds/delete_db_shard_group · Action

Delete an Aurora Limitless DB shard group.

Returns: tool_result, shard_group

AWS RDS Delete DB Snapshot

aws/rds/delete_db_snapshot · Action

Delete a manual RDS database snapshot.

Returns: tool_result, snapshot

AWS RDS Delete DB Subnet Group

aws/rds/delete_db_subnet_group · Action

Delete an RDS DB subnet group.

Returns: tool_result

AWS RDS Delete Event Subscription

aws/rds/delete_event_subscription · Action

Delete an RDS event notification subscription.

Returns: tool_result, subscription

AWS RDS Delete Global Cluster

aws/rds/delete_global_cluster · Action

Delete an Aurora global database cluster.

Returns: tool_result, global_cluster

AWS RDS Delete Integration

aws/rds/delete_integration · Action

Delete a zero-ETL integration.

Returns: tool_result, integration

AWS RDS Delete Option Group

aws/rds/delete_option_group · Action

Delete an RDS option group.

Returns: tool_result

AWS RDS Delete Tenant Database

aws/rds/delete_tenant_database · Action

Delete a tenant database from a multi-tenant RDS DB instance.

Returns: tool_result, tenant_database

11Deregister

AWS RDS Deregister DB Proxy Targets

aws/rds/deregister_db_proxy_targets · Action

Remove DB instances or clusters from an RDS Proxy target group.

Returns: tool_result

12Describe

AWS RDS Describe Blue/Green Deployments

aws/rds/describe_blue_green_deployments · Action

List RDS blue/green deployments, optionally filtered by identifier.

Returns: tool_result, deployments, count

AWS RDS Describe Certificates

aws/rds/describe_certificates · Action

List the CA certificates available for RDS DB instances.

Returns: tool_result, certificates, count

AWS RDS Describe DB Cluster Endpoints

aws/rds/describe_db_cluster_endpoints · Action

List Aurora DB cluster endpoints, optionally filtered by cluster or endpoint.

Returns: tool_result, endpoints, count

AWS RDS Describe DB Cluster Parameter Groups

aws/rds/describe_db_cluster_parameter_groups · Action

List RDS DB cluster parameter groups, optionally filtered by name.

Returns: tool_result, parameter_groups, count

AWS RDS Describe DB Cluster Snapshots

aws/rds/describe_db_cluster_snapshots · Action

List Aurora/RDS DB cluster snapshots, optionally filtered by cluster, snapshot or type.

Returns: tool_result, snapshots, count

AWS RDS Describe DB Clusters

aws/rds/describe_db_clusters · Action

List Aurora/RDS DB clusters, with writer and reader endpoints and member roles.

Returns: tool_result, clusters, count

AWS RDS Describe DB Engine Versions

aws/rds/describe_db_engine_versions · Action

List available RDS database engine versions, optionally filtered.

Returns: tool_result, engine_versions, count

AWS RDS Describe DB Instance Automated Backups

aws/rds/describe_db_instance_automated_backups · Action

List RDS DB instance automated backups, optionally by identifier or resource id.

Returns: tool_result, backups, count

AWS RDS Describe DB Instances

aws/rds/describe_db_instances · Action

List RDS database instances, optionally filtered by identifier or engine.

Returns: tool_result, instances, count

AWS RDS Describe DB Log Files

aws/rds/describe_db_log_files · Action

List the log files available for an RDS DB instance.

Returns: tool_result, log_files, count

AWS RDS Describe DB Parameter Groups

aws/rds/describe_db_parameter_groups · Action

List RDS DB parameter groups, optionally filtered by name.

Returns: tool_result, parameter_groups, count

AWS RDS Describe DB Parameters

aws/rds/describe_db_parameters · Action

List the parameters within an RDS DB parameter group.

Returns: tool_result, parameters, count

AWS RDS Describe DB Proxies

aws/rds/describe_db_proxies · Action

List RDS Proxies, optionally filtered by proxy name.

Returns: tool_result, proxies, count

AWS RDS Describe DB Shard Groups

aws/rds/describe_db_shard_groups · Action

List Aurora Limitless DB shard groups, optionally filtered by identifier.

Returns: tool_result, shard_groups, count

AWS RDS Describe DB Snapshots

aws/rds/describe_db_snapshots · Action

List RDS database snapshots, optionally filtered by instance, snapshot or type.

Returns: tool_result, snapshots, count

AWS RDS Describe DB Subnet Groups

aws/rds/describe_db_subnet_groups · Action

List RDS DB subnet groups, optionally filtered by name.

Returns: tool_result, subnet_groups, count

AWS RDS Describe Event Categories

aws/rds/describe_event_categories · Action

List the RDS event categories available for each source type.

Returns: tool_result, categories, count

AWS RDS Describe Events

aws/rds/describe_events · Action

List RDS events, optionally filtered by source, type, or lookback duration.

Returns: tool_result, events, count

AWS RDS Describe Export Tasks

aws/rds/describe_export_tasks · Action

List RDS snapshot/cluster export tasks, optionally by identifier or source ARN.

Returns: tool_result, export_tasks, count

AWS RDS Describe Global Clusters

aws/rds/describe_global_clusters · Action

List Aurora global database clusters, optionally filtered by identifier.

Returns: tool_result, global_clusters, count

AWS RDS Describe Integrations

aws/rds/describe_integrations · Action

List zero-ETL integrations, optionally filtered by identifier.

Returns: tool_result, integrations, count

AWS RDS Describe Option Groups

aws/rds/describe_option_groups · Action

List RDS option groups, optionally filtered by name or engine.

Returns: tool_result, option_groups, count

AWS RDS Describe Orderable DB Instance Options

aws/rds/describe_orderable_db_instance_options · Action

List orderable RDS DB instance options for an engine (class, version, storage).

Returns: tool_result, options, count

AWS RDS Describe Pending Maintenance Actions

aws/rds/describe_pending_maintenance_actions · Action

List pending maintenance actions for RDS resources, optionally by resource ARN.

Returns: tool_result, pending, count

AWS RDS Describe Reserved DB Instances

aws/rds/describe_reserved_db_instances · Action

List purchased reserved RDS DB instances, optionally filtered.

Returns: tool_result, reserved_instances, count

AWS RDS Describe Source Regions

aws/rds/describe_source_regions · Action

List Regions that can be a source for RDS read replicas or snapshots.

Returns: tool_result, regions, count

AWS RDS Describe Tenant Databases

aws/rds/describe_tenant_databases · Action

List tenant databases, optionally filtered by instance or name.

Returns: tool_result, tenant_databases, count

13Download

AWS RDS Download DB Log File Portion

aws/rds/download_db_log_file_portion · Action

Download the contents of an RDS DB instance log file.

Returns: tool_result, log_data, additional_data_pending

14Execute

AWS RDS Execute Statement

aws/rds/execute_statement · Action

Run a SQL statement against Aurora Serverless via the Data API (no persistent connection).

Returns: tool_result, records, rows_updated, generated_fields

15Failover

AWS RDS Failover DB Cluster

aws/rds/failover_db_cluster · Action

Fail over an Aurora DB cluster, promoting a reader instance to writer.

Returns: tool_result, cluster

AWS RDS Failover Global Cluster

aws/rds/failover_global_cluster · Action

Promote a secondary Aurora cluster to primary in a global database.

Returns: tool_result, global_cluster

16List

AWS RDS List Tags

aws/rds/list_tags_for_resource · Action

List the tags on an RDS resource (instance, snapshot or cluster).

Returns: tool_result, tags, count

17Modify

AWS RDS Modify Certificates

aws/rds/modify_certificates · Action

Override or reset the account-default RDS CA certificate.

Returns: tool_result, certificate

AWS RDS Modify Custom DB Engine Version

aws/rds/modify_custom_db_engine_version · Action

Change the status or description of a custom RDS DB engine version.

Returns: tool_result, engine_version

AWS RDS Modify DB Cluster

aws/rds/modify_db_cluster · Action

Modify an Aurora/RDS DB cluster (version, port, password or backup retention).

Returns: tool_result, cluster

AWS RDS Modify DB Cluster Parameter Group

aws/rds/modify_db_cluster_parameter_group · Action

Modify parameter values in an RDS DB cluster parameter group.

Returns: tool_result, applied

AWS RDS Modify Cluster Snapshot Attribute

aws/rds/modify_db_cluster_snapshot_attribute · Action

Authorise or revoke AWS accounts (or 'all' for public) to copy/restore a manual DB cluster snapshot.

Returns: tool_result, attribute

AWS RDS Modify DB Instance

aws/rds/modify_db_instance · Action

Modify an RDS database instance (class, storage, version or password).

Returns: tool_result, instance

AWS RDS Modify DB Parameter Group

aws/rds/modify_db_parameter_group · Action

Modify parameter values in an RDS DB parameter group.

Returns: tool_result, applied

AWS RDS Modify DB Proxy

aws/rds/modify_db_proxy · Action

Update an existing RDS Proxy's name, TLS, idle timeout or debug logging.

Returns: tool_result, proxy

AWS RDS Modify DB Shard Group

aws/rds/modify_db_shard_group · Action

Modify an Aurora Limitless DB shard group's capacity or redundancy.

Returns: tool_result, shard_group

AWS RDS Modify Snapshot Attribute

aws/rds/modify_db_snapshot_attribute · Action

Authorise or revoke other AWS accounts (or 'all' for public) to copy/restore a manual DB snapshot.

Returns: tool_result, attribute

AWS RDS Modify DB Subnet Group

aws/rds/modify_db_subnet_group · Action

Update the subnets or description of an RDS DB subnet group.

Returns: tool_result, subnet_group

AWS RDS Modify Global Cluster

aws/rds/modify_global_cluster · Action

Modify an Aurora global database cluster (rename, engine version, deletion protection).

Returns: tool_result, global_cluster

AWS RDS Modify Integration

aws/rds/modify_integration · Action

Modify a zero-ETL integration, e.g. rename it.

Returns: tool_result, integration

AWS RDS Modify Option Group

aws/rds/modify_option_group · Action

Add or remove options in an RDS option group.

Returns: tool_result, option_group

AWS RDS Modify Tenant Database

aws/rds/modify_tenant_database · Action

Rename a tenant database or change its master password.

Returns: tool_result, tenant_database

18Promote

AWS RDS Promote Read Replica

aws/rds/promote_read_replica · Action

Promote a read replica to a standalone read/write DB instance.

Returns: tool_result, instance

19Reboot

AWS RDS Reboot DB Instance

aws/rds/reboot_db_instance · Action

Reboot an RDS database instance, optionally forcing a Multi-AZ failover.

Returns: tool_result, instance

20Register

AWS RDS Register DB Proxy Targets

aws/rds/register_db_proxy_targets · Action

Register DB instances or clusters as targets of an RDS Proxy target group.

Returns: tool_result, targets

21Remove

AWS RDS Remove Role from DB Cluster

aws/rds/remove_role_from_db_cluster · Action

Disassociate an IAM role from an Aurora DB cluster.

Returns: tool_result

AWS RDS Remove Tags

aws/rds/remove_tags_from_resource · Action

Remove tags from an RDS resource by tag key.

Returns: tool_result, removed

22Reset

AWS RDS Reset DB Parameter Group

aws/rds/reset_db_parameter_group · Action

Reset parameters in an RDS DB parameter group to their default values.

Returns: tool_result

23Restore

AWS RDS Restore Cluster from Snapshot

aws/rds/restore_db_cluster_from_snapshot · Action

Restore a new Aurora/RDS DB cluster from a cluster snapshot.

Returns: tool_result, cluster

AWS RDS Restore Cluster to Point in Time

aws/rds/restore_db_cluster_to_point_in_time · Action

Restore a new Aurora/RDS DB cluster to a point in time from source backups.

Returns: tool_result, cluster

AWS RDS Restore Instance from Snapshot

aws/rds/restore_db_instance_from_db_snapshot · Action

Restore a new RDS database instance from a DB snapshot.

Returns: tool_result, instance

AWS RDS Restore DB Instance From S3

aws/rds/restore_db_instance_from_s3 · Action

Create a new RDS DB instance from a database backup stored in S3.

Returns: tool_result, instance

AWS RDS Restore Instance to Point in Time

aws/rds/restore_db_instance_to_point_in_time · Action

Restore a new RDS database instance to a point in time from source backups.

Returns: tool_result, instance

24Rollback

AWS RDS Rollback Transaction

aws/rds/rollback_transaction · Action

Roll back an Aurora Data API transaction started with Begin Transaction.

Returns: tool_result, status

25Start

AWS RDS Start DB Cluster

aws/rds/start_db_cluster · Action

Start a stopped Aurora/RDS DB cluster.

Returns: tool_result, cluster

AWS RDS Start DB Instance

aws/rds/start_db_instance · Action

Start a stopped RDS database instance.

Returns: tool_result, instance

AWS RDS Start Automated Backups Replication

aws/rds/start_db_instance_automated_backups_replication · Action

Enable cross-region replication of automated backups for an RDS DB instance.

Returns: tool_result, backup

AWS RDS Start Export Task

aws/rds/start_export_task · Action

Export an RDS snapshot or cluster to Amazon S3.

Returns: tool_result, export_task

26Stop

AWS RDS Stop DB Cluster

aws/rds/stop_db_cluster · Action

Stop a running Aurora/RDS DB cluster.

Returns: tool_result, cluster

AWS RDS Stop DB Instance

aws/rds/stop_db_instance · Action

Stop a running RDS database instance, optionally taking a snapshot first.

Returns: tool_result, instance

AWS RDS Stop Automated Backups Replication

aws/rds/stop_db_instance_automated_backups_replication · Action

Disable cross-region replication of automated backups for an RDS DB instance.

Returns: tool_result, backup

27Switchover

AWS RDS Switchover Blue/Green Deployment

aws/rds/switchover_blue_green_deployment · Action

Switch over a blue/green deployment, promoting the green environment to production.

Returns: tool_result, deployment

AWS RDS Switchover Global Cluster

aws/rds/switchover_global_cluster · Action

Planned switchover promoting a secondary Aurora cluster to primary in a global database.

Returns: tool_result, global_cluster

AWS RDS Switchover Read Replica

aws/rds/switchover_read_replica · Action

Switch over an Oracle read replica to become the new primary DB instance.

Returns: tool_result, instance

28Triggers

RDS Event Trigger

trigger/rds_event · Trigger

Triggers a flow on AWS RDS/Aurora events (failover, backup complete, low storage, availability change). Polls DescribeEvents on an interval.

Returns: source_identifier, source_type, source_arn, message, event_categories, date, triggered_at

29Notes & Limitations

Behaviours and constraints worth knowing before you build with these nodes.

• The Data API actions — Execute Statement, Batch Execute Statement, and Begin, Commit and Rollback Transaction — reach Aurora through a cluster ARN and a Secrets Manager secret ARN rather than a database endpoint and password, so enable the Data API on the cluster and store its credentials in Secrets Manager before you run them.
• RDS provisioning and lifecycle changes are asynchronous, so an action returns as soon as AWS accepts the request while the work continues in the background; follow a Create, Modify, Reboot, Start, Stop or Delete with a Describe that polls until the reported status settles.
• Every action runs in the single Region you set, and RDS resources are regional, so a Describe will not return instances, clusters or snapshots that live in another Region.
• DB instance, cluster and snapshot identifiers must be lowercase, begin with a letter, and contain only letters, digits and hyphens, and each must be unique within your account and Region.
• Deleting an instance or cluster is irreversible once it completes, so give the delete action a Final Snapshot Identifier unless you have turned on Skip Final Snapshot and are certain the data is disposable.