Autonomous Database integration

00Overview

Provision, clone and tear down Oracle Cloud Autonomous Databases straight from a flow — start, stop, restart, scale compute and storage, reclaim unused space, and move a database between compartments without opening the console. Back up and restore to a point in time, and list and manage backups and clones as part of an automated routine. Generate the client or regional connection wallet and fetch the connection strings a tool needs to connect, so a flow can hand a freshly built database off to the systems that use it.

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 Autonomous Database

In the node's Authentication field, choose how requests are signed: Connect Oracle Cloud (recommended) reuses a saved Oracle Cloud connection, while API signing key (advanced) lets you enter the raw signing-key fields on the node itself.
For Connect Oracle Cloud, pick your account in the Oracle Cloud connection field — it supplies the tenancy, user, region, fingerprint and private key for you, so there is nothing further to paste.
For API signing key (advanced), sign in to the OCI Console, open the Profile menu → My profile → API keys, choose Add API key, and let Oracle generate the key pair — download the private key and keep the Configuration file preview it shows next.
Copy the values from that preview into the node: Tenancy OCID, User OCID, Region (for example uk-london-1) and Key Fingerprint, plus the Compartment OCID of the compartment your databases live in.
Store the downloaded PEM as a Flomation environment secret (e.g. autonomousdatabase_secret) and pick it in the node's Private Key (PEM) field — add the Private Key Passphrase too if you protected the key with one.

Field	Type	Details
Authentication	`string`	Connect Oracle Cloud, API signing key (advanced)
Oracle Cloud connection	`credential`	Pick a connected Oracle Cloud account
Region	`string`	e.g. uk-london-1
Private Key (PEM)	`secret`	The API signing private key — full PEM, incl. BEGIN/END lines
Private Key Passphrase	`secret`	Only if the key is encrypted (optional)
Tenancy OCID	`string`	ocid1.tenancy.oc1..aaaa…
User OCID	`string`	ocid1.user.oc1..aaaa…
Key Fingerprint	`string`	aa:bb:cc:… fingerprint of the uploaded API key

Good to know

Pick an Environment on your flow (Flow Settings → Environment) so the secret resolves. Secret fields never show the value — they reference ${secrets.your_secret}.

02Db

OCI Autonomous Database: Move to Compartment

oracle/autonomousdatabase/db_change_compartment · Action

Move an Oracle Cloud Autonomous Database to a different compartment. Asynchronous — returns a work-request id.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…
Target Compartment OCID	`string`	Required	ocid1.compartment.oc1..aaaa… — the compartment to move the database into

Returns: tool_result, work_request_id, success, error

OCI Autonomous Database: Clone

oracle/autonomousdatabase/db_clone · Action

Clone an Oracle Cloud Autonomous Database into a new database (full or metadata clone). Asynchronous — returns a work-request id for the new database.

Field	Type		Details
Compartment OCID	`string`	Required	ocid1.compartment.oc1..aaaa… destination compartment for the clone
Source Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa… the database to clone
New Database Name	`string`	Required	Alphanumeric, e.g. SALESDBCLONE (no spaces, ≤30 chars)
Display Name	`string`		Friendly name shown in the console (optional)
Clone Type	`string`		Default Full clone — choices: Full Clone (data + metadata), Metadata Clone (schema only)

Returns: tool_result, database, id, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Create

oracle/autonomousdatabase/db_create · Action

Provision a new Oracle Cloud Autonomous Database in a compartment. Asynchronous — returns a work-request id while the database provisions. Set 'Always Free' for a no-cost database, or choose the workload, compute and storage.

Field	Type		Details
Compartment OCID	`string`	Required	ocid1.compartment.oc1..aaaa… (use the tenancy OCID for the root)
Database Name	`string`	Required	Alphanumeric, e.g. SALESDB (no spaces, ≤30 chars)
ADMIN Password	`secret`	Required	12–30 chars, incl. upper, lower and a digit
Display Name	`string`		Friendly name shown in the console (optional)
Workload	`string`		Default OLTP — choices: Transaction Processing (OLTP), Data Warehouse (DW), JSON Database (AJD), APEX
Always Free	`boolean`		Provision a no-cost Always Free database (fixed small sizing)
Compute Model	`string`		Default ECPU — choices: ECPU, OCPU
CPU Count	`string`		ECPU or OCPU count, e.g. 2 (ignored for Always Free)
Storage (TB)	`string`		Data storage in TB, e.g. 1 (ignored for Always Free)
Auto-scaling	`boolean`		Allow compute auto-scaling up to 3x
License Model	`string`		Optional — choices: License Included, Bring Your Own License
Allowed IPs	`string`		Comma-separated IPs/CIDRs to allow (optional)
Freeform Tags (JSON)	`string`		{"env":"prod"} (optional)

Returns: tool_result, database, id, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Create Backup

oracle/autonomousdatabase/db_create_backup · Action

