Your Oracle database connection is usually defined on your local machine, in the settings files for your tools such as SQL Developer (VS code or Classic), SQLcl, etc. But in the ‘cloud’ – you can also define a Connection resource in our Database Tools developer service in OCI. This connection empowers three things, mainly – … [Read more…]
Look video of this post here. Tomorrow (6/9) at 2pm ET, I’ll be joining YCharts for a Mid-Year Market Prospects. We’ll take a data-based look at where the market currently stands, what’s changed over the past six months, and what investors should pay attention to as we head into the second half of 2026. Topics … [Read more…]
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 … [Read more…]
I will be joining the aioug and Oracle AI World Tour in February 2026. This will be my first trip to India, so I am very excited to see this amazing part of the world. Details Hyderabad, February 7 Bengaluru, February 8 Bengaluru University, February 9 Mumbai, February 10 I’ll discuss how to get the … [Read more…]
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” … [Read more…]
Look video of this post here. Something I’m excited about is a new offering from YCharts called Communities. This gives advisors a way to follow research and insights from voices they trust, directly within a platform that many use every day for investment research and client communications. This means that instead of trying to recreate … [Read more…]
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 … [Read more…]
Having trouble with your AI Agent and running an Oracle Database connection with our SQLcl MCP Server? It might look like this – What happened? SQLcl can connect, and so can my SQL Developer VS Code extension??? The problem is that local MCP Servers appear in private environments, they do NOT inherit your system or … [Read more…]
Look video of this post here. Over the past 30 years, the purchasing power of the US Consumer Dollar has halved due to inflation. At the same time, the S&P 500 has risen 828% (7.7% annually) AFTER adjusting for inflation. Why you need to invest for the long term, in one chart… At Creative Planning, … [Read more…]
My first Middle Eastern sunset, Doha Qatar I started this post in Qatar waiting for my connection to Hyderabad. My goal is to publish 7 blog posts in 7 days, and share some personal/travel stuff along with the technical content you usually see here. Today’s article is a short article, around one of our newest … [Read more…]