CreateDatabaseToolsMcpToolsetCustomSqlToolDetails

class oci.database_tools.models.CreateDatabaseToolsMcpToolsetCustomSqlToolDetails(**kwargs)

Bases: CreateDatabaseToolsMcpToolsetDetails

Details for the new Database Tools MCP Toolset.

Attributes:

DEFAULT_EXECUTION_TYPE_ASYNCHRONOUS	A constant which can be used with the default_execution_type property of a CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
DEFAULT_EXECUTION_TYPE_SYNCHRONOUS	A constant which can be used with the default_execution_type property of a CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
TYPE_BUILT_IN_SQL_TOOLS	A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails.
TYPE_CUSTOMIZABLE_REPORTING_TOOLS	A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails.
TYPE_CUSTOM_SQL_TOOL	A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails.
TYPE_GENAI_SQL_ASSISTANT	A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails.
allowed_roles	Gets the allowed_roles of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
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 CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
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.
locks	Gets the locks of this CreateDatabaseToolsMcpToolsetDetails.
source	[Required] Gets the source of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
tool_description	Gets the tool_description of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
tool_name	[Required] Gets the tool_name of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
type	[Required] Gets the type of this CreateDatabaseToolsMcpToolsetDetails.
variables	Gets the variables of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.
version	[Required] Gets the version of this CreateDatabaseToolsMcpToolsetDetails.

Methods:

__init__(**kwargs)	Initializes a new CreateDatabaseToolsMcpToolsetCustomSqlToolDetails 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 CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. 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 CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. This constant has a value of “SYNCHRONOUS”

TYPE_BUILT_IN_SQL_TOOLS = 'BUILT_IN_SQL_TOOLS'

A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails. This constant has a value of “BUILT_IN_SQL_TOOLS”

TYPE_CUSTOMIZABLE_REPORTING_TOOLS = 'CUSTOMIZABLE_REPORTING_TOOLS'

A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails. This constant has a value of “CUSTOMIZABLE_REPORTING_TOOLS”

TYPE_CUSTOM_SQL_TOOL = 'CUSTOM_SQL_TOOL'

A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails. This constant has a value of “CUSTOM_SQL_TOOL”

TYPE_GENAI_SQL_ASSISTANT = 'GENAI_SQL_ASSISTANT'

A constant which can be used with the type property of a CreateDatabaseToolsMcpToolsetDetails. This constant has a value of “GENAI_SQL_ASSISTANT”

__init__(**kwargs)

Initializes a new CreateDatabaseToolsMcpToolsetCustomSqlToolDetails object with values from keyword arguments. The default value of the type attribute of this class is CUSTOM_SQL_TOOL 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 CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• compartment_id (str) – The value to assign to the compartment_id property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• display_name (str) – The value to assign to the display_name property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• database_tools_mcp_server_id (str) – The value to assign to the database_tools_mcp_server_id property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• description (str) – The value to assign to the description property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• type (str) – The value to assign to the type property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. 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 CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• locks (list[oci.database_tools.models.ResourceLock]) – The value to assign to the locks property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• tool_description (str) – The value to assign to the tool_description property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• tool_name (str) – The value to assign to the tool_name property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• source (oci.database_tools.models.DatabaseToolsCustomSqlToolToolsetSource) – The value to assign to the source property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• variables (list[oci.database_tools.models.DatabaseToolsMcpToolsetCustomSqlToolVariable]) – The value to assign to the variables property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• allowed_roles (list[str]) – The value to assign to the allowed_roles property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

• default_execution_type (str) – The value to assign to the default_execution_type property of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. Allowed values for this property are: “SYNCHRONOUS”, “ASYNCHRONOUS”

property allowed_roles

Gets the allowed_roles of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. The roles granted access to the MCP tool generated by this toolset

Returns

The allowed_roles of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

Return type

list[str]

property 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

property 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

property default_execution_type

Gets the default_execution_type of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. 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 CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

Return type

str

property 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))

property 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

property 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

property 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)

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.

property 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]

property source

[Required] Gets the source of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

Returns

The source of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

Return type

oci.database_tools.models.DatabaseToolsCustomSqlToolToolsetSource

property tool_description

Gets the tool_description of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM’s understanding of the tool.

Returns

The tool_description of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

Return type

str

property tool_name

[Required] Gets the tool_name of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. Name of the tool returned by the MCP Server

Returns

The tool_name of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

Return type

str

property 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

property variables

Gets the variables of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails. The variables to use with the query

Returns

The variables of this CreateDatabaseToolsMcpToolsetCustomSqlToolDetails.

Return type

list[oci.database_tools.models.DatabaseToolsMcpToolsetCustomSqlToolVariable]

property version

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

Returns

The version of this CreateDatabaseToolsMcpToolsetDetails.

Return type

int