Create a backup of an Oracle Cloud Autonomous Database. Defaults to a long-term backup (manual backups are deprecated on Autonomous Database Serverless) retained for 90 days unless you set a retention period. Asynchronous — returns a work-request id.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…
Backup Name	`string`		Friendly name for the backup (optional)
Retention Period (days)	`string`		Long-term retention in days, 90–3650 (default 90)
Long-term Backup	`boolean`		On by default — required on Serverless; turn off only for dedicated infrastructure

Returns: tool_result, backup, backup_id, work_request_id, success, error

OCI Autonomous Database: Delete

oracle/autonomousdatabase/db_delete · Action

Permanently terminate an Oracle Cloud Autonomous Database. Asynchronous and IRREVERSIBLE — returns a work-request id while the database terminates.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, work_request_id, success, error

OCI Autonomous Database: Delete Backup

oracle/autonomousdatabase/db_delete_backup · Action

Delete an Oracle Cloud Autonomous Database backup by OCID. Asynchronous — returns a work-request id.

Field	Type		Details
Autonomous Database Backup OCID	`string`	Required	ocid1.autonomousdatabasebackup.oc1..aaaa…

Returns: tool_result, work_request_id, success, error

OCI Autonomous Database: Generate Regional Wallet

oracle/autonomousdatabase/db_generate_regional_wallet · Action

Download the regional wallet for Oracle Cloud Autonomous Databases — a single wallet covering all databases in the region. Returned base64-encoded. The password protects the zip and is required.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa… — any database in the region anchors the wallet
Wallet Password	`secret`	Required	Password to protect the wallet zip (min 8 chars)

Returns: tool_result, wallet_base64, size_bytes, success, error

OCI Autonomous Database: Generate Wallet

oracle/autonomousdatabase/db_generate_wallet · Action

Download the client credentials (instance) wallet for an Oracle Cloud Autonomous Database — the password-protected zip a client needs to connect. Returned base64-encoded. The password protects the zip and is required.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…
Wallet Password	`secret`	Required	Password to protect the wallet zip (min 8 chars)
Wallet Type	`string`		ALL = all connection strings (default); SINGLE = one — choices: All connection strings (default), Single connection string

Returns: tool_result, wallet_base64, size_bytes, success, error

OCI Autonomous Database: Get

oracle/autonomousdatabase/db_get · Action

Fetch the full state of one Oracle Cloud Autonomous Database by OCID — lifecycle state, compute and storage sizing, workload type and metadata.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, database, lifecycle_state, success, error

OCI Autonomous Database: List

oracle/autonomousdatabase/db_get_all · Action

List the Autonomous Databases in an Oracle Cloud compartment, with their lifecycle state, workload and sizing. Optionally filter by display name or workload type. Large compartments are capped — check the 'truncated' output to tell a complete listing from a partial one.

Field	Type		Details
Compartment OCID	`string`	Required	ocid1.compartment.oc1..aaaa… (use the tenancy OCID for the root)
Display Name Filter	`string`		Only databases with this exact display name (optional)
Workload Filter	`string`		Only this workload type (optional) — choices: Transaction Processing (OLTP), Data Warehouse (DW), JSON Database (AJD), APEX

Returns: tool_result, databases, count, truncated, success, error

OCI Autonomous Database: Get Backup

oracle/autonomousdatabase/db_get_backup · Action

Fetch the details of one Oracle Cloud Autonomous Database backup by OCID.

Field	Type		Details
Autonomous Database Backup OCID	`string`	Required	ocid1.autonomousdatabasebackup.oc1..aaaa…

Returns: tool_result, backup, lifecycle_state, success, error

OCI Autonomous Database: Get Connection Info

oracle/autonomousdatabase/db_get_connection_info · Action

Get the connection strings and service console URLs for an Oracle Cloud Autonomous Database — everything a client or tool needs to connect, without downloading a wallet.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, connection_strings, connection_urls, lifecycle_state, success, error

OCI Autonomous Database: List Backups

oracle/autonomousdatabase/db_list_backups · Action

List the backups of an Oracle Cloud Autonomous Database, or all backups in a compartment. Provide a database OCID or a compartment.

Field	Type		Details
Autonomous Database OCID	`string`		ocid1.autonomousdatabase.oc1..aaaa… — backups of this one database (optional)
Compartment OCID	`string`		ocid1.compartment.oc1..aaaa… — every backup in this compartment (optional)

Returns: tool_result, backups, count, truncated, success, error

OCI Autonomous Database: List Character Sets

oracle/autonomousdatabase/db_list_character_sets · Action

List the valid database or national character sets for provisioning an Oracle Cloud Autonomous Database.

Field	Type		Details
Character Set Type	`string`		Database or national character sets (optional) — choices: Database Character Sets, National Character Sets

Returns: tool_result, character_sets, count, success, error

OCI Autonomous Database: List Clones

oracle/autonomousdatabase/db_list_clones · Action

