Database Tools 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.
-
Generative AI SQL Assistant: Enables natural language queries to be translated into validated SQL statements.
For more information about NL2SQL, see NL2SQL Quick Start.