MCP Tools Reference: oracledatabase.googleapis.com

Tool: list_goldengate_assignments

List Goldengate Connection Assignments in a Google Cloud project in the given location.

The following code sample shows how to use curl to call the list_goldengate_assignments 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_goldengate_assignments",
    "arguments": {
      // Provide these details according to the MCP tool specification.
    }
  },
  "jsonrpc": "2.0",
  "id": 1
}'

Input Schema

Request message for listing GoldengateConnectionAssignments.

ListGoldengateConnectionAssignmentsRequest

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

string

Required. The parent value for the GoldengateConnectionAssignments. Format: projects/{project}/locations/{location}
pageSize

integer

Optional. The maximum number of GoldengateConnectionAssignments to return. The service may return fewer than this value. If unspecified, at most 50 GoldengateConnectionAssignments will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000.
pageToken

string

Optional. A page token, received from a previous ListGoldengateConnectionAssignments call. Provide this to retrieve the subsequent page.

When paginating, all other parameters provided to ListGoldengateConnectionAssignments must match the call that provided the page token.
filter

string

Optional. A filter expression that filters GoldengateConnectionAssignments listed in the response.
orderBy

string

Optional. A comma-separated list of fields to order by, sorted in ascending order. Use "DESC" after a field name for descending.

Output Schema

Response message for listing GoldengateConnectionAssignments.

ListGoldengateConnectionAssignmentsResponse

JSON representation 
{
  "goldengateConnectionAssignments": [
    {
      object (GoldengateConnectionAssignment)
    }
  ],
  "nextPageToken": string,
  "unreachable": [
    string
  ]
}
Fields
goldengateConnectionAssignments[]

object (GoldengateConnectionAssignment)

The list of GoldengateConnectionAssignments.
nextPageToken

string

A token, which can be sent as page_token to retrieve the next page. If this field is omitted, there are no subsequent pages.
unreachable[]

string

Unreachable locations when listing resources across all locations using wildcard location '-'.

GoldengateConnectionAssignment

JSON representation 
{
  "name": string,
  "properties": {
    object (GoldengateConnectionAssignmentProperties)
  },
  "createTime": string,
  "labels": {
    string: string,
    ...
  },
  "displayName": string,
  "entitlementId": string
}
Fields
name

string

Identifier. The name of the GoldengateConnectionAssignment resource in the following format: projects/{project}/locations/{region}/goldengateConnectionAssignments/{goldengate_connection_assignment}
properties

object (GoldengateConnectionAssignmentProperties)

Required. Immutable. The properties of the GoldengateConnectionAssignment.
createTime

string (Timestamp format)

Output only. The time when the connection assignment 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: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".
labels

map (key: string, value: string)

Optional. The labels or tags associated with the GoldengateConnectionAssignment.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.
displayName

string

Optional. Immutable. The display name for the GoldengateConnectionAssignment.
entitlementId

string

Output only. The OCID of the entitlement linked to this resource.

GoldengateConnectionAssignmentProperties

JSON representation 
{
  "ocid": string,
  "goldengateConnection": string,
  "goldengateDeployment": string,
  "alias": string,
  "state": enum (State)
}
Fields
ocid

string

Output only. The OCID of the connection assignment being referenced.
goldengateConnection

string

Required. The GoldengateConnection resource to be assigned. Format: projects/{project}/locations/{location}/goldengateConnections/{goldengate_connection}
goldengateDeployment

string

Required. The GoldenGateDeployment to assign the connection to. Format: projects/{project}/locations/{location}/goldengateDeployments/{goldengate_deployment}
alias

string

Output only. Credential store alias.
state

enum (State)

Output only. The lifecycle state of the connection assignment.

Timestamp

JSON representation 
{
  "seconds": string,
  "nanos": integer
}
Fields
seconds

string (int64 format)

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

integer

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.

LabelsEntry

JSON representation 
{
  "key": string,
  "value": string
}
Fields
key

string
value

string

State

Possible lifecycle states for connection assignments.

Enums
STATE_UNSPECIFIED Lifecycle state is unspecified.
CREATING Connection assignment is being created.
ACTIVE Connection assignment is active.
FAILED Connection assignment failed.
UPDATING Connection assignment is being updated.
DELETING Connection assignment is being deleted.

Tool Annotations

Tool annotations are sent to MCP clients to describe the basic risk of a given tool. Most clients treat these hints as untrusted, but they can be used to decide when a confirmation prompt might be sent to a user.

Along with the title string, the following boolean hints are defined as follows:

  • readOnlyHint: If true, the tool doesn't modify its environment. Default: false.
  • destructiveHint: If true, then the tool can perform destructive actions. If false, then the tool can only perform additive actions. Default: true.
  • idempotentHint: If true, then calling the tool repeatedly with the same arguments will have no additional effect on its environment. Default: false.
  • openWorldHint: If true, then the tool can interact with an 'open world' of external entities. If false, then the tool can only interact with internal entities. For example, a web search tool would be open world, while a memory tool would not be open world.

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