I have two environments: HR123 – I started a simple schema with just two tables, and no comments, indexes, constraints, etc HR456 – I have a Codex that helps me come up with what a real HR system would look like What do I want I would like to point my Oracle tools at two…
We have released an update to the SQL Developer Extension for VS Code, version 25.4.1 [changeLog]. When you download the new extension update, you may experience problems with our MCP Server. Let’s discuss what happens and how you can avoid it. You have two main options to make our SQLcl MCP server available to the…
Our MCP Servers ship (SQLcl) or optionally offer (OCI) a run_sql tool. It’s great! We built it, we use it, and it works exactly as intended — give the agent a way to execute SQL (generated or otherwise) against your Oracle database. Be careful WHO gets the keys to your house! But “works as intended”…
Today’s post was inspired by Karin’s LiveLab demonstrating Property Graphs. You can see it here. If you choose to run this lab ‘on your own’, you will be given several CSV files to contain two tables. You can now do this in VS Code with our SQL Developer extension! Alternatively, you can right-click the Tables…
A Glance at OAuth Identity, SYS_CONTEXT, and Row-Level Security via OCI AI Database MCP Server The Model Context Protocol (MCP) has defined a very simple way to allow AI Agents to interact with external resources. The HTTPS streaming MCP server is implemented via OAuth2, and it allows business users, identified using Azure Entra ID or…
Starting today, the support window for Oracle SQL Developer version 24.3 has been updated to April 2027. Source: We’re also looking at a minor update to the current 24.3.1 offering that will address some third party libraries that need to be updated along with the embedded Java home. However, there are no new features planned…
Not everyone can download their favorite VS Code extensions from the Microsoft VS Code Marketplace. We now also offer extension packages from Oracle.com, such as the one we have for SQL Developer. You can now get individual VSIX distributions from our SQL Developer extension for VS Code Download page! The license is FUTC, so no…
Anthropic introduced Agent Skills a while ago, and I forgot to dive into that field of AI, until now. The concept is open source and not exclusive to Anthropic of Claude, you can see the details in What you will see below done in Claude Desktop. But first, I want to thank my dear friend…
Hot off the presses as of THIS morning – We now have a lot of new skills available to work on all kinds of different types of tasks around our Oracle databases. The categories include – Category Files Path Database Design & Modeling 4 skills/design/ SQL Development 5 skills/sql-dev/ Performance & Tuning 7 skills/performance/ Application…
Oracle Senior Vice President of Database Development Kris Rice published the Skills block for Oracle AI Database earlier this week. In just a few days, there were quite a lot of fans! If you’re new to Skills in general, I’ve published two posts on the subject, with examples of how to leverage them with our…