MCP Tools Reference: oracledatabase.googleapis.com

Tool: list_database_connections

Lists all Database Connection (DatabaseConnection / DBC) resources within a specified Google Cloud project and location.

Use this tool to discover existing database connections (DBCs) and retrieve their resource names (name), display names, database usernames, connection strings, and associated ODB networks.

Parameters:

• parent (string, required): The parent project and location. Format: projects/{project}/locations/{location}
• page_size (integer, optional): The maximum number of DatabaseConnections (DBCs) to return per page.
• page_token (string, optional): A pagination token returned from a previous list_database_connections call.
• filter (string, optional): An expression to filter results (e.g. by display_name or state).
• order_by (string, optional): An expression to sort results.

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

Input Schema

The request for DatabaseConnection.List.

ListDatabaseConnectionsRequest

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

Fields
parent	string Required. The parent value for the DatabaseConnection in the following format: projects/{project}/locations/{location}.
pageSize	integer Optional. The maximum number of items to return. If unspecified, at most 50 DatabaseConnections will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000.
pageToken	string Optional. A token identifying a page of results the server should return.
filter	string Optional. An expression for filtering the results of the request.
orderBy	string Optional. An expression for ordering the results of the request.

Output Schema

The response for DatabaseConnection.List.

ListDatabaseConnectionsResponse

JSON representation
{ "databaseConnections": [ { object (DatabaseConnection) } ], "nextPageToken": string, "unreachable": [ string ] }

Fields
databaseConnections[]	object (DatabaseConnection) The list of DatabaseConnections.
nextPageToken	string A token identifying a page of results the server should return.
unreachable[]	string Unreachable locations when listing resources across all locations using wildcard location '-'.

DatabaseConnection

JSON representation

{ "name": string, "displayName": string, "username": string, "passwordSecretVersion": string, "connectionString": string, "state": enum (State), "labels": { string: string, ... }, "createTime": string, "updateTime": string, "lifecycleDetails": string, // Union field wallet_source can be only one of the following: "walletSecretVersion": string // End of list of possible types for union field wallet_source. // Union field network_configuration can be only one of the following: "odbNetwork": string // End of list of possible types for union field network_configuration. }

Fields
name	string Identifier. The resource name of the DatabaseConnection. Format: projects/{project}/locations/{location}/databaseConnections/{database_connection}
displayName	string Optional. Immutable. User-friendly display name for the connection.
username	string Optional. Immutable. The default database username to use for connections.
passwordSecretVersion	string Optional. The resource name of the GCP Secret Manager secret version containing the password for the specified username. Format: projects/{project}/secrets/{secret_id}/versions/{version_id} The service's Per-Product Per-Project Service Account (P4SA) must have the 'secretmanager.secretAccessor' permission on this secret.
connectionString	string Required. Immutable. Oracle Easy Connect or TNS connection string. Example: "your-db-host.example.com:1521/YOUR_SERVICE_NAME"
state	enum (State) Output only. The current state of the connection.
labels	map (key: string, value: string) Optional. Optional: Labels as key-value pairs to organize the resource. An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.
createTime	string (Timestamp format) Output only. The create time of the resource. 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".
updateTime	string (Timestamp format) Output only. The update time of the resource. 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".
lifecycleDetails	string Output only. Additional information about the current state of the connection.
Union field wallet_source. How the Oracle Wallet is supplied for secure TLS/mTLS connections. wallet_source can be only one of the following:
walletSecretVersion	string Optional. Optional: The resource name of the GCP Secret Manager secret version containing base64 encoded content of the Oracle Wallet ZIP file required for mTLS/TLS connections. Format: projects/{project}/secrets/{secret_id}/versions/{version_id} The service's Per-Product Per-Project Service Account (P4SA) must have the 'secretmanager.secretAccessor' permission on this secret.
Union field network_configuration. Network configuration for reaching the database. network_configuration can be only one of the following:
odbNetwork	string Optional. Immutable. For Oracle Database@Google cloud resources. Format: projects/{project}/locations/{location}/odbNetworks/{odbNetwork}

LabelsEntry

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

Fields
key	string
value	string

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.

State

States of the DatabaseConnection resource.

Enums
STATE_UNSPECIFIED	Default unspecified value.
CREATING	Indicates that the resource is in a creating state.
ACTIVE	Indicates that the resource is in an active state.
FAILED	Indicates that the resource is in a failed state.
DELETING	Indicates that the resource is in a deleting state.

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: ❌