CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails¶

class oci.database_tools.models.CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails(**kwargs)¶

Bases: oci.database_tools.models.create_database_tools_mcp_toolset_details.CreateDatabaseToolsMcpToolsetDetails

Details for the new Database Tools MCP Toolset of type GenAI SQL Assistant.

Attributes

`DEFAULT_EXECUTION_TYPE_ASYNCHRONOUS`	A constant which can be used with the default_execution_type property of a CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
`DEFAULT_EXECUTION_TYPE_SYNCHRONOUS`	A constant which can be used with the default_execution_type property of a CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
`TYPE_BUILT_IN_SQL_TOOLS`	str(object=’’) -> str
`TYPE_CUSTOMIZABLE_REPORTING_TOOLS`	str(object=’’) -> str
`TYPE_CUSTOM_SQL_TOOL`	str(object=’’) -> str
`TYPE_GENAI_SQL_ASSISTANT`	str(object=’’) -> str
`compartment_id`	[Required] Gets the compartment_id of this CreateDatabaseToolsMcpToolsetDetails.
`database_tools_mcp_server_id`	[Required] Gets the database_tools_mcp_server_id of this CreateDatabaseToolsMcpToolsetDetails.
`default_execution_type`	Gets the default_execution_type of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
`defined_tags`	Gets the defined_tags of this CreateDatabaseToolsMcpToolsetDetails.
`description`	Gets the description of this CreateDatabaseToolsMcpToolsetDetails.
`display_name`	[Required] Gets the display_name of this CreateDatabaseToolsMcpToolsetDetails.
`freeform_tags`	Gets the freeform_tags of this CreateDatabaseToolsMcpToolsetDetails.
`generative_ai_semantic_store_id`	[Required] Gets the generative_ai_semantic_store_id of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
`locks`	Gets the locks of this CreateDatabaseToolsMcpToolsetDetails.
`tools`	Gets the tools of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
`type`	[Required] Gets the type of this CreateDatabaseToolsMcpToolsetDetails.
`version`	[Required] Gets the version of this CreateDatabaseToolsMcpToolsetDetails.

Methods

`__init__`(**kwargs)	Initializes a new CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails object with values from keyword arguments.
`get_subtype`(object_dictionary)	Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

DEFAULT_EXECUTION_TYPE_ASYNCHRONOUS = 'ASYNCHRONOUS'¶: A constant which can be used with the default_execution_type property of a CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails. This constant has a value of “ASYNCHRONOUS”

DEFAULT_EXECUTION_TYPE_SYNCHRONOUS = 'SYNCHRONOUS'¶: A constant which can be used with the default_execution_type property of a CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails. This constant has a value of “SYNCHRONOUS”

TYPE_BUILT_IN_SQL_TOOLS = 'BUILT_IN_SQL_TOOLS'¶

TYPE_CUSTOMIZABLE_REPORTING_TOOLS = 'CUSTOMIZABLE_REPORTING_TOOLS'¶

TYPE_CUSTOM_SQL_TOOL = 'CUSTOM_SQL_TOOL'¶

TYPE_GENAI_SQL_ASSISTANT = 'GENAI_SQL_ASSISTANT'¶

__init__(**kwargs)¶

Initializes a new CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails object with values from keyword arguments. The default value of the type attribute of this class is GENAI_SQL_ASSISTANT and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

version (int) – The value to assign to the version property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
compartment_id (str) – The value to assign to the compartment_id property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
display_name (str) – The value to assign to the display_name property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
database_tools_mcp_server_id (str) – The value to assign to the database_tools_mcp_server_id property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
description (str) – The value to assign to the description property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
type (str) – The value to assign to the type property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails. Allowed values for this property are: “CUSTOM_SQL_TOOL”, “BUILT_IN_SQL_TOOLS”, “CUSTOMIZABLE_REPORTING_TOOLS”, “GENAI_SQL_ASSISTANT”
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
locks (list[oci.database_tools.models.ResourceLock]) – The value to assign to the locks property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
generative_ai_semantic_store_id (str) – The value to assign to the generative_ai_semantic_store_id property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
tools (list[oci.database_tools.models.CreateDatabaseToolsMcpToolsetToolDetails]) – The value to assign to the tools property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
default_execution_type (str) – The value to assign to the default_execution_type property of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails. Allowed values for this property are: “SYNCHRONOUS”, “ASYNCHRONOUS”

compartment_id¶

[Required] Gets the compartment_id of this CreateDatabaseToolsMcpToolsetDetails. The OCID of the compartment containing the Database Tools MCP server.

Returns:	The compartment_id of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	str

database_tools_mcp_server_id¶

[Required] Gets the database_tools_mcp_server_id of this CreateDatabaseToolsMcpToolsetDetails. The OCID of the Database Tools MCP Server

Returns:	The database_tools_mcp_server_id of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	str

default_execution_type¶

Gets the default_execution_type of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails. The default execution type for the toolset. The default value is SYNCHRONOUS.

To use ASYNCHRONOUS execution, the MCP Server must have the storage property configured.

Allowed values for this property are: “SYNCHRONOUS”, “ASYNCHRONOUS”

Returns:	The default_execution_type of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
Return type:	str

defined_tags¶

Gets the defined_tags of this CreateDatabaseToolsMcpToolsetDetails. Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {“foo-namespace”: {“bar-key”: “value”}}

Returns:	The defined_tags of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	dict(str, dict(str, object))

description¶

Gets the description of this CreateDatabaseToolsMcpToolsetDetails. A human readable description of the Database Tools MCP toolset.

Returns:	The description of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	str

display_name¶

[Required] Gets the display_name of this CreateDatabaseToolsMcpToolsetDetails. A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.

Returns:	The display_name of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	str

freeform_tags¶

Gets the freeform_tags of this CreateDatabaseToolsMcpToolsetDetails. Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {“bar-key”: “value”}

Returns:	The freeform_tags of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	dict(str, str)

generative_ai_semantic_store_id¶

[Required] Gets the generative_ai_semantic_store_id of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails. The OCID of the related Generative AI Semantic Store.

Returns:	The generative_ai_semantic_store_id of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
Return type:	str

static get_subtype(object_dictionary)¶: Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

locks¶

Gets the locks of this CreateDatabaseToolsMcpToolsetDetails. Locks associated with this resource.

Returns:	The locks of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	list[oci.database_tools.models.ResourceLock]

tools¶

Gets the tools of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails. List of Database Tools GENAI_SQL_ASSISTANT toolset tool configurations

Returns:	The tools of this CreateDatabaseToolsMcpToolsetGenAiSqlAssistantDetails.
Return type:	list[oci.database_tools.models.CreateDatabaseToolsMcpToolsetToolDetails]

type¶

[Required] Gets the type of this CreateDatabaseToolsMcpToolsetDetails. The Database Tools MCP Toolset type.

Allowed values for this property are: “CUSTOM_SQL_TOOL”, “BUILT_IN_SQL_TOOLS”, “CUSTOMIZABLE_REPORTING_TOOLS”, “GENAI_SQL_ASSISTANT”

Returns:	The type of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	str

version¶

[Required] Gets the version of this CreateDatabaseToolsMcpToolsetDetails. The MCP toolset version

Returns:	The version of this CreateDatabaseToolsMcpToolsetDetails.
Return type:	int