Idea Summary
Since Oracle APEX already offers integration with AI services, it would be incredibly valuable to support MCP (Metadata Communication Protocol) features, enabling third-party AI systems to query the database via the MCP protocol. This would enhance interoperability and expand use cases for external AI-driven analytics or assistants.
Use Case
Allowing AI to dynamically explore metadata, query data structures, and interact securely with the APEX-managed database through MCP could significantly streamline development for external platforms or partner ecosystems.
Preferred Solution (Optional)
Oracle APEX could implement support for function-level exposure, allowing developers to explicitly define and expose methods for database access. These methods would be securely accessible through an MCP-compliant server connection, ensuring compatibility with third-party AI clients while maintaining strict control over data interaction.