1. Packages
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. DatabaseTools
  6. DatabaseToolsMcpToolset
Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi
oci logo
Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi

    This resource provides the Database Tools Mcp Toolset resource in Oracle Cloud Infrastructure Database Tools service. Api doc link for the resource: https://docs.oracle.com/iaas/api/#/en/database-tools/latest/DatabaseToolsMcpToolset

    Example terraform configs related to the resource : https://github.com/oracle/terraform-provider-oci/tree/master/examples/databaseTools

    Creates a new Database Tools MCP Toolset.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testDatabaseToolsMcpToolset = new oci.databasetools.DatabaseToolsMcpToolset("test_database_tools_mcp_toolset", {
        compartmentId: compartmentId,
        databaseToolsMcpServerId: testDatabaseToolsMcpServer.id,
        displayName: databaseToolsMcpToolsetDisplayName,
        type: databaseToolsMcpToolsetType,
        version: Number(databaseToolsMcpToolsetVersion),
        allowedRoles: databaseToolsMcpToolsetAllowedRoles,
        defaultExecutionType: databaseToolsMcpToolsetDefaultExecutionType,
        definedTags: {
            "foo-namespace.bar-key": "value",
        },
        description: databaseToolsMcpToolsetDescription,
        freeformTags: {
            "bar-key": "value",
        },
        generativeAiSemanticStoreId: testGenerativeAiSemanticStore.id,
        locks: [{
            type: databaseToolsMcpToolsetLocksType,
            message: databaseToolsMcpToolsetLocksMessage,
            relatedResourceId: testResource.id,
            timeCreated: databaseToolsMcpToolsetLocksTimeCreated,
        }],
        reports: [{
            allowedRoles: databaseToolsMcpToolsetReportsAllowedRoles,
            databaseToolsSqlReportId: testDatabaseToolsSqlReport.id,
        }],
        source: {
            type: databaseToolsMcpToolsetSourceType,
            value: databaseToolsMcpToolsetSourceValue,
        },
        toolDescription: databaseToolsMcpToolsetToolDescription,
        toolName: testTool.name,
        tools: [{
            allowedRoles: databaseToolsMcpToolsetToolsAllowedRoles,
            name: databaseToolsMcpToolsetToolsName,
            status: databaseToolsMcpToolsetToolsStatus,
        }],
        variables: [{
            description: databaseToolsMcpToolsetVariablesDescription,
            name: databaseToolsMcpToolsetVariablesName,
            type: databaseToolsMcpToolsetVariablesType,
        }],
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_database_tools_mcp_toolset = oci.databasetools.DatabaseToolsMcpToolset("test_database_tools_mcp_toolset",
        compartment_id=compartment_id,
        database_tools_mcp_server_id=test_database_tools_mcp_server["id"],
        display_name=database_tools_mcp_toolset_display_name,
        type=database_tools_mcp_toolset_type,
        version=int(database_tools_mcp_toolset_version),
        allowed_roles=database_tools_mcp_toolset_allowed_roles,
        default_execution_type=database_tools_mcp_toolset_default_execution_type,
        defined_tags={
            "foo-namespace.bar-key": "value",
        },
        description=database_tools_mcp_toolset_description,
        freeform_tags={
            "bar-key": "value",
        },
        generative_ai_semantic_store_id=test_generative_ai_semantic_store["id"],
        locks=[{
            "type": database_tools_mcp_toolset_locks_type,
            "message": database_tools_mcp_toolset_locks_message,
            "related_resource_id": test_resource["id"],
            "time_created": database_tools_mcp_toolset_locks_time_created,
        }],
        reports=[{
            "allowed_roles": database_tools_mcp_toolset_reports_allowed_roles,
            "database_tools_sql_report_id": test_database_tools_sql_report["id"],
        }],
        source={
            "type": database_tools_mcp_toolset_source_type,
            "value": database_tools_mcp_toolset_source_value,
        },
        tool_description=database_tools_mcp_toolset_tool_description,
        tool_name=test_tool["name"],
        tools=[{
            "allowed_roles": database_tools_mcp_toolset_tools_allowed_roles,
            "name": database_tools_mcp_toolset_tools_name,
            "status": database_tools_mcp_toolset_tools_status,
        }],
        variables=[{
            "description": database_tools_mcp_toolset_variables_description,
            "name": database_tools_mcp_toolset_variables_name,
            "type": database_tools_mcp_toolset_variables_type,
        }])
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/v4/go/oci/databasetools"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := databasetools.NewDatabaseToolsMcpToolset(ctx, "test_database_tools_mcp_toolset", &databasetools.DatabaseToolsMcpToolsetArgs{
    			CompartmentId:            pulumi.Any(compartmentId),
    			DatabaseToolsMcpServerId: pulumi.Any(testDatabaseToolsMcpServer.Id),
    			DisplayName:              pulumi.Any(databaseToolsMcpToolsetDisplayName),
    			Type:                     pulumi.Any(databaseToolsMcpToolsetType),
    			Version:                  pulumi.Any(databaseToolsMcpToolsetVersion),
    			AllowedRoles:             pulumi.Any(databaseToolsMcpToolsetAllowedRoles),
    			DefaultExecutionType:     pulumi.Any(databaseToolsMcpToolsetDefaultExecutionType),
    			DefinedTags: pulumi.StringMap{
    				"foo-namespace.bar-key": pulumi.String("value"),
    			},
    			Description: pulumi.Any(databaseToolsMcpToolsetDescription),
    			FreeformTags: pulumi.StringMap{
    				"bar-key": pulumi.String("value"),
    			},
    			GenerativeAiSemanticStoreId: pulumi.Any(testGenerativeAiSemanticStore.Id),
    			Locks: databasetools.DatabaseToolsMcpToolsetLockArray{
    				&databasetools.DatabaseToolsMcpToolsetLockArgs{
    					Type:              pulumi.Any(databaseToolsMcpToolsetLocksType),
    					Message:           pulumi.Any(databaseToolsMcpToolsetLocksMessage),
    					RelatedResourceId: pulumi.Any(testResource.Id),
    					TimeCreated:       pulumi.Any(databaseToolsMcpToolsetLocksTimeCreated),
    				},
    			},
    			Reports: databasetools.DatabaseToolsMcpToolsetReportArray{
    				&databasetools.DatabaseToolsMcpToolsetReportArgs{
    					AllowedRoles:             pulumi.Any(databaseToolsMcpToolsetReportsAllowedRoles),
    					DatabaseToolsSqlReportId: pulumi.Any(testDatabaseToolsSqlReport.Id),
    				},
    			},
    			Source: &databasetools.DatabaseToolsMcpToolsetSourceArgs{
    				Type:  pulumi.Any(databaseToolsMcpToolsetSourceType),
    				Value: pulumi.Any(databaseToolsMcpToolsetSourceValue),
    			},
    			ToolDescription: pulumi.Any(databaseToolsMcpToolsetToolDescription),
    			ToolName:        pulumi.Any(testTool.Name),
    			Tools: databasetools.DatabaseToolsMcpToolsetToolArray{
    				&databasetools.DatabaseToolsMcpToolsetToolArgs{
    					AllowedRoles: pulumi.Any(databaseToolsMcpToolsetToolsAllowedRoles),
    					Name:         pulumi.Any(databaseToolsMcpToolsetToolsName),
    					Status:       pulumi.Any(databaseToolsMcpToolsetToolsStatus),
    				},
    			},
    			Variables: databasetools.DatabaseToolsMcpToolsetVariableArray{
    				&databasetools.DatabaseToolsMcpToolsetVariableArgs{
    					Description: pulumi.Any(databaseToolsMcpToolsetVariablesDescription),
    					Name:        pulumi.Any(databaseToolsMcpToolsetVariablesName),
    					Type:        pulumi.Any(databaseToolsMcpToolsetVariablesType),
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testDatabaseToolsMcpToolset = new Oci.DatabaseTools.DatabaseToolsMcpToolset("test_database_tools_mcp_toolset", new()
        {
            CompartmentId = compartmentId,
            DatabaseToolsMcpServerId = testDatabaseToolsMcpServer.Id,
            DisplayName = databaseToolsMcpToolsetDisplayName,
            Type = databaseToolsMcpToolsetType,
            Version = databaseToolsMcpToolsetVersion,
            AllowedRoles = databaseToolsMcpToolsetAllowedRoles,
            DefaultExecutionType = databaseToolsMcpToolsetDefaultExecutionType,
            DefinedTags = 
            {
                { "foo-namespace.bar-key", "value" },
            },
            Description = databaseToolsMcpToolsetDescription,
            FreeformTags = 
            {
                { "bar-key", "value" },
            },
            GenerativeAiSemanticStoreId = testGenerativeAiSemanticStore.Id,
            Locks = new[]
            {
                new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetLockArgs
                {
                    Type = databaseToolsMcpToolsetLocksType,
                    Message = databaseToolsMcpToolsetLocksMessage,
                    RelatedResourceId = testResource.Id,
                    TimeCreated = databaseToolsMcpToolsetLocksTimeCreated,
                },
            },
            Reports = new[]
            {
                new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetReportArgs
                {
                    AllowedRoles = databaseToolsMcpToolsetReportsAllowedRoles,
                    DatabaseToolsSqlReportId = testDatabaseToolsSqlReport.Id,
                },
            },
            Source = new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetSourceArgs
            {
                Type = databaseToolsMcpToolsetSourceType,
                Value = databaseToolsMcpToolsetSourceValue,
            },
            ToolDescription = databaseToolsMcpToolsetToolDescription,
            ToolName = testTool.Name,
            Tools = new[]
            {
                new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetToolArgs
                {
                    AllowedRoles = databaseToolsMcpToolsetToolsAllowedRoles,
                    Name = databaseToolsMcpToolsetToolsName,
                    Status = databaseToolsMcpToolsetToolsStatus,
                },
            },
            Variables = new[]
            {
                new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetVariableArgs
                {
                    Description = databaseToolsMcpToolsetVariablesDescription,
                    Name = databaseToolsMcpToolsetVariablesName,
                    Type = databaseToolsMcpToolsetVariablesType,
                },
            },
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.oci.DatabaseTools.DatabaseToolsMcpToolset;
    import com.pulumi.oci.DatabaseTools.DatabaseToolsMcpToolsetArgs;
    import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsMcpToolsetLockArgs;
    import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsMcpToolsetReportArgs;
    import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsMcpToolsetSourceArgs;
    import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsMcpToolsetToolArgs;
    import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsMcpToolsetVariableArgs;
    import java.util.ArrayList;
    import java.util.Arrays;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var testDatabaseToolsMcpToolset = new DatabaseToolsMcpToolset("testDatabaseToolsMcpToolset", DatabaseToolsMcpToolsetArgs.builder()
                .compartmentId(compartmentId)
                .databaseToolsMcpServerId(testDatabaseToolsMcpServer.id())
                .displayName(databaseToolsMcpToolsetDisplayName)
                .type(databaseToolsMcpToolsetType)
                .version(databaseToolsMcpToolsetVersion)
                .allowedRoles(databaseToolsMcpToolsetAllowedRoles)
                .defaultExecutionType(databaseToolsMcpToolsetDefaultExecutionType)
                .definedTags(Map.of("foo-namespace.bar-key", "value"))
                .description(databaseToolsMcpToolsetDescription)
                .freeformTags(Map.of("bar-key", "value"))
                .generativeAiSemanticStoreId(testGenerativeAiSemanticStore.id())
                .locks(DatabaseToolsMcpToolsetLockArgs.builder()
                    .type(databaseToolsMcpToolsetLocksType)
                    .message(databaseToolsMcpToolsetLocksMessage)
                    .relatedResourceId(testResource.id())
                    .timeCreated(databaseToolsMcpToolsetLocksTimeCreated)
                    .build())
                .reports(DatabaseToolsMcpToolsetReportArgs.builder()
                    .allowedRoles(databaseToolsMcpToolsetReportsAllowedRoles)
                    .databaseToolsSqlReportId(testDatabaseToolsSqlReport.id())
                    .build())
                .source(DatabaseToolsMcpToolsetSourceArgs.builder()
                    .type(databaseToolsMcpToolsetSourceType)
                    .value(databaseToolsMcpToolsetSourceValue)
                    .build())
                .toolDescription(databaseToolsMcpToolsetToolDescription)
                .toolName(testTool.name())
                .tools(DatabaseToolsMcpToolsetToolArgs.builder()
                    .allowedRoles(databaseToolsMcpToolsetToolsAllowedRoles)
                    .name(databaseToolsMcpToolsetToolsName)
                    .status(databaseToolsMcpToolsetToolsStatus)
                    .build())
                .variables(DatabaseToolsMcpToolsetVariableArgs.builder()
                    .description(databaseToolsMcpToolsetVariablesDescription)
                    .name(databaseToolsMcpToolsetVariablesName)
                    .type(databaseToolsMcpToolsetVariablesType)
                    .build())
                .build());
    
        }
    }
    
    resources:
      testDatabaseToolsMcpToolset:
        type: oci:DatabaseTools:DatabaseToolsMcpToolset
        name: test_database_tools_mcp_toolset
        properties:
          compartmentId: ${compartmentId}
          databaseToolsMcpServerId: ${testDatabaseToolsMcpServer.id}
          displayName: ${databaseToolsMcpToolsetDisplayName}
          type: ${databaseToolsMcpToolsetType}
          version: ${databaseToolsMcpToolsetVersion}
          allowedRoles: ${databaseToolsMcpToolsetAllowedRoles}
          defaultExecutionType: ${databaseToolsMcpToolsetDefaultExecutionType}
          definedTags:
            foo-namespace.bar-key: value
          description: ${databaseToolsMcpToolsetDescription}
          freeformTags:
            bar-key: value
          generativeAiSemanticStoreId: ${testGenerativeAiSemanticStore.id}
          locks:
            - type: ${databaseToolsMcpToolsetLocksType}
              message: ${databaseToolsMcpToolsetLocksMessage}
              relatedResourceId: ${testResource.id}
              timeCreated: ${databaseToolsMcpToolsetLocksTimeCreated}
          reports:
            - allowedRoles: ${databaseToolsMcpToolsetReportsAllowedRoles}
              databaseToolsSqlReportId: ${testDatabaseToolsSqlReport.id}
          source:
            type: ${databaseToolsMcpToolsetSourceType}
            value: ${databaseToolsMcpToolsetSourceValue}
          toolDescription: ${databaseToolsMcpToolsetToolDescription}
          toolName: ${testTool.name}
          tools:
            - allowedRoles: ${databaseToolsMcpToolsetToolsAllowedRoles}
              name: ${databaseToolsMcpToolsetToolsName}
              status: ${databaseToolsMcpToolsetToolsStatus}
          variables:
            - description: ${databaseToolsMcpToolsetVariablesDescription}
              name: ${databaseToolsMcpToolsetVariablesName}
              type: ${databaseToolsMcpToolsetVariablesType}
    
    Example coming soon!
    

    Create DatabaseToolsMcpToolset Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new DatabaseToolsMcpToolset(name: string, args: DatabaseToolsMcpToolsetArgs, opts?: CustomResourceOptions);
    @overload
    def DatabaseToolsMcpToolset(resource_name: str,
                                args: DatabaseToolsMcpToolsetArgs,
                                opts: Optional[ResourceOptions] = None)
    
    @overload
    def DatabaseToolsMcpToolset(resource_name: str,
                                opts: Optional[ResourceOptions] = None,
                                display_name: Optional[str] = None,
                                compartment_id: Optional[str] = None,
                                database_tools_mcp_server_id: Optional[str] = None,
                                version: Optional[int] = None,
                                type: Optional[str] = None,
                                generative_ai_semantic_store_id: Optional[str] = None,
                                description: Optional[str] = None,
                                freeform_tags: Optional[Mapping[str, str]] = None,
                                allowed_roles: Optional[Sequence[str]] = None,
                                locks: Optional[Sequence[DatabaseToolsMcpToolsetLockArgs]] = None,
                                reports: Optional[Sequence[DatabaseToolsMcpToolsetReportArgs]] = None,
                                source: Optional[DatabaseToolsMcpToolsetSourceArgs] = None,
                                tool_description: Optional[str] = None,
                                tool_name: Optional[str] = None,
                                tools: Optional[Sequence[DatabaseToolsMcpToolsetToolArgs]] = None,
                                defined_tags: Optional[Mapping[str, str]] = None,
                                variables: Optional[Sequence[DatabaseToolsMcpToolsetVariableArgs]] = None,
                                default_execution_type: Optional[str] = None)
    func NewDatabaseToolsMcpToolset(ctx *Context, name string, args DatabaseToolsMcpToolsetArgs, opts ...ResourceOption) (*DatabaseToolsMcpToolset, error)
    public DatabaseToolsMcpToolset(string name, DatabaseToolsMcpToolsetArgs args, CustomResourceOptions? opts = null)
    public DatabaseToolsMcpToolset(String name, DatabaseToolsMcpToolsetArgs args)
    public DatabaseToolsMcpToolset(String name, DatabaseToolsMcpToolsetArgs args, CustomResourceOptions options)
    
    type: oci:DatabaseTools:DatabaseToolsMcpToolset
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    
    resource "oci_databasetools_databasetoolsmcptoolset" "name" {
        # resource properties
    }

    Parameters

    name string
    The unique name of the resource.
    args DatabaseToolsMcpToolsetArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args DatabaseToolsMcpToolsetArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args DatabaseToolsMcpToolsetArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabaseToolsMcpToolsetArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatabaseToolsMcpToolsetArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var databaseToolsMcpToolsetResource = new Oci.DatabaseTools.DatabaseToolsMcpToolset("databaseToolsMcpToolsetResource", new()
    {
        DisplayName = "string",
        CompartmentId = "string",
        DatabaseToolsMcpServerId = "string",
        Version = 0,
        Type = "string",
        GenerativeAiSemanticStoreId = "string",
        Description = "string",
        FreeformTags = 
        {
            { "string", "string" },
        },
        AllowedRoles = new[]
        {
            "string",
        },
        Locks = new[]
        {
            new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetLockArgs
            {
                Type = "string",
                Message = "string",
                RelatedResourceId = "string",
                TimeCreated = "string",
            },
        },
        Reports = new[]
        {
            new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetReportArgs
            {
                AllowedRoles = new[]
                {
                    "string",
                },
                DatabaseToolsSqlReportId = "string",
            },
        },
        Source = new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetSourceArgs
        {
            Type = "string",
            Value = "string",
        },
        ToolDescription = "string",
        ToolName = "string",
        Tools = new[]
        {
            new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetToolArgs
            {
                AllowedRoles = new[]
                {
                    "string",
                },
                DisplayName = "string",
                Name = "string",
                Status = "string",
            },
        },
        DefinedTags = 
        {
            { "string", "string" },
        },
        Variables = new[]
        {
            new Oci.DatabaseTools.Inputs.DatabaseToolsMcpToolsetVariableArgs
            {
                Description = "string",
                Name = "string",
                Type = "string",
            },
        },
        DefaultExecutionType = "string",
    });
    
    example, err := databasetools.NewDatabaseToolsMcpToolset(ctx, "databaseToolsMcpToolsetResource", &databasetools.DatabaseToolsMcpToolsetArgs{
    	DisplayName:                 pulumi.String("string"),
    	CompartmentId:               pulumi.String("string"),
    	DatabaseToolsMcpServerId:    pulumi.String("string"),
    	Version:                     pulumi.Int(0),
    	Type:                        pulumi.String("string"),
    	GenerativeAiSemanticStoreId: pulumi.String("string"),
    	Description:                 pulumi.String("string"),
    	FreeformTags: pulumi.StringMap{
    		"string": pulumi.String("string"),
    	},
    	AllowedRoles: pulumi.StringArray{
    		pulumi.String("string"),
    	},
    	Locks: databasetools.DatabaseToolsMcpToolsetLockArray{
    		&databasetools.DatabaseToolsMcpToolsetLockArgs{
    			Type:              pulumi.String("string"),
    			Message:           pulumi.String("string"),
    			RelatedResourceId: pulumi.String("string"),
    			TimeCreated:       pulumi.String("string"),
    		},
    	},
    	Reports: databasetools.DatabaseToolsMcpToolsetReportArray{
    		&databasetools.DatabaseToolsMcpToolsetReportArgs{
    			AllowedRoles: pulumi.StringArray{
    				pulumi.String("string"),
    			},
    			DatabaseToolsSqlReportId: pulumi.String("string"),
    		},
    	},
    	Source: &databasetools.DatabaseToolsMcpToolsetSourceArgs{
    		Type:  pulumi.String("string"),
    		Value: pulumi.String("string"),
    	},
    	ToolDescription: pulumi.String("string"),
    	ToolName:        pulumi.String("string"),
    	Tools: databasetools.DatabaseToolsMcpToolsetToolArray{
    		&databasetools.DatabaseToolsMcpToolsetToolArgs{
    			AllowedRoles: pulumi.StringArray{
    				pulumi.String("string"),
    			},
    			DisplayName: pulumi.String("string"),
    			Name:        pulumi.String("string"),
    			Status:      pulumi.String("string"),
    		},
    	},
    	DefinedTags: pulumi.StringMap{
    		"string": pulumi.String("string"),
    	},
    	Variables: databasetools.DatabaseToolsMcpToolsetVariableArray{
    		&databasetools.DatabaseToolsMcpToolsetVariableArgs{
    			Description: pulumi.String("string"),
    			Name:        pulumi.String("string"),
    			Type:        pulumi.String("string"),
    		},
    	},
    	DefaultExecutionType: pulumi.String("string"),
    })
    
    resource "oci_databasetools_databasetoolsmcptoolset" "databaseToolsMcpToolsetResource" {
      display_name                    = "string"
      compartment_id                  = "string"
      database_tools_mcp_server_id    = "string"
      version                         = 0
      type                            = "string"
      generative_ai_semantic_store_id = "string"
      description                     = "string"
      freeform_tags = {
        "string" = "string"
      }
      allowed_roles = ["string"]
      locks {
        type                = "string"
        message             = "string"
        related_resource_id = "string"
        time_created        = "string"
      }
      reports {
        allowed_roles                = ["string"]
        database_tools_sql_report_id = "string"
      }
      source = {
        type  = "string"
        value = "string"
      }
      tool_description = "string"
      tool_name        = "string"
      tools {
        allowed_roles = ["string"]
        display_name  = "string"
        name          = "string"
        status        = "string"
      }
      defined_tags = {
        "string" = "string"
      }
      variables {
        description = "string"
        name        = "string"
        type        = "string"
      }
      default_execution_type = "string"
    }
    
    var databaseToolsMcpToolsetResource = new DatabaseToolsMcpToolset("databaseToolsMcpToolsetResource", DatabaseToolsMcpToolsetArgs.builder()
        .displayName("string")
        .compartmentId("string")
        .databaseToolsMcpServerId("string")
        .version(0)
        .type("string")
        .generativeAiSemanticStoreId("string")
        .description("string")
        .freeformTags(Map.of("string", "string"))
        .allowedRoles("string")
        .locks(DatabaseToolsMcpToolsetLockArgs.builder()
            .type("string")
            .message("string")
            .relatedResourceId("string")
            .timeCreated("string")
            .build())
        .reports(DatabaseToolsMcpToolsetReportArgs.builder()
            .allowedRoles("string")
            .databaseToolsSqlReportId("string")
            .build())
        .source(DatabaseToolsMcpToolsetSourceArgs.builder()
            .type("string")
            .value("string")
            .build())
        .toolDescription("string")
        .toolName("string")
        .tools(DatabaseToolsMcpToolsetToolArgs.builder()
            .allowedRoles("string")
            .displayName("string")
            .name("string")
            .status("string")
            .build())
        .definedTags(Map.of("string", "string"))
        .variables(DatabaseToolsMcpToolsetVariableArgs.builder()
            .description("string")
            .name("string")
            .type("string")
            .build())
        .defaultExecutionType("string")
        .build());
    
    database_tools_mcp_toolset_resource = oci.databasetools.DatabaseToolsMcpToolset("databaseToolsMcpToolsetResource",
        display_name="string",
        compartment_id="string",
        database_tools_mcp_server_id="string",
        version=0,
        type="string",
        generative_ai_semantic_store_id="string",
        description="string",
        freeform_tags={
            "string": "string",
        },
        allowed_roles=["string"],
        locks=[{
            "type": "string",
            "message": "string",
            "related_resource_id": "string",
            "time_created": "string",
        }],
        reports=[{
            "allowed_roles": ["string"],
            "database_tools_sql_report_id": "string",
        }],
        source={
            "type": "string",
            "value": "string",
        },
        tool_description="string",
        tool_name="string",
        tools=[{
            "allowed_roles": ["string"],
            "display_name": "string",
            "name": "string",
            "status": "string",
        }],
        defined_tags={
            "string": "string",
        },
        variables=[{
            "description": "string",
            "name": "string",
            "type": "string",
        }],
        default_execution_type="string")
    
    const databaseToolsMcpToolsetResource = new oci.databasetools.DatabaseToolsMcpToolset("databaseToolsMcpToolsetResource", {
        displayName: "string",
        compartmentId: "string",
        databaseToolsMcpServerId: "string",
        version: 0,
        type: "string",
        generativeAiSemanticStoreId: "string",
        description: "string",
        freeformTags: {
            string: "string",
        },
        allowedRoles: ["string"],
        locks: [{
            type: "string",
            message: "string",
            relatedResourceId: "string",
            timeCreated: "string",
        }],
        reports: [{
            allowedRoles: ["string"],
            databaseToolsSqlReportId: "string",
        }],
        source: {
            type: "string",
            value: "string",
        },
        toolDescription: "string",
        toolName: "string",
        tools: [{
            allowedRoles: ["string"],
            displayName: "string",
            name: "string",
            status: "string",
        }],
        definedTags: {
            string: "string",
        },
        variables: [{
            description: "string",
            name: "string",
            type: "string",
        }],
        defaultExecutionType: "string",
    });
    
    type: oci:DatabaseTools:DatabaseToolsMcpToolset
    properties:
        allowedRoles:
            - string
        compartmentId: string
        databaseToolsMcpServerId: string
        defaultExecutionType: string
        definedTags:
            string: string
        description: string
        displayName: string
        freeformTags:
            string: string
        generativeAiSemanticStoreId: string
        locks:
            - message: string
              relatedResourceId: string
              timeCreated: string
              type: string
        reports:
            - allowedRoles:
                - string
              databaseToolsSqlReportId: string
        source:
            type: string
            value: string
        toolDescription: string
        toolName: string
        tools:
            - allowedRoles:
                - string
              displayName: string
              name: string
              status: string
        type: string
        variables:
            - description: string
              name: string
              type: string
        version: 0
    

    DatabaseToolsMcpToolset Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The DatabaseToolsMcpToolset resource accepts the following input properties:

    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    DatabaseToolsMcpServerId string
    The OCID of the Database Tools MCP Server
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Type string
    (Updatable) The Database Tools MCP Toolset type.
    Version int

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    AllowedRoles List<string>
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    DefaultExecutionType string

    (Updatable) 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.

    DefinedTags Dictionary<string, string>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    FreeformTags Dictionary<string, string>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    GenerativeAiSemanticStoreId string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    Locks List<DatabaseToolsMcpToolsetLock>
    Locks associated with this resource.
    Reports List<DatabaseToolsMcpToolsetReport>
    (Updatable) List of Database Tools SQL Reports
    Source DatabaseToolsMcpToolsetSource
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    ToolDescription string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    ToolName string
    (Updatable) Name of the tool returned by the MCP Server
    Tools List<DatabaseToolsMcpToolsetTool>
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    Variables List<DatabaseToolsMcpToolsetVariable>
    (Updatable) The variables to use with the query
    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    DatabaseToolsMcpServerId string
    The OCID of the Database Tools MCP Server
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Type string
    (Updatable) The Database Tools MCP Toolset type.
    Version int

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    AllowedRoles []string
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    DefaultExecutionType string

    (Updatable) 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.

    DefinedTags map[string]string
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    FreeformTags map[string]string
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    GenerativeAiSemanticStoreId string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    Locks []DatabaseToolsMcpToolsetLockArgs
    Locks associated with this resource.
    Reports []DatabaseToolsMcpToolsetReportArgs
    (Updatable) List of Database Tools SQL Reports
    Source DatabaseToolsMcpToolsetSourceArgs
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    ToolDescription string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    ToolName string
    (Updatable) Name of the tool returned by the MCP Server
    Tools []DatabaseToolsMcpToolsetToolArgs
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    Variables []DatabaseToolsMcpToolsetVariableArgs
    (Updatable) The variables to use with the query
    compartment_id string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    database_tools_mcp_server_id string
    The OCID of the Database Tools MCP Server
    display_name string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    type string
    (Updatable) The Database Tools MCP Toolset type.
    version number

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowed_roles list(string)
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    default_execution_type string

    (Updatable) 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.

    defined_tags map(string)
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    freeform_tags map(string)
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generative_ai_semantic_store_id string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    locks list(object)
    Locks associated with this resource.
    reports list(object)
    (Updatable) List of Database Tools SQL Reports
    source object
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    tool_description string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    tool_name string
    (Updatable) Name of the tool returned by the MCP Server
    tools list(object)
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    variables list(object)
    (Updatable) The variables to use with the query
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    databaseToolsMcpServerId String
    The OCID of the Database Tools MCP Server
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    type String
    (Updatable) The Database Tools MCP Toolset type.
    version Integer

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowedRoles List<String>
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    defaultExecutionType String

    (Updatable) 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.

    definedTags Map<String,String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A human readable description of the Database Tools MCP toolset.
    freeformTags Map<String,String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generativeAiSemanticStoreId String
    (Updatable) The OCID of the related Generative AI Semantic Store.
    locks List<McpToolsetLock>
    Locks associated with this resource.
    reports List<McpToolsetReport>
    (Updatable) List of Database Tools SQL Reports
    source McpToolsetSource
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    toolDescription String
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    toolName String
    (Updatable) Name of the tool returned by the MCP Server
    tools List<McpToolsetTool>
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    variables List<McpToolsetVariable>
    (Updatable) The variables to use with the query
    compartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    databaseToolsMcpServerId string
    The OCID of the Database Tools MCP Server
    displayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    type string
    (Updatable) The Database Tools MCP Toolset type.
    version number

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowedRoles string[]
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    defaultExecutionType string

    (Updatable) 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.

    definedTags {[key: string]: string}
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    freeformTags {[key: string]: string}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generativeAiSemanticStoreId string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    locks DatabaseToolsMcpToolsetLock[]
    Locks associated with this resource.
    reports DatabaseToolsMcpToolsetReport[]
    (Updatable) List of Database Tools SQL Reports
    source DatabaseToolsMcpToolsetSource
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    toolDescription string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    toolName string
    (Updatable) Name of the tool returned by the MCP Server
    tools DatabaseToolsMcpToolsetTool[]
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    variables DatabaseToolsMcpToolsetVariable[]
    (Updatable) The variables to use with the query
    compartment_id str
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    database_tools_mcp_server_id str
    The OCID of the Database Tools MCP Server
    display_name str
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    type str
    (Updatable) The Database Tools MCP Toolset type.
    version int

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowed_roles Sequence[str]
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    default_execution_type str

    (Updatable) 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.

    defined_tags Mapping[str, str]
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    (Updatable) A human readable description of the Database Tools MCP toolset.
    freeform_tags Mapping[str, str]
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generative_ai_semantic_store_id str
    (Updatable) The OCID of the related Generative AI Semantic Store.
    locks Sequence[DatabaseToolsMcpToolsetLockArgs]
    Locks associated with this resource.
    reports Sequence[DatabaseToolsMcpToolsetReportArgs]
    (Updatable) List of Database Tools SQL Reports
    source DatabaseToolsMcpToolsetSourceArgs
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    tool_description str
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    tool_name str
    (Updatable) Name of the tool returned by the MCP Server
    tools Sequence[DatabaseToolsMcpToolsetToolArgs]
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    variables Sequence[DatabaseToolsMcpToolsetVariableArgs]
    (Updatable) The variables to use with the query
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    databaseToolsMcpServerId String
    The OCID of the Database Tools MCP Server
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    type String
    (Updatable) The Database Tools MCP Toolset type.
    version Number

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowedRoles List<String>
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    defaultExecutionType String

    (Updatable) 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.

    definedTags Map<String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A human readable description of the Database Tools MCP toolset.
    freeformTags Map<String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generativeAiSemanticStoreId String
    (Updatable) The OCID of the related Generative AI Semantic Store.
    locks List<Property Map>
    Locks associated with this resource.
    reports List<Property Map>
    (Updatable) List of Database Tools SQL Reports
    source Property Map
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    toolDescription String
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    toolName String
    (Updatable) Name of the tool returned by the MCP Server
    tools List<Property Map>
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    variables List<Property Map>
    (Updatable) The variables to use with the query

    Outputs

    All input properties are implicitly available as output properties. Additionally, the DatabaseToolsMcpToolset resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    LifecycleDetails string
    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.
    State string
    The current state of the Database Tools MCP Toolset.
    SystemTags Dictionary<string, string>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    Id string
    The provider-assigned unique ID for this managed resource.
    LifecycleDetails string
    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.
    State string
    The current state of the Database Tools MCP Toolset.
    SystemTags map[string]string
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    id string
    The provider-assigned unique ID for this managed resource.
    lifecycle_details string
    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.
    state string
    The current state of the Database Tools MCP Toolset.
    system_tags map(string)
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    time_updated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    id String
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails String
    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.
    state String
    The current state of the Database Tools MCP Toolset.
    systemTags Map<String,String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    id string
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails string
    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.
    state string
    The current state of the Database Tools MCP Toolset.
    systemTags {[key: string]: string}
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    timeUpdated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    id str
    The provider-assigned unique ID for this managed resource.
    lifecycle_details str
    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.
    state str
    The current state of the Database Tools MCP Toolset.
    system_tags Mapping[str, str]
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created str
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    time_updated str
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    id String
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails String
    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.
    state String
    The current state of the Database Tools MCP Toolset.
    systemTags Map<String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.

    Look up Existing DatabaseToolsMcpToolset Resource

    Get an existing DatabaseToolsMcpToolset resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: DatabaseToolsMcpToolsetState, opts?: CustomResourceOptions): DatabaseToolsMcpToolset
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            allowed_roles: Optional[Sequence[str]] = None,
            compartment_id: Optional[str] = None,
            database_tools_mcp_server_id: Optional[str] = None,
            default_execution_type: Optional[str] = None,
            defined_tags: Optional[Mapping[str, str]] = None,
            description: Optional[str] = None,
            display_name: Optional[str] = None,
            freeform_tags: Optional[Mapping[str, str]] = None,
            generative_ai_semantic_store_id: Optional[str] = None,
            lifecycle_details: Optional[str] = None,
            locks: Optional[Sequence[DatabaseToolsMcpToolsetLockArgs]] = None,
            reports: Optional[Sequence[DatabaseToolsMcpToolsetReportArgs]] = None,
            source: Optional[DatabaseToolsMcpToolsetSourceArgs] = None,
            state: Optional[str] = None,
            system_tags: Optional[Mapping[str, str]] = None,
            time_created: Optional[str] = None,
            time_updated: Optional[str] = None,
            tool_description: Optional[str] = None,
            tool_name: Optional[str] = None,
            tools: Optional[Sequence[DatabaseToolsMcpToolsetToolArgs]] = None,
            type: Optional[str] = None,
            variables: Optional[Sequence[DatabaseToolsMcpToolsetVariableArgs]] = None,
            version: Optional[int] = None) -> DatabaseToolsMcpToolset
    func GetDatabaseToolsMcpToolset(ctx *Context, name string, id IDInput, state *DatabaseToolsMcpToolsetState, opts ...ResourceOption) (*DatabaseToolsMcpToolset, error)
    public static DatabaseToolsMcpToolset Get(string name, Input<string> id, DatabaseToolsMcpToolsetState? state, CustomResourceOptions? opts = null)
    public static DatabaseToolsMcpToolset get(String name, Output<String> id, DatabaseToolsMcpToolsetState state, CustomResourceOptions options)
    resources:  _:    type: oci:DatabaseTools:DatabaseToolsMcpToolset    get:      id: ${id}
    import {
      to = oci_databasetools_databasetoolsmcptoolset.example
      id = "${id}"
    }
    
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AllowedRoles List<string>
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    DatabaseToolsMcpServerId string
    The OCID of the Database Tools MCP Server
    DefaultExecutionType string

    (Updatable) 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.

    DefinedTags Dictionary<string, string>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    FreeformTags Dictionary<string, string>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    GenerativeAiSemanticStoreId string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    LifecycleDetails string
    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 List<DatabaseToolsMcpToolsetLock>
    Locks associated with this resource.
    Reports List<DatabaseToolsMcpToolsetReport>
    (Updatable) List of Database Tools SQL Reports
    Source DatabaseToolsMcpToolsetSource
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    State string
    The current state of the Database Tools MCP Toolset.
    SystemTags Dictionary<string, string>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    ToolDescription string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    ToolName string
    (Updatable) Name of the tool returned by the MCP Server
    Tools List<DatabaseToolsMcpToolsetTool>
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    Type string
    (Updatable) The Database Tools MCP Toolset type.
    Variables List<DatabaseToolsMcpToolsetVariable>
    (Updatable) The variables to use with the query
    Version int

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    AllowedRoles []string
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    DatabaseToolsMcpServerId string
    The OCID of the Database Tools MCP Server
    DefaultExecutionType string

    (Updatable) 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.

    DefinedTags map[string]string
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    FreeformTags map[string]string
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    GenerativeAiSemanticStoreId string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    LifecycleDetails string
    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 []DatabaseToolsMcpToolsetLockArgs
    Locks associated with this resource.
    Reports []DatabaseToolsMcpToolsetReportArgs
    (Updatable) List of Database Tools SQL Reports
    Source DatabaseToolsMcpToolsetSourceArgs
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    State string
    The current state of the Database Tools MCP Toolset.
    SystemTags map[string]string
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    ToolDescription string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    ToolName string
    (Updatable) Name of the tool returned by the MCP Server
    Tools []DatabaseToolsMcpToolsetToolArgs
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    Type string
    (Updatable) The Database Tools MCP Toolset type.
    Variables []DatabaseToolsMcpToolsetVariableArgs
    (Updatable) The variables to use with the query
    Version int

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowed_roles list(string)
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    compartment_id string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    database_tools_mcp_server_id string
    The OCID of the Database Tools MCP Server
    default_execution_type string

    (Updatable) 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.

    defined_tags map(string)
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    display_name string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeform_tags map(string)
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generative_ai_semantic_store_id string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    lifecycle_details string
    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 list(object)
    Locks associated with this resource.
    reports list(object)
    (Updatable) List of Database Tools SQL Reports
    source object
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state string
    The current state of the Database Tools MCP Toolset.
    system_tags map(string)
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    time_updated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    tool_description string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    tool_name string
    (Updatable) Name of the tool returned by the MCP Server
    tools list(object)
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    type string
    (Updatable) The Database Tools MCP Toolset type.
    variables list(object)
    (Updatable) The variables to use with the query
    version number

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowedRoles List<String>
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    databaseToolsMcpServerId String
    The OCID of the Database Tools MCP Server
    defaultExecutionType String

    (Updatable) 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.

    definedTags Map<String,String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A human readable description of the Database Tools MCP toolset.
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags Map<String,String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generativeAiSemanticStoreId String
    (Updatable) The OCID of the related Generative AI Semantic Store.
    lifecycleDetails String
    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 List<McpToolsetLock>
    Locks associated with this resource.
    reports List<McpToolsetReport>
    (Updatable) List of Database Tools SQL Reports
    source McpToolsetSource
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state String
    The current state of the Database Tools MCP Toolset.
    systemTags Map<String,String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    toolDescription String
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    toolName String
    (Updatable) Name of the tool returned by the MCP Server
    tools List<McpToolsetTool>
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    type String
    (Updatable) The Database Tools MCP Toolset type.
    variables List<McpToolsetVariable>
    (Updatable) The variables to use with the query
    version Integer

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowedRoles string[]
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    compartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    databaseToolsMcpServerId string
    The OCID of the Database Tools MCP Server
    defaultExecutionType string

    (Updatable) 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.

    definedTags {[key: string]: string}
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A human readable description of the Database Tools MCP toolset.
    displayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags {[key: string]: string}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generativeAiSemanticStoreId string
    (Updatable) The OCID of the related Generative AI Semantic Store.
    lifecycleDetails string
    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 DatabaseToolsMcpToolsetLock[]
    Locks associated with this resource.
    reports DatabaseToolsMcpToolsetReport[]
    (Updatable) List of Database Tools SQL Reports
    source DatabaseToolsMcpToolsetSource
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state string
    The current state of the Database Tools MCP Toolset.
    systemTags {[key: string]: string}
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated string
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    timeUpdated string
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    toolDescription string
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    toolName string
    (Updatable) Name of the tool returned by the MCP Server
    tools DatabaseToolsMcpToolsetTool[]
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    type string
    (Updatable) The Database Tools MCP Toolset type.
    variables DatabaseToolsMcpToolsetVariable[]
    (Updatable) The variables to use with the query
    version number

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowed_roles Sequence[str]
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    compartment_id str
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    database_tools_mcp_server_id str
    The OCID of the Database Tools MCP Server
    default_execution_type str

    (Updatable) 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.

    defined_tags Mapping[str, str]
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    (Updatable) A human readable description of the Database Tools MCP toolset.
    display_name str
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeform_tags Mapping[str, str]
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generative_ai_semantic_store_id str
    (Updatable) The OCID of the related Generative AI Semantic Store.
    lifecycle_details str
    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 Sequence[DatabaseToolsMcpToolsetLockArgs]
    Locks associated with this resource.
    reports Sequence[DatabaseToolsMcpToolsetReportArgs]
    (Updatable) List of Database Tools SQL Reports
    source DatabaseToolsMcpToolsetSourceArgs
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state str
    The current state of the Database Tools MCP Toolset.
    system_tags Mapping[str, str]
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created str
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    time_updated str
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    tool_description str
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    tool_name str
    (Updatable) Name of the tool returned by the MCP Server
    tools Sequence[DatabaseToolsMcpToolsetToolArgs]
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    type str
    (Updatable) The Database Tools MCP Toolset type.
    variables Sequence[DatabaseToolsMcpToolsetVariableArgs]
    (Updatable) The variables to use with the query
    version int

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    allowedRoles List<String>
    (Updatable) The roles granted access to the MCP tool generated by this toolset
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools MCP server.
    databaseToolsMcpServerId String
    The OCID of the Database Tools MCP Server
    defaultExecutionType String

    (Updatable) 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.

    definedTags Map<String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A human readable description of the Database Tools MCP toolset.
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags Map<String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    generativeAiSemanticStoreId String
    (Updatable) The OCID of the related Generative AI Semantic Store.
    lifecycleDetails String
    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 List<Property Map>
    Locks associated with this resource.
    reports List<Property Map>
    (Updatable) List of Database Tools SQL Reports
    source Property Map
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state String
    The current state of the Database Tools MCP Toolset.
    systemTags Map<String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools MCP server was updated. An RFC3339 formatted datetime string.
    toolDescription String
    (Updatable) Instructions describing how to use the MCP toolset and its features. This can be used to improve the LLM's understanding of the tool.
    toolName String
    (Updatable) Name of the tool returned by the MCP Server
    tools List<Property Map>
    (Updatable) List of Database Tools CUSTOMIZABLE_REPORTING_TOOLS toolset tool configurations
    type String
    (Updatable) The Database Tools MCP Toolset type.
    variables List<Property Map>
    (Updatable) The variables to use with the query
    version Number

    (Updatable) The MCP toolset version

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Supporting Types

    DatabaseToolsMcpToolsetLock, DatabaseToolsMcpToolsetLockArgs

    Type string
    Type of the lock.
    Message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    RelatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    TimeCreated string
    When the lock was created.
    Type string
    Type of the lock.
    Message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    RelatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    TimeCreated string
    When the lock was created.
    type string
    Type of the lock.
    message string
    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 string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    time_created string
    When the lock was created.
    type String
    Type of the lock.
    message String
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId String
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated String
    When the lock was created.
    type string
    Type of the lock.
    message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated string
    When the lock was created.
    type str
    Type of the lock.
    message str
    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 str
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    time_created str
    When the lock was created.
    type String
    Type of the lock.
    message String
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId String
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated String
    When the lock was created.

    DatabaseToolsMcpToolsetReport, DatabaseToolsMcpToolsetReportArgs

    AllowedRoles List<string>
    (Updatable) The roles granted access to this report
    DatabaseToolsSqlReportId string
    (Updatable) The OCID of the report OCID of sql report.
    AllowedRoles []string
    (Updatable) The roles granted access to this report
    DatabaseToolsSqlReportId string
    (Updatable) The OCID of the report OCID of sql report.
    allowed_roles list(string)
    (Updatable) The roles granted access to this report
    database_tools_sql_report_id string
    (Updatable) The OCID of the report OCID of sql report.
    allowedRoles List<String>
    (Updatable) The roles granted access to this report
    databaseToolsSqlReportId String
    (Updatable) The OCID of the report OCID of sql report.
    allowedRoles string[]
    (Updatable) The roles granted access to this report
    databaseToolsSqlReportId string
    (Updatable) The OCID of the report OCID of sql report.
    allowed_roles Sequence[str]
    (Updatable) The roles granted access to this report
    database_tools_sql_report_id str
    (Updatable) The OCID of the report OCID of sql report.
    allowedRoles List<String>
    (Updatable) The roles granted access to this report
    databaseToolsSqlReportId String
    (Updatable) The OCID of the report OCID of sql report.

    DatabaseToolsMcpToolsetSource, DatabaseToolsMcpToolsetSourceArgs

    Type string
    (Updatable) The sql toolset sources type. INLINE is the only possible value.
    Value string
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    Type string
    (Updatable) The sql toolset sources type. INLINE is the only possible value.
    Value string
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type string
    (Updatable) The sql toolset sources type. INLINE is the only possible value.
    value string
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type String
    (Updatable) The sql toolset sources type. INLINE is the only possible value.
    value String
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type string
    (Updatable) The sql toolset sources type. INLINE is the only possible value.
    value string
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type str
    (Updatable) The sql toolset sources type. INLINE is the only possible value.
    value str
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type String
    (Updatable) The sql toolset sources type. INLINE is the only possible value.
    value String
    (Updatable) The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.

    DatabaseToolsMcpToolsetTool, DatabaseToolsMcpToolsetToolArgs

    AllowedRoles List<string>
    (Updatable) The roles granted access to this tool
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Name string
    (Updatable) The name of the tool
    Status string
    (Updatable) The status of the tool
    AllowedRoles []string
    (Updatable) The roles granted access to this tool
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Name string
    (Updatable) The name of the tool
    Status string
    (Updatable) The status of the tool
    allowed_roles list(string)
    (Updatable) The roles granted access to this tool
    display_name string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    name string
    (Updatable) The name of the tool
    status string
    (Updatable) The status of the tool
    allowedRoles List<String>
    (Updatable) The roles granted access to this tool
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    name String
    (Updatable) The name of the tool
    status String
    (Updatable) The status of the tool
    allowedRoles string[]
    (Updatable) The roles granted access to this tool
    displayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    name string
    (Updatable) The name of the tool
    status string
    (Updatable) The status of the tool
    allowed_roles Sequence[str]
    (Updatable) The roles granted access to this tool
    display_name str
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    name str
    (Updatable) The name of the tool
    status str
    (Updatable) The status of the tool
    allowedRoles List<String>
    (Updatable) The roles granted access to this tool
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    name String
    (Updatable) The name of the tool
    status String
    (Updatable) The status of the tool

    DatabaseToolsMcpToolsetVariable, DatabaseToolsMcpToolsetVariableArgs

    Description string
    (Updatable) The description of the variable
    Name string
    (Updatable) The name of the variable
    Type string
    (Updatable) The type of the variable
    Description string
    (Updatable) The description of the variable
    Name string
    (Updatable) The name of the variable
    Type string
    (Updatable) The type of the variable
    description string
    (Updatable) The description of the variable
    name string
    (Updatable) The name of the variable
    type string
    (Updatable) The type of the variable
    description String
    (Updatable) The description of the variable
    name String
    (Updatable) The name of the variable
    type String
    (Updatable) The type of the variable
    description string
    (Updatable) The description of the variable
    name string
    (Updatable) The name of the variable
    type string
    (Updatable) The type of the variable
    description str
    (Updatable) The description of the variable
    name str
    (Updatable) The name of the variable
    type str
    (Updatable) The type of the variable
    description String
    (Updatable) The description of the variable
    name String
    (Updatable) The name of the variable
    type String
    (Updatable) The type of the variable

    Import

    DatabaseToolsMcpToolsets can be imported using the id, e.g.

    $ pulumi import oci:DatabaseTools/databaseToolsMcpToolset:DatabaseToolsMcpToolset test_database_tools_mcp_toolset "id"
    

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Viewing docs for Oracle Cloud Infrastructure v4.12.0
    published on Thursday, May 21, 2026 by Pulumi

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial