MCP Tools Reference: oracledatabase.googleapis.com

Tool: list_db_servers

List Db Servers in a Google Cloud project in the given location for a given Cloud Exadata Infrastructure. For creation of a Cloud Vm Cluster, we need to know the Db Servers in a Cloud Exadata Infrastructure. This API will be used by the MCP service to get the Db Servers.

The following sample demonstrate how to use curl to invoke the list_db_servers 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_db_servers",
    "arguments": {
      // provide these details according to the tool's MCP specification
    }
  },
  "jsonrpc": "2.0",
  "id": 1
}'

Input Schema

The request for DbServer.List.

ListDbServersRequest

JSON representation 
{
  "parent": string,
  "pageSize": integer,
  "pageToken": string
}
Fields
parent

string

Required. The parent value for database server in the following format: projects/{project}/locations/{location}/cloudExadataInfrastructures/{cloudExadataInfrastructure}.
pageSize

integer

Optional. The maximum number of items to return. If unspecified, a maximum of 50 db servers will be returned. The maximum value is 1000; values above 1000 will be reset to 1000.
pageToken

string

Optional. A token identifying a page of results the server should return.

Output Schema

The response for DbServer.List.

ListDbServersResponse

JSON representation 
{
  "dbServers": [
    {
      object (DbServer)
    }
  ],
  "nextPageToken": string
}
Fields
dbServers[]

object (DbServer)

The list of database servers.
nextPageToken

string

A token identifying a page of results the server should return.

DbServer

JSON representation 
{
  "name": string,
  "displayName": string,
  "properties": {
    object (DbServerProperties)
  }
}
Fields
name

string

Identifier. The name of the database server resource with the format: projects/{project}/locations/{location}/cloudExadataInfrastructures/{cloud_exadata_infrastructure}/dbServers/{db_server}
displayName

string

Optional. User friendly name for this resource.
properties

object (DbServerProperties)

Optional. Various properties of the database server.

DbServerProperties

JSON representation 
{
  "ocid": string,
  "ocpuCount": integer,
  "maxOcpuCount": integer,
  "memorySizeGb": integer,
  "maxMemorySizeGb": integer,
  "dbNodeStorageSizeGb": integer,
  "maxDbNodeStorageSizeGb": integer,
  "vmCount": integer,
  "state": enum (State),
  "dbNodeIds": [
    string
  ]
}
Fields
ocid

string

Output only. OCID of database server.
ocpuCount

integer

Optional. OCPU count per database.
maxOcpuCount

integer

Optional. Maximum OCPU count per database.
memorySizeGb

integer

Optional. Memory allocated in GBs.
maxMemorySizeGb

integer

Optional. Maximum memory allocated in GBs.
dbNodeStorageSizeGb

integer

Optional. Local storage per VM.
maxDbNodeStorageSizeGb

integer

Optional. Maximum local storage per VM.
vmCount

integer

Optional. Vm count per database.
state

enum (State)

Output only. State of the database server.
dbNodeIds[]

string

Output only. OCID of database nodes associated with the database server.

Tool Annotations

Destructive Hint: ❌ | Idempotent Hint: ❌ | Read Only Hint: ✅ | Open World Hint: ❌