Data Source: oci_database_tools_database_tools_mcp_servers

This data source provides the list of Database Tools Mcp Servers in Oracle Cloud Infrastructure Database Tools service.

Returns a list of Database Tools MCP servers.

Example Usage

data "oci_database_tools_database_tools_mcp_servers" "test_database_tools_mcp_servers" {
	#Required
	compartment_id = var.compartment_id

	#Optional
	database_tools_connection_id = oci_database_tools_database_tools_connection.test_database_tools_connection.id
	display_name = var.database_tools_mcp_server_display_name
	related_resource_identifier = var.database_tools_mcp_server_related_resource_identifier
	state = var.database_tools_mcp_server_state
	type = var.database_tools_mcp_server_type
}

Argument Reference

The following arguments are supported:

• compartment_id - (Required) The OCID of the compartment in which to list resources.
• database_tools_connection_id - (Optional) A filter to return only resources when their databaseToolsConnectionId matches the specified databaseToolsConnectionId.
• display_name - (Optional) A filter to return only resources that match the entire specified display name.
• related_resource_identifier - (Optional) The OCID of the related resource.
• state - (Optional) A filter to return resources only when their databaseToolsMcpServerLifecycleState matches the specified databaseToolsMcpServerLifecycleState.
• type - (Optional) A filter to return only resources with one of the specified type values.

Attributes Reference

The following attributes are exported:

• database_tools_mcp_server_collection - The list of database_tools_mcp_server_collection.

DatabaseToolsMcpServer Reference

The following attributes are exported:

• access_token_expiry_in_seconds - Access token expiry in seconds
• built_in_roles - Built-in roles associated with the MCP Server.
  • description - The description of the built-in role.
  • display_name - The display name of the built-in role.
• compartment_id - The OCID of the compartment containing the Database Tools MCP server.
• custom_roles - Custom roles associated with the MCP Server.
  • description - The description of the custom role.
  • display_name - The display name of the custom role.
• database_tools_connection_id - The OCID of the related Database Tools connection.
• defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
• description - A human-readable description of the Database Tools MCP server.
• display_name - A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
• domain_app_id - The OCID of the associated domain application (Oracle Cloud Service).
• domain_id - The OCID of the associated identity domain.
• endpoints - Invoke endpoints for the MCP server.
  • endpoint - The URI endpoint of the MCP server
  • type - The MCP server type
• freeform_tags - Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
• id - The OCID of the Database Tools MCP server.
• lifecycle_details - A message describing the current state in more detail. For example, this message can be used to provide actionable information for a resource in the Failed state.
• locks - Locks associated with this resource.
  • message - A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
  • related_resource_id - The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
  • time_created - When the lock was created.
  • type - Type of the lock.
• refresh_token_expiry_in_seconds - Refresh token expiry in seconds
• related_resource - A related resource
  • entity_type - The resource entity type.
  • identifier - The OCID of the related resource.
• runtime_identity - Specifies the identity used by the Database Tools MCP server to issue requests to other Oracle Cloud Infrastructure services (e.g., Secrets in Vault).
• state - The current state of the Database Tools MCP server.
• storage - The storage option used when running a tool asynchronously.
  • bucket - A Cloud Storage bucket for an MCP Server.
    • bucket - The Object Storage bucket to use.
    • namespace - The Object Storage namespace to use.
  • type - The type of storage used for asynchronous tool calls.
• system_tags - Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
• time_created - The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
• time_updated - The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
• type - The Database Tools MCP server type.