ORDS MCP REPORTS AND CUSTOM SQL TOOLS
ORDS MCP can give an AI agent access to saved SQL or PL/SQL. You can publish that SQL as a report or as a custom SQL tool . You can review the SQL before you publish it. When a user asks a question, the agent supplies values for the query inputs. ORDS runs the saved query, so the agent does not need to generate a new query for each request. The complete demo configuration and setup script are available in the ORDS MCP reports and custom SQL tools GitHub repository . The main difference between these two MCP options is how the agent finds and calls the saved SQL: Report Custom SQL tool What the agent sees The built-in report tools: report_list , report_sql , and report_execute One MCP tool for each definition Who can define it An ORDS admin, or a schema developer when schema reports are enabled An O...