Oracle has enhanced its flagship tools, SQLcl and SQL Developer for VS Code, by integrating MCP (Multi-Command Processor) support, streamlining database interactions for developers and business users. SQLcl, a command line interface, now acts as an MCP server, enabling AI tools to securely execute tasks through natural language commands. Key MCP functionalities include browsing saved database connections, executing SQL and PL/SQL commands, and managing connections. SQL Developer integrates seamlessly with VS Code, simplifying the entire development cycle, allowing for effortless query execution, and enhancing schema management.
With MCP, users can create and refine SQL queries verbally, making data retrieval more intuitive. Oracle plans to expand MCP capabilities to include features for high availability and disaster recovery management. This development aligns Oracle with other RDBMS adopting AI-driven solutions, transforming how users interact with databases and paving the way for future innovations. Stay updated by subscribing to the weekly newsletter from I Programmer.
Source link
