Sign in Dashboard Get started
  1. Packages
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. DatabaseTools
  6. getDatabaseToolsMcpToolsets
Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.DatabaseTools.getDatabaseToolsMcpToolsets

oci logo
Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

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

    Returns a list of Database Tools Toolsets.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDatabaseToolsMcpToolsets = oci.databasetools.getDatabaseToolsMcpToolsets({
    compartmentId: compartmentId,
    databaseToolsMcpServerId: testDatabaseToolsMcpServer.id,
    displayName: databaseToolsMcpToolsetDisplayName,
    state: databaseToolsMcpToolsetState,
    types: databaseToolsMcpToolsetType,
});

    import pulumi
import pulumi_oci as oci

test_database_tools_mcp_toolsets = oci.databasetools.get_database_tools_mcp_toolsets(compartment_id=compartment_id,
    database_tools_mcp_server_id=test_database_tools_mcp_server["id"],
    display_name=database_tools_mcp_toolset_display_name,
    state=database_tools_mcp_toolset_state,
    types=database_tools_mcp_toolset_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.GetDatabaseToolsMcpToolsets(ctx, &databasetools.GetDatabaseToolsMcpToolsetsArgs{
			CompartmentId:            compartmentId,
			DatabaseToolsMcpServerId: pulumi.StringRef(testDatabaseToolsMcpServer.Id),
			DisplayName:              pulumi.StringRef(databaseToolsMcpToolsetDisplayName),
			State:                    pulumi.StringRef(databaseToolsMcpToolsetState),
			Types:                    pulumi.ToArray(databaseToolsMcpToolsetType),
		}, nil)
		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 testDatabaseToolsMcpToolsets = Oci.DatabaseTools.GetDatabaseToolsMcpToolsets.Invoke(new()
    {
        CompartmentId = compartmentId,
        DatabaseToolsMcpServerId = testDatabaseToolsMcpServer.Id,
        DisplayName = databaseToolsMcpToolsetDisplayName,
        State = databaseToolsMcpToolsetState,
        Types = databaseToolsMcpToolsetType,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseTools.DatabaseToolsFunctions;
import com.pulumi.oci.DatabaseTools.inputs.GetDatabaseToolsMcpToolsetsArgs;
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) {
        final var testDatabaseToolsMcpToolsets = DatabaseToolsFunctions.getDatabaseToolsMcpToolsets(GetDatabaseToolsMcpToolsetsArgs.builder()
            .compartmentId(compartmentId)
            .databaseToolsMcpServerId(testDatabaseToolsMcpServer.id())
            .displayName(databaseToolsMcpToolsetDisplayName)
            .state(databaseToolsMcpToolsetState)
            .types(databaseToolsMcpToolsetType)
            .build());

    }
}

    variables:
  testDatabaseToolsMcpToolsets:
    fn::invoke:
      function: oci:DatabaseTools:getDatabaseToolsMcpToolsets
      arguments:
        compartmentId: ${compartmentId}
        databaseToolsMcpServerId: ${testDatabaseToolsMcpServer.id}
        displayName: ${databaseToolsMcpToolsetDisplayName}
        state: ${databaseToolsMcpToolsetState}
        types: ${databaseToolsMcpToolsetType}

    Example coming soon!

    Using getDatabaseToolsMcpToolsets

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getDatabaseToolsMcpToolsets(args: GetDatabaseToolsMcpToolsetsArgs, opts?: InvokeOptions): Promise<GetDatabaseToolsMcpToolsetsResult>
function getDatabaseToolsMcpToolsetsOutput(args: GetDatabaseToolsMcpToolsetsOutputArgs, opts?: InvokeOptions): Output<GetDatabaseToolsMcpToolsetsResult>
    def get_database_tools_mcp_toolsets(compartment_id: Optional[str] = None,
                                    database_tools_mcp_server_id: Optional[str] = None,
                                    display_name: Optional[str] = None,
                                    filters: Optional[Sequence[GetDatabaseToolsMcpToolsetsFilter]] = None,
                                    state: Optional[str] = None,
                                    types: Optional[Sequence[str]] = None,
                                    opts: Optional[InvokeOptions] = None) -> GetDatabaseToolsMcpToolsetsResult
def get_database_tools_mcp_toolsets_output(compartment_id: pulumi.Input[Optional[str]] = None,
                                    database_tools_mcp_server_id: pulumi.Input[Optional[str]] = None,
                                    display_name: pulumi.Input[Optional[str]] = None,
                                    filters: pulumi.Input[Optional[Sequence[pulumi.Input[GetDatabaseToolsMcpToolsetsFilterArgs]]]] = None,
                                    state: pulumi.Input[Optional[str]] = None,
                                    types: pulumi.Input[Optional[Sequence[pulumi.Input[str]]]] = None,
                                    opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseToolsMcpToolsetsResult]
    func GetDatabaseToolsMcpToolsets(ctx *Context, args *GetDatabaseToolsMcpToolsetsArgs, opts ...InvokeOption) (*GetDatabaseToolsMcpToolsetsResult, error)
func GetDatabaseToolsMcpToolsetsOutput(ctx *Context, args *GetDatabaseToolsMcpToolsetsOutputArgs, opts ...InvokeOption) GetDatabaseToolsMcpToolsetsResultOutput

    > Note: This function is named GetDatabaseToolsMcpToolsets in the Go SDK.

    public static class GetDatabaseToolsMcpToolsets 
{
    public static Task<GetDatabaseToolsMcpToolsetsResult> InvokeAsync(GetDatabaseToolsMcpToolsetsArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseToolsMcpToolsetsResult> Invoke(GetDatabaseToolsMcpToolsetsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDatabaseToolsMcpToolsetsResult> getDatabaseToolsMcpToolsets(GetDatabaseToolsMcpToolsetsArgs args, InvokeOptions options)
public static Output<GetDatabaseToolsMcpToolsetsResult> getDatabaseToolsMcpToolsets(GetDatabaseToolsMcpToolsetsArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseTools/getDatabaseToolsMcpToolsets:getDatabaseToolsMcpToolsets
  arguments:
    # arguments dictionary
    data "oci_databasetools_getdatabasetoolsmcptoolsets" "name" {
    # arguments
}

    The following arguments are supported:

    CompartmentId string
    The OCID of the compartment in which to list resources.
    DatabaseToolsMcpServerId string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    Filters List<GetDatabaseToolsMcpToolsetsFilter>
    State string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    Types List<string>
    A filter to return only resources with one of the specified type values.
    CompartmentId string
    The OCID of the compartment in which to list resources.
    DatabaseToolsMcpServerId string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    Filters []GetDatabaseToolsMcpToolsetsFilter
    State string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    Types []string
    A filter to return only resources with one of the specified type values.
    compartment_id string
    The OCID of the compartment in which to list resources.
    database_tools_mcp_server_id string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    display_name string
    A filter to return only resources that match the entire specified display name.
    filters list(object)
    state string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    types list(string)
    A filter to return only resources with one of the specified type values.
    compartmentId String
    The OCID of the compartment in which to list resources.
    databaseToolsMcpServerId String
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    displayName String
    A filter to return only resources that match the entire specified display name.
    filters List<GetMcpToolsetsFilter>
    state String
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    types List<String>
    A filter to return only resources with one of the specified type values.
    compartmentId string
    The OCID of the compartment in which to list resources.
    databaseToolsMcpServerId string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    displayName string
    A filter to return only resources that match the entire specified display name.
    filters GetDatabaseToolsMcpToolsetsFilter[]
    state string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    types string[]
    A filter to return only resources with one of the specified type values.
    compartment_id str
    The OCID of the compartment in which to list resources.
    database_tools_mcp_server_id str
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    display_name str
    A filter to return only resources that match the entire specified display name.
    filters Sequence[GetDatabaseToolsMcpToolsetsFilter]
    state str
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    types Sequence[str]
    A filter to return only resources with one of the specified type values.
    compartmentId String
    The OCID of the compartment in which to list resources.
    databaseToolsMcpServerId String
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    displayName String
    A filter to return only resources that match the entire specified display name.
    filters List<Property Map>
    state String
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    types List<String>
    A filter to return only resources with one of the specified type values.

    getDatabaseToolsMcpToolsets Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment to move the Database Tools MCP Toolset to.
    DatabaseToolsMcpToolsetCollections List<GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollection>
    The list of database_tools_mcp_toolset_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    DatabaseToolsMcpServerId string
    The OCID of the related Database Tools McpServer.
    DisplayName string
    The display name of the tool
    Filters List<GetDatabaseToolsMcpToolsetsFilter>
    State string
    The current state of the Database Tools MCP Toolset.
    Types List<string>
    The type of the variable
    CompartmentId string
    The OCID of the compartment to move the Database Tools MCP Toolset to.
    DatabaseToolsMcpToolsetCollections []GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollection
    The list of database_tools_mcp_toolset_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    DatabaseToolsMcpServerId string
    The OCID of the related Database Tools McpServer.
    DisplayName string
    The display name of the tool
    Filters []GetDatabaseToolsMcpToolsetsFilter
    State string
    The current state of the Database Tools MCP Toolset.
    Types []string
    The type of the variable
    compartment_id string
    The OCID of the compartment to move the Database Tools MCP Toolset to.
    database_tools_mcp_toolset_collections list(object)
    The list of database_tools_mcp_toolset_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    database_tools_mcp_server_id string
    The OCID of the related Database Tools McpServer.
    display_name string
    The display name of the tool
    filters list(object)
    state string
    The current state of the Database Tools MCP Toolset.
    types list(string)
    The type of the variable
    compartmentId String
    The OCID of the compartment to move the Database Tools MCP Toolset to.
    databaseToolsMcpToolsetCollections List<GetMcpToolsetsMcpToolsetCollection>
    The list of database_tools_mcp_toolset_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    databaseToolsMcpServerId String
    The OCID of the related Database Tools McpServer.
    displayName String
    The display name of the tool
    filters List<GetMcpToolsetsFilter>
    state String
    The current state of the Database Tools MCP Toolset.
    types List<String>
    The type of the variable
    compartmentId string
    The OCID of the compartment to move the Database Tools MCP Toolset to.
    databaseToolsMcpToolsetCollections GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollection[]
    The list of database_tools_mcp_toolset_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    databaseToolsMcpServerId string
    The OCID of the related Database Tools McpServer.
    displayName string
    The display name of the tool
    filters GetDatabaseToolsMcpToolsetsFilter[]
    state string
    The current state of the Database Tools MCP Toolset.
    types string[]
    The type of the variable
    compartment_id str
    The OCID of the compartment to move the Database Tools MCP Toolset to.
    database_tools_mcp_toolset_collections Sequence[GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollection]
    The list of database_tools_mcp_toolset_collection.
    id str
    The provider-assigned unique ID for this managed resource.
    database_tools_mcp_server_id str
    The OCID of the related Database Tools McpServer.
    display_name str
    The display name of the tool
    filters Sequence[GetDatabaseToolsMcpToolsetsFilter]
    state str
    The current state of the Database Tools MCP Toolset.
    types Sequence[str]
    The type of the variable
    compartmentId String
    The OCID of the compartment to move the Database Tools MCP Toolset to.
    databaseToolsMcpToolsetCollections List<Property Map>
    The list of database_tools_mcp_toolset_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    databaseToolsMcpServerId String
    The OCID of the related Database Tools McpServer.
    displayName String
    The display name of the tool
    filters List<Property Map>
    state String
    The current state of the Database Tools MCP Toolset.
    types List<String>
    The type of the variable

    Supporting Types

    GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollection

    GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItem

    AllowedRoles List<string>
    The roles granted access to this MCP tool
    CompartmentId string
    The OCID of the compartment in which to list resources.
    DatabaseToolsMcpServerId string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    DefaultExecutionType string
    The default execution type for the toolset. The default value is SYNCHRONOUS.
    DefinedTags Dictionary<string, string>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    The description of the variable
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    FreeformTags Dictionary<string, string>
    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
    The OCID of the related Generative AI Semantic Store.
    Id string
    The OCID of the Database Tools MCP Toolsets.
    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<GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemLock>
    Locks associated with this resource.
    Reports List<GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemReport>
    List of Database Tools Customizable reporting tools
    Sources List<GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemSource>
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    State string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    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
    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
    Name of the tool returned by the MCP Server
    Tools List<GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemTool>
    List of Database Tools Customizable reporting tools
    Type string
    A filter to return only resources with one of the specified type values.
    Variables List<GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemVariable>
    The variables to use with the query
    Version int
    The MCP toolset version
    AllowedRoles []string
    The roles granted access to this MCP tool
    CompartmentId string
    The OCID of the compartment in which to list resources.
    DatabaseToolsMcpServerId string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    DefaultExecutionType string
    The default execution type for the toolset. The default value is SYNCHRONOUS.
    DefinedTags map[string]string
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    The description of the variable
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    FreeformTags map[string]string
    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
    The OCID of the related Generative AI Semantic Store.
    Id string
    The OCID of the Database Tools MCP Toolsets.
    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 []GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemLock
    Locks associated with this resource.
    Reports []GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemReport
    List of Database Tools Customizable reporting tools
    Sources []GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemSource
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    State string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    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
    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
    Name of the tool returned by the MCP Server
    Tools []GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemTool
    List of Database Tools Customizable reporting tools
    Type string
    A filter to return only resources with one of the specified type values.
    Variables []GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemVariable
    The variables to use with the query
    Version int
    The MCP toolset version
    allowed_roles list(string)
    The roles granted access to this MCP tool
    compartment_id string
    The OCID of the compartment in which to list resources.
    database_tools_mcp_server_id string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    default_execution_type string
    The default execution type for the toolset. The default value is SYNCHRONOUS.
    defined_tags map(string)
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    The description of the variable
    display_name string
    A filter to return only resources that match the entire specified display name.
    freeform_tags map(string)
    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
    The OCID of the related Generative AI Semantic Store.
    id string
    The OCID of the Database Tools MCP Toolsets.
    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)
    List of Database Tools Customizable reporting tools
    sources list(object)
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    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
    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
    Name of the tool returned by the MCP Server
    tools list(object)
    List of Database Tools Customizable reporting tools
    type string
    A filter to return only resources with one of the specified type values.
    variables list(object)
    The variables to use with the query
    version number
    The MCP toolset version
    allowedRoles List<String>
    The roles granted access to this MCP tool
    compartmentId String
    The OCID of the compartment in which to list resources.
    databaseToolsMcpServerId String
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    defaultExecutionType String
    The default execution type for the toolset. The default value is SYNCHRONOUS.
    definedTags Map<String,String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    The description of the variable
    displayName String
    A filter to return only resources that match the entire specified display name.
    freeformTags Map<String,String>
    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
    The OCID of the related Generative AI Semantic Store.
    id String
    The OCID of the Database Tools MCP Toolsets.
    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<GetMcpToolsetsMcpToolsetCollectionItemLock>
    Locks associated with this resource.
    reports List<GetMcpToolsetsMcpToolsetCollectionItemReport>
    List of Database Tools Customizable reporting tools
    sources List<GetMcpToolsetsMcpToolsetCollectionItemSource>
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state String
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    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
    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
    Name of the tool returned by the MCP Server
    tools List<GetMcpToolsetsMcpToolsetCollectionItemTool>
    List of Database Tools Customizable reporting tools
    type String
    A filter to return only resources with one of the specified type values.
    variables List<GetMcpToolsetsMcpToolsetCollectionItemVariable>
    The variables to use with the query
    version Integer
    The MCP toolset version
    allowedRoles string[]
    The roles granted access to this MCP tool
    compartmentId string
    The OCID of the compartment in which to list resources.
    databaseToolsMcpServerId string
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    defaultExecutionType string
    The default execution type for the toolset. The default value is SYNCHRONOUS.
    definedTags {[key: string]: string}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    The description of the variable
    displayName string
    A filter to return only resources that match the entire specified display name.
    freeformTags {[key: string]: string}
    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
    The OCID of the related Generative AI Semantic Store.
    id string
    The OCID of the Database Tools MCP Toolsets.
    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 GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemLock[]
    Locks associated with this resource.
    reports GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemReport[]
    List of Database Tools Customizable reporting tools
    sources GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemSource[]
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state string
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    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
    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
    Name of the tool returned by the MCP Server
    tools GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemTool[]
    List of Database Tools Customizable reporting tools
    type string
    A filter to return only resources with one of the specified type values.
    variables GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemVariable[]
    The variables to use with the query
    version number
    The MCP toolset version
    allowed_roles Sequence[str]
    The roles granted access to this MCP tool
    compartment_id str
    The OCID of the compartment in which to list resources.
    database_tools_mcp_server_id str
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    default_execution_type str
    The default execution type for the toolset. The default value is SYNCHRONOUS.
    defined_tags Mapping[str, str]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    The description of the variable
    display_name str
    A filter to return only resources that match the entire specified display name.
    freeform_tags Mapping[str, str]
    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
    The OCID of the related Generative AI Semantic Store.
    id str
    The OCID of the Database Tools MCP Toolsets.
    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[GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemLock]
    Locks associated with this resource.
    reports Sequence[GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemReport]
    List of Database Tools Customizable reporting tools
    sources Sequence[GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemSource]
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state str
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    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
    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
    Name of the tool returned by the MCP Server
    tools Sequence[GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemTool]
    List of Database Tools Customizable reporting tools
    type str
    A filter to return only resources with one of the specified type values.
    variables Sequence[GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemVariable]
    The variables to use with the query
    version int
    The MCP toolset version
    allowedRoles List<String>
    The roles granted access to this MCP tool
    compartmentId String
    The OCID of the compartment in which to list resources.
    databaseToolsMcpServerId String
    A filter to return only resources matching the specified databaseToolsMcpServerId.
    defaultExecutionType String
    The default execution type for the toolset. The default value is SYNCHRONOUS.
    definedTags Map<String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    The description of the variable
    displayName String
    A filter to return only resources that match the entire specified display name.
    freeformTags Map<String>
    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
    The OCID of the related Generative AI Semantic Store.
    id String
    The OCID of the Database Tools MCP Toolsets.
    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>
    List of Database Tools Customizable reporting tools
    sources List<Property Map>
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    state String
    A filter to return resources only when their databaseToolsMcpToolsetLifecycleState matches the specified databaseToolsMcpToolsetLifecycleState.
    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
    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
    Name of the tool returned by the MCP Server
    tools List<Property Map>
    List of Database Tools Customizable reporting tools
    type String
    A filter to return only resources with one of the specified type values.
    variables List<Property Map>
    The variables to use with the query
    version Number
    The MCP toolset version

    GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemLock

    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
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    Type string
    A filter to return only resources with one of the specified type values.
    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
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    Type string
    A filter to return only resources with one of the specified type values.
    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
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    type string
    A filter to return only resources with one of the specified type values.
    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
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    type String
    A filter to return only resources with one of the specified type values.
    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
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    type string
    A filter to return only resources with one of the specified type values.
    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
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    type str
    A filter to return only resources with one of the specified type values.
    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
    The time the Database Tools MCP server was created. An RFC3339 formatted datetime string.
    type String
    A filter to return only resources with one of the specified type values.

    GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemReport

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

    GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemSource

    Type string
    A filter to return only resources with one of the specified type values.
    Value string
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    Type string
    A filter to return only resources with one of the specified type values.
    Value string
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type string
    A filter to return only resources with one of the specified type values.
    value string
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type String
    A filter to return only resources with one of the specified type values.
    value String
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type string
    A filter to return only resources with one of the specified type values.
    value string
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type str
    A filter to return only resources with one of the specified type values.
    value str
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.
    type String
    A filter to return only resources with one of the specified type values.
    value String
    The SQL source. Can contain multiple statements with a mix of queries, DML, DCL, DLL and scripts.

    GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemTool

    AllowedRoles List<string>
    The roles granted access to this MCP tool
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    Name string
    The name of the variable
    Status string
    The status of the tool
    AllowedRoles []string
    The roles granted access to this MCP tool
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    Name string
    The name of the variable
    Status string
    The status of the tool
    allowed_roles list(string)
    The roles granted access to this MCP tool
    display_name string
    A filter to return only resources that match the entire specified display name.
    name string
    The name of the variable
    status string
    The status of the tool
    allowedRoles List<String>
    The roles granted access to this MCP tool
    displayName String
    A filter to return only resources that match the entire specified display name.
    name String
    The name of the variable
    status String
    The status of the tool
    allowedRoles string[]
    The roles granted access to this MCP tool
    displayName string
    A filter to return only resources that match the entire specified display name.
    name string
    The name of the variable
    status string
    The status of the tool
    allowed_roles Sequence[str]
    The roles granted access to this MCP tool
    display_name str
    A filter to return only resources that match the entire specified display name.
    name str
    The name of the variable
    status str
    The status of the tool
    allowedRoles List<String>
    The roles granted access to this MCP tool
    displayName String
    A filter to return only resources that match the entire specified display name.
    name String
    The name of the variable
    status String
    The status of the tool

    GetDatabaseToolsMcpToolsetsDatabaseToolsMcpToolsetCollectionItemVariable

    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    A filter to return only resources with one of the specified type values.
    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    A filter to return only resources with one of the specified type values.
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    A filter to return only resources with one of the specified type values.
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    A filter to return only resources with one of the specified type values.
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    A filter to return only resources with one of the specified type values.
    description str
    The description of the variable
    name str
    The name of the variable
    type str
    A filter to return only resources with one of the specified type values.
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    A filter to return only resources with one of the specified type values.

    GetDatabaseToolsMcpToolsetsFilter

    Name string
    The name of the variable
    Values List<string>
    Regex bool
    Name string
    The name of the variable
    Values []string
    Regex bool
    name string
    The name of the variable
    values list(string)
    regex bool
    name String
    The name of the variable
    values List<String>
    regex Boolean
    name string
    The name of the variable
    values string[]
    regex boolean
    name str
    The name of the variable
    values Sequence[str]
    regex bool
    name String
    The name of the variable
    values List<String>
    regex Boolean

    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
    Schema (JSON)
    pulumi/pulumi-oci

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial