Oracle Cloud Infrastructure Documentation

Create an MCP Toolset

  1. In the Model Context Protocol Servers page, click the name of the MCP Server that was created.
  2. In the specific MCP Server page, select the Toolsets tab.
  3. Click Create Model Context Protocol Toolset.

  4. Enter the following details for creating the Toolset. The following example is an SQL query for a Toolset that lists the employees that match a specific criteria.

    Note

    Ensure that the EMPLOYEES table already exists and includes the FIRST_NAME and LAST_NAME columns before creating the Toolset.
    • Name: Enter a name for the Toolset, such as List employees matching substring.
    • Description: Enter a description for the Toolset such as List employees matching substring passed as parameter "substring".
    • Compartment: Select the compartment for the Toolset.
    • Type: Select the type of Toolset. In this example, select Custom SQL tool.
    • Tool name: Enter list_employees_matching_substring.
    • Tool description: Enter List employees matching substring passed as parameter "substring".
    • Allowed Roles: Select from the predefined application roles. See Application Roles for more information.
    • SQL source: Enter the following code for this example:
      SELECT * FROM EMPLOYEES
WHERE LAST_NAME LIKE'%'|| :substring ||'%'
OR FIRST_NAME LIKE'%'|| :substring ||'%'
    • Variables: Add Name substring, Type VARCHAR2, and Description "The substring to search for in first name and last name".
  5. Click Create.