List the clones created from a source Oracle Cloud Autonomous Database within a compartment.

Field	Type		Details
Compartment OCID	`string`	Required	ocid1.compartment.oc1..aaaa… (use the tenancy OCID for the root)
Source Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa… (the database whose clones to list)

Returns: tool_result, databases, count, truncated, success, error

OCI Autonomous Database: List DB Versions

oracle/autonomousdatabase/db_list_versions · Action

List the available Autonomous Database engine versions in a compartment, optionally filtered by workload.

Field	Type		Details
Compartment OCID	`string`	Required	ocid1.compartment.oc1..aaaa… (use the tenancy OCID for the root)
Workload Filter	`string`		Only versions for this workload type (optional) — choices: Transaction Processing (OLTP), Data Warehouse (DW), JSON Database (AJD), APEX

Returns: tool_result, versions, count, truncated, success, error

OCI Autonomous Database: Restart

oracle/autonomousdatabase/db_restart · Action

Restart an Oracle Cloud Autonomous Database. Asynchronous — returns a work-request id while the database restarts.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, database, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Restore

oracle/autonomousdatabase/db_restore · Action

Restore an Oracle Cloud Autonomous Database to a point in time (a timestamp, or the latest restore point). Asynchronous — returns a work-request id.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…
Restore Timestamp	`string`		Point in time to restore to, RFC3339 e.g. 2026-07-21T14:30:00Z (optional)
Restore to Latest	`boolean`		Restore to the last known good state with the least possible data loss

Returns: tool_result, database, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Rotate Wallet

oracle/autonomousdatabase/db_rotate_wallet · Action

Rotate (invalidate and reissue) the client wallet for an Oracle Cloud Autonomous Database. Existing downloaded wallets stop working.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, success, error

OCI Autonomous Database: Scale

oracle/autonomousdatabase/db_scale · Action

Scale an Oracle Cloud Autonomous Database — change CPU count, storage, or toggle auto-scaling. Asynchronous — returns a work-request id.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…
Compute Model	`string`		Default ECPU — choices: ECPU, OCPU
CPU Count	`string`		New ECPU or OCPU count, e.g. 4 (leave blank to keep current)
Storage (TB)	`string`		New data storage in TB, e.g. 2 (leave blank to keep current)
Compute Auto-scaling	`boolean`		Toggle compute auto-scaling (leave blank to keep current)
Storage Auto-scaling	`boolean`		Toggle storage auto-scaling (leave blank to keep current)

Returns: tool_result, database, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Shrink Storage

oracle/autonomousdatabase/db_shrink · Action

Reclaim unused allocated storage on an Oracle Cloud Autonomous Database. Asynchronous — returns a work-request id.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, database, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Start

oracle/autonomousdatabase/db_start · Action

Start a stopped Oracle Cloud Autonomous Database. Asynchronous — returns a work-request id while the database transitions to AVAILABLE.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, database, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Stop

oracle/autonomousdatabase/db_stop · Action

Stop a running Oracle Cloud Autonomous Database (halts compute billing). Asynchronous — returns a work-request id while the database transitions to STOPPED.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…

Returns: tool_result, database, lifecycle_state, work_request_id, success, error

OCI Autonomous Database: Update Attributes

oracle/autonomousdatabase/db_update · Action

Update editable attributes of an Oracle Cloud Autonomous Database — display name, ADMIN password, license model or allowed IPs. Asynchronous — returns a work-request id.

Field	Type		Details
Autonomous Database OCID	`string`	Required	ocid1.autonomousdatabase.oc1..aaaa…
Display Name	`string`		New friendly name shown in the console (optional)
ADMIN Password	`secret`		New ADMIN password — 12–30 chars, incl. upper, lower and a digit (optional)
License Model	`string`		Optional — choices: License Included, Bring Your Own License
Allowed IPs	`string`		Comma-separated IPs/CIDRs to allow (optional)

Returns: tool_result, database, lifecycle_state, work_request_id, success, error

03Notes & Limitations

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

Most write actions — create, clone, scale, shrink, start, stop, restart, restore, backup, delete and compartment moves — are asynchronous and return a work_request_id immediately, so the database is not yet in its new state when the flow continues; poll db_get until its lifecycle state settles before acting on it.
Per-database actions target the database by its autonomous_database_id OCID typed in directly rather than chosen from a picker, so keep the OCID to hand — for example from a preceding List Databases action.
Deleting a database is permanent and irreversible once the work request completes, with no recycle bin, so create a backup or clone first if the data still matters.
Rotating a wallet invalidates every wallet previously downloaded for that database, so any client or flow still using an old wallet must be re-issued one before it can reconnect.
Always Free databases are a fixed small size, so the scaling action does not apply to them and any compute or storage sizing you set is ignored when Always Free is selected.
Listing databases in a large compartment is capped, so check the truncated output to tell a complete listing from a partial one before treating the result as the full set.