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
|
Required. The parent value for database server in the following format: projects/{project}/locations/{location}/cloudExadataInfrastructures/{cloudExadataInfrastructure}. |
pageSize
|
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
|
Optional. A token identifying a page of results the server should return. |
Output Schema
The response for DbServer.List
.
ListDbServersResponse
| JSON representation |
|---|
{
"dbServers"
:
[
{
object (
|
| Fields | |
|---|---|
dbServers[]
|
The list of database servers. |
nextPageToken
|
A token identifying a page of results the server should return. |
DbServer
| JSON representation |
|---|
{
"name"
:
string
,
"displayName"
:
string
,
"properties"
:
{
object (
|
| Fields | |
|---|---|
name
|
Identifier. The name of the database server resource with the format: projects/{project}/locations/{location}/cloudExadataInfrastructures/{cloud_exadata_infrastructure}/dbServers/{db_server} |
displayName
|
Optional. User friendly name for this resource. |
properties
|
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 (
|
| Fields | |
|---|---|
ocid
|
Output only. OCID of database server. |
ocpuCount
|
Optional. OCPU count per database. |
maxOcpuCount
|
Optional. Maximum OCPU count per database. |
memorySizeGb
|
Optional. Memory allocated in GBs. |
maxMemorySizeGb
|
Optional. Maximum memory allocated in GBs. |
dbNodeStorageSizeGb
|
Optional. Local storage per VM. |
maxDbNodeStorageSizeGb
|
Optional. Maximum local storage per VM. |
vmCount
|
Optional. Vm count per database. |
state
|
Output only. State of the database server. |
dbNodeIds[]
|
Output only. OCID of database nodes associated with the database server. |
Tool Annotations
Destructive Hint: ❌ | Idempotent Hint: ❌ | Read Only Hint: ✅ | Open World Hint: ❌
