Tool: list_autonomous_databases
List autonomous databases (ADBs) in a Google Cloud project in the given location.
The following sample demonstrate how to use curl to invoke the list_autonomous_databases MCP tool.
| Curl Request |
|---|
curl --location 'https://oracledatabase.googleapis.com/mcp' \ --header 'content-type: application/json' \ --header 'accept: application/json, text/event-stream' \ --data '{ "method": "tools/call", "params": { "name": "list_autonomous_databases", "arguments": { // provide these details according to the tool's MCP specification } }, "jsonrpc": "2.0", "id": 1 }' |
Input Schema
The request for AutonomousDatabase.List.
ListAutonomousDatabasesRequest
| JSON representation |
|---|
{ "parent": string, "pageSize": integer, "pageToken": string, "filter": string, "orderBy": string } |
| Fields | |
|---|---|
parent |
Required. The parent value for the Autonomous Database in the following format: projects/{project}/locations/{location}. |
pageSize |
Optional. The maximum number of items to return. If unspecified, at most 50 Autonomous Database will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000. |
pageToken |
Optional. A token identifying a page of results the server should return. |
filter |
Optional. An expression for filtering the results of the request. |
orderBy |
Optional. An expression for ordering the results of the request. |
Output Schema
The response for AutonomousDatabase.List.
ListAutonomousDatabasesResponse
| JSON representation |
|---|
{
"autonomousDatabases": [
{
object ( |
| Fields | |
|---|---|
autonomousDatabases[] |
The list of Autonomous Databases. |
nextPageToken |
A token identifying a page of results the server should return. |
AutonomousDatabase
| JSON representation |
|---|
{ "name": string, "database": string, "displayName": string, "entitlementId": string, "adminPassword": string, "adminPasswordSecretVersion": string, "properties": { object ( |
| Fields | |
|---|---|
name |
Identifier. The name of the Autonomous Database resource in the following format: projects/{project}/locations/{region}/autonomousDatabases/{autonomous_database} |
database |
Optional. Immutable. The name of the Autonomous Database. The database name must be unique in the project. The name must begin with a letter and can contain a maximum of 30 alphanumeric characters. |
displayName |
Optional. Immutable. The display name for the Autonomous Database. The name does not have to be unique within your project. |
entitlementId |
Output only. The ID of the subscription entitlement associated with the Autonomous Database. |
adminPassword |
Optional. Immutable. The password for the default ADMIN user. Note: Only one of |
adminPasswordSecretVersion |
Optional. Immutable. The resource name of a secret version in Secret Manager which contains the database admin user's password. Format: projects/{project}/secrets/{secret}/versions/{version}. Note: Only one of |
properties |
Optional. The properties of the Autonomous Database. |
labels |
Optional. The labels or tags associated with the Autonomous Database. An object containing a list of |
network |
Optional. Immutable. The name of the VPC network used by the Autonomous Database in the following format: projects/{project}/global/networks/{network} |
cidr |
Optional. Immutable. The subnet CIDR range for the Autonomous Database. |
odbNetwork |
Optional. Immutable. The name of the OdbNetwork associated with the Autonomous Database. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network} It is optional but if specified, this should match the parent ODBNetwork of the OdbSubnet. |
odbSubnet |
Optional. Immutable. The name of the OdbSubnet associated with the Autonomous Database. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet} |
sourceConfig |
Optional. Immutable. The source Autonomous Database configuration for the standby Autonomous Database. The source Autonomous Database is configured while creating the Peer Autonomous Database and can't be updated after creation. |
peerAutonomousDatabases[] |
Output only. The peer Autonomous Database names of the given Autonomous Database. |
createTime |
Output only. The date and time that the Autonomous Database was created. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
disasterRecoverySupportedLocations[] |
Output only. List of supported GCP region to clone the Autonomous Database for disaster recovery. Format: |
AutonomousDatabaseProperties
| JSON representation |
|---|
{ "ocid": string, "computeCount": number, "cpuCoreCount": integer, "dataStorageSizeTb": integer, "dataStorageSizeGb": integer, "dbWorkload": enum ( |
| Fields | |
|---|---|
ocid |
Output only. OCID of the Autonomous Database. https://docs.oracle.com/en-us/iaas/Content/General/Concepts/identifiers.htm#Oracle |
computeCount |
Optional. Immutable. The number of compute servers for the Autonomous Database. |
cpuCoreCount |
Optional. Immutable. The number of CPU cores to be made available to the database. |
dataStorageSizeTb |
Optional. Immutable. The size of the data stored in the database, in terabytes. |
dataStorageSizeGb |
Optional. Immutable. The size of the data stored in the database, in gigabytes. |
dbWorkload |
Required. Immutable. The workload type of the Autonomous Database. |
dbEdition |
Optional. Immutable. The edition of the Autonomous Databases. |
characterSet |
Optional. Immutable. The character set for the Autonomous Database. The default is AL32UTF8. |
nCharacterSet |
Optional. Immutable. The national character set for the Autonomous Database. The default is AL16UTF16. |
privateEndpointIp |
Optional. Immutable. The private endpoint IP address for the Autonomous Database. |
privateEndpointLabel |
Optional. Immutable. The private endpoint label for the Autonomous Database. |
dbVersion |
Optional. Immutable. The Oracle Database version for the Autonomous Database. |
isAutoScalingEnabled |
Optional. Immutable. This field indicates if auto scaling is enabled for the Autonomous Database CPU core count. |
isStorageAutoScalingEnabled |
Optional. Immutable. This field indicates if auto scaling is enabled for the Autonomous Database storage. |
licenseType |
Required. Immutable. The license type used for the Autonomous Database. |
customerContacts[] |
Optional. Immutable. The list of customer contacts. |
secretId |
Optional. Immutable. The ID of the Oracle Cloud Infrastructure vault secret. |
vaultId |
Optional. Immutable. The ID of the Oracle Cloud Infrastructure vault. |
maintenanceScheduleType |
Optional. Immutable. The maintenance schedule of the Autonomous Database. |
mtlsConnectionRequired |
Optional. Immutable. This field specifies if the Autonomous Database requires mTLS connections. |
backupRetentionPeriodDays |
Optional. Immutable. The retention period for the Autonomous Database. This field is specified in days, can range from 1 day to 60 days, and has a default value of 60 days. |
actualUsedDataStorageSizeTb |
Output only. The amount of storage currently being used for user and system data, in terabytes. |
allocatedStorageSizeTb |
Output only. The amount of storage currently allocated for the database tables and billed for, rounded up in terabytes. |
apexDetails |
Output only. The details for the Oracle APEX Application Development. |
lifecycleDetails |
Output only. The details of the current lifestyle state of the Autonomous Database. |
state |
Output only. The current lifecycle state of the Autonomous Database. |
autonomousContainerDatabaseId |
Output only. The Autonomous Container Database OCID. |
availableUpgradeVersions[] |
Output only. The list of available Oracle Database upgrade versions for an Autonomous Database. |
connectionStrings |
Output only. The connection strings used to connect to an Autonomous Database. |
connectionUrls |
Output only. The Oracle Connection URLs for an Autonomous Database. |
failedDataRecoveryDuration |
Output only. This field indicates the number of seconds of data loss during a Data Guard failover. A duration in seconds with up to nine fractional digits, ending with ' |
memoryTableGbs |
Output only. The memory assigned to in-memory tables in an Autonomous Database. |
isLocalDataGuardEnabled |
Output only. Deprecated: Please use |
localAdgAutoFailoverMaxDataLossLimit |
Output only. Deprecated: Please use |
localStandbyDb |
Output only. The details of the Autonomous Data Guard standby database. |
memoryPerOracleComputeUnitGbs |
Output only. The amount of memory enabled per ECPU, in gigabytes. |
localDisasterRecoveryType |
Output only. This field indicates the local disaster recovery (DR) type of an Autonomous Database. |
dataSafeState |
Output only. The current state of the Data Safe registration for the Autonomous Database. |
databaseManagementState |
Output only. The current state of database management for the Autonomous Database. |
openMode |
Output only. This field indicates the current mode of the Autonomous Database. |
operationsInsightsState |
Output only. This field indicates the state of Operations Insights for the Autonomous Database. |
peerDbIds[] |
Output only. The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. |
permissionLevel |
Output only. The permission level of the Autonomous Database. |
privateEndpoint |
Output only. The private endpoint for the Autonomous Database. |
refreshableMode |
Output only. The refresh mode of the cloned Autonomous Database. |
refreshableState |
Output only. The refresh State of the clone. |
role |
Output only. The Data Guard role of the Autonomous Database. |
scheduledOperationDetails[] |
Output only. The list and details of the scheduled operations of the Autonomous Database. |
sqlWebDeveloperUrl |
Output only. The SQL Web Developer URL for the Autonomous Database. |
supportedCloneRegions[] |
Output only. The list of available regions that can be used to create a clone for the Autonomous Database. |
usedDataStorageSizeTbs |
Output only. The storage space used by Autonomous Database, in gigabytes. |
ociUrl |
Output only. The Oracle Cloud Infrastructure link for the Autonomous Database. |
totalAutoBackupStorageSizeGbs |
Output only. The storage space used by automatic backups of Autonomous Database, in gigabytes. |
nextLongTermBackupTime |
Output only. The long term backup schedule of the Autonomous Database. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
dataGuardRoleChangedTime |
Output only. The date and time the Autonomous Data Guard role was changed for the standby Autonomous Database. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
disasterRecoveryRoleChangedTime |
Output only. The date and time the Disaster Recovery role was changed for the standby Autonomous Database. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
maintenanceBeginTime |
Output only. The date and time when maintenance will begin. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
maintenanceEndTime |
Output only. The date and time when maintenance will end. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
allowlistedIps[] |
Optional. Immutable. The list of allowlisted IP addresses for the Autonomous Database. |
encryptionKey |
Optional. The encryption key used to encrypt the Autonomous Database. Updating this field will add a new entry in the |
encryptionKeyHistoryEntries[] |
Output only. The history of the encryption keys used to encrypt the Autonomous Database. |
serviceAgentEmail |
Output only. An Oracle-managed Google Cloud service account on which customers can grant roles to access resources in the customer project. |
Union field
|
|
arePrimaryAllowlistedIpsUsed |
Output only. This field indicates the status of Data Guard and Access control for the Autonomous Database. The field's value is null if Data Guard is disabled or Access Control is disabled. The field's value is TRUE if both Data Guard and Access Control are enabled, and the Autonomous Database is using primary IP access control list (ACL) for standby. The field's value is FALSE if both Data Guard and Access Control are enabled, and the Autonomous Database is using a different IP access control list (ACL) for standby compared to primary. |
Union field
|
|
localDataGuardEnabled |
Optional. Indicates whether the Autonomous Database has a local (in-region) standby database. Not applicable to cross-region Data Guard or dedicated Exadata infrastructure. |
Union field
|
|
localAdgAutoFailoverMaxDataLossLimitDuration |
Optional. This field indicates the maximum data loss limit for an Autonomous Database, in seconds. |
CustomerContact
| JSON representation |
|---|
{ "email": string } |
| Fields | |
|---|---|
email |
Required. The email address used by Oracle to send notifications regarding databases and infrastructure. |
AutonomousDatabaseApex
| JSON representation |
|---|
{ "apexVersion": string, "ordsVersion": string } |
| Fields | |
|---|---|
apexVersion |
Output only. The Oracle APEX Application Development version. |
ordsVersion |
Output only. The Oracle REST Data Services (ORDS) version. |
AutonomousDatabaseConnectionStrings
| JSON representation |
|---|
{ "allConnectionStrings": { object ( |
| Fields | |
|---|---|
allConnectionStrings |
Output only. Returns all connection strings that can be used to connect to the Autonomous Database. |
dedicated |
Output only. The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements. |
high |
Output only. The database service provides the highest level of resources to each SQL statement. |
low |
Output only. The database service provides the least level of resources to each SQL statement. |
medium |
Output only. The database service provides a lower level of resources to each SQL statement. |
profiles[] |
Output only. A list of connection string profiles to allow clients to group, filter, and select values based on the structured metadata. |
AllConnectionStrings
| JSON representation |
|---|
{ "high": string, "low": string, "medium": string } |
| Fields | |
|---|---|
high |
Output only. The database service provides the highest level of resources to each SQL statement. |
low |
Output only. The database service provides the least level of resources to each SQL statement. |
medium |
Output only. The database service provides a lower level of resources to each SQL statement. |
DatabaseConnectionStringProfile
| JSON representation |
|---|
{ "consumerGroup": enum ( |
| Fields | |
|---|---|
consumerGroup |
Output only. The current consumer group being used by the connection. |
displayName |
Output only. The display name for the database connection. |
hostFormat |
Output only. The host name format being currently used in connection string. |
isRegional |
Output only. This field indicates if the connection string is regional and is only applicable for cross-region Data Guard. |
protocol |
Output only. The protocol being used by the connection. |
sessionMode |
Output only. The current session mode of the connection. |
syntaxFormat |
Output only. The syntax of the connection string. |
tlsAuthentication |
Output only. This field indicates the TLS authentication type of the connection. |
value |
Output only. The value of the connection string. |
AutonomousDatabaseConnectionUrls
| JSON representation |
|---|
{ "apexUri": string, "databaseTransformsUri": string, "graphStudioUri": string, "machineLearningNotebookUri": string, "machineLearningUserManagementUri": string, "mongoDbUri": string, "ordsUri": string, "sqlDevWebUri": string } |
| Fields | |
|---|---|
apexUri |
Output only. Oracle Application Express (APEX) URL. |
databaseTransformsUri |
Output only. The URL of the Database Transforms for the Autonomous Database. |
graphStudioUri |
Output only. The URL of the Graph Studio for the Autonomous Database. |
machineLearningNotebookUri |
Output only. The URL of the Oracle Machine Learning (OML) Notebook for the Autonomous Database. |
machineLearningUserManagementUri |
Output only. The URL of Machine Learning user management the Autonomous Database. |
mongoDbUri |
Output only. The URL of the MongoDB API for the Autonomous Database. |
ordsUri |
Output only. The Oracle REST Data Services (ORDS) URL of the Web Access for the Autonomous Database. |
sqlDevWebUri |
Output only. The URL of the Oracle SQL Developer Web for the Autonomous Database. |
Duration
| JSON representation |
|---|
{ "seconds": string, "nanos": integer } |
| Fields | |
|---|---|
seconds |
Signed seconds of the span of time. Must be from -315,576,000,000 to +315,576,000,000 inclusive. Note: these bounds are computed from: 60 sec/min * 60 min/hr * 24 hr/day * 365.25 days/year * 10000 years |
nanos |
Signed fractions of a second at nanosecond resolution of the span of time. Durations less than one second are represented with a 0 |
AutonomousDatabaseStandbySummary
| JSON representation |
|---|
{
"lagTimeDuration": string,
"lifecycleDetails": string,
"state": enum ( |
| Fields | |
|---|---|
lagTimeDuration |
Output only. The amount of time, in seconds, that the data of the standby database lags in comparison to the data of the primary database. A duration in seconds with up to nine fractional digits, ending with ' |
lifecycleDetails |
Output only. The additional details about the current lifecycle state of the Autonomous Database. |
state |
Output only. The current lifecycle state of the Autonomous Database. |
dataGuardRoleChangedTime |
Output only. The date and time the Autonomous Data Guard role was switched for the standby Autonomous Database. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
disasterRecoveryRoleChangedTime |
Output only. The date and time the Disaster Recovery role was switched for the standby Autonomous Database. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
Timestamp
| JSON representation |
|---|
{ "seconds": string, "nanos": integer } |
| Fields | |
|---|---|
seconds |
Represents seconds of UTC time since Unix epoch 1970-01-01T00:00:00Z. Must be between -62135596800 and 253402300799 inclusive (which corresponds to 0001-01-01T00:00:00Z to 9999-12-31T23:59:59Z). |
nanos |
Non-negative fractions of a second at nanosecond resolution. This field is the nanosecond portion of the duration, not an alternative to seconds. Negative second values with fractions must still have non-negative nanos values that count forward in time. Must be between 0 and 999,999,999 inclusive. |
ScheduledOperationDetails
| JSON representation |
|---|
{ "dayOfWeek": enum ( |
| Fields | |
|---|---|
dayOfWeek |
Output only. Day of week. |
startTime |
Output only. Auto start time. |
stopTime |
Output only. Auto stop time. |
TimeOfDay
| JSON representation |
|---|
{ "hours": integer, "minutes": integer, "seconds": integer, "nanos": integer } |
| Fields | |
|---|---|
hours |
Hours of a day in 24 hour format. Must be greater than or equal to 0 and typically must be less than or equal to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time. |
minutes |
Minutes of an hour. Must be greater than or equal to 0 and less than or equal to 59. |
seconds |
Seconds of a minute. Must be greater than or equal to 0 and typically must be less than or equal to 59. An API may allow the value 60 if it allows leap-seconds. |
nanos |
Fractions of seconds, in nanoseconds. Must be greater than or equal to 0 and less than or equal to 999,999,999. |
EncryptionKey
| JSON representation |
|---|
{
"provider": enum ( |
| Fields | |
|---|---|
provider |
Optional. The provider of the encryption key. |
kmsKey |
Optional. The KMS key used to encrypt the Autonomous Database. This field is required if the provider is GOOGLE_MANAGED. The name of the KMS key resource in the following format: |
EncryptionKeyHistoryEntry
| JSON representation |
|---|
{
"encryptionKey": {
object ( |
| Fields | |
|---|---|
encryptionKey |
Output only. The encryption key used to encrypt the Autonomous Database. |
activationTime |
Output only. The date and time when the encryption key was activated on the Autonomous Database.. Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: |
LabelsEntry
| JSON representation |
|---|
{ "key": string, "value": string } |
| Fields | |
|---|---|
key |
|
value |
|
SourceConfig
| JSON representation |
|---|
{ "autonomousDatabase": string, "automaticBackupsReplicationEnabled": boolean } |
| Fields | |
|---|---|
autonomousDatabase |
Optional. The name of the primary Autonomous Database that is used to create a Peer Autonomous Database from a source. |
automaticBackupsReplicationEnabled |
Optional. This field specifies if the replication of automatic backups is enabled when creating a Data Guard. |
Tool Annotations
Destructive Hint: ❌ | Idempotent Hint: ❌ | Read Only Hint: ✅ | Open World Hint: ❌