Prebuilt and Custom Tools
Learn about the Database Tools MCP Toolsets.
The following table summarizes the Database Tools MCP toolset types, whether the tools are prebuilt or custom, the specific tool names, and the default allowed roles required to use them.
Table 6-1 Toolsets
| Toolset Type | Tool type | Tool Name | Description | Default Allowed Roles |
|---|---|---|---|---|
| Custom SQL | Custom | Customized tool name | Use this tool when you want to define one. | MCP_Operator |
| Built-in SQL | Prebuilt | sql_run |
Runs SQL queries on the connected Oracle database. If no active connection exists, the user is prompted to establish one. Query results are returned in CSV format. |
MCP_Operator MCP_Administrator |
| schema_information | Generates detailed insights about a database schema by examining and enhancing metadata collected from executed queries. | MCP_User MCP_Operator MCP_Administrator | ||
| request_status | Retrieves the current status and, when available, the final
result of a previously submitted asynchronous tool call. Use this
tool when another tool returns a toolRequestId rather than a final
result. Call this tool with the toolRequestId to poll until the
request completes. Possible outcomes include:
|
MCP_User MCP_Operator MCP_Administrator | ||
| Customizable Reporting Tools | Prebuilt |
report_list |
Use this tool to discover which reports exist and to obtain their metadata, including the report ID (ID of the SQL report), display name, description, purpose, and usage instructions. The returned reportId values are required when calling report_execute or report_sql. | MCP_User MCP_Operator MCP_Administrator |
|
report_execute |
Provide the reportId of the report to run, along with any required variable values. Variable placeholders defined by the report will be substituted with the supplied arguments at execution time. The result set is returned as CSV-formatted content, making it easy to consume programmatically or display to users. Use report_list to identify the correct reportId before calling this tool. |
MCP_User MCP_Operator MCP_Administrator | ||
| report_sql |
Use this tool when you need to inspect, understand, or customize the SQL used by a report. The returned SQL can be modified and executed directly using report_execute. The tool expects a valid reportId, which can be obtained from report_list. |
MCP_Operator |