Oracle Cloud Infrastructure Documentation

Database Tools Model Context Protocol (MCP) Toolsets

MCP Toolsets define the database capabilities that a Database Tools MCP Server provides to MCP clients. A toolset is a curated set of tools that MCP clients can discover and run through the MCP Server, using the Database Tools connection associated with that server.

Tool access is controlled by IAM Identity Domains application roles such as MCP_User and MCP_Administrator.

After creating an MCP Server, you need to create one or more MCP Toolsets. The toolset types are:

  • Custom SQL tool: Enables execution of a predefined, parameterized SQL or PL/SQL script for consistent, repeatable database operations.
  • Built-in SQL tools: Enables built-in SQL tools that allows execution of ad-hoc SQL or PL/SQL script as well as common database operations.
  • Customizable reporting tools: Enables finding and executing predefined, parameterized SQL reports for consistent, repeatable data analysis.