Rotating Secrets Without Breaking Anything

An AI Agent Skill for OCI Vault, Your Databases, and the Apps That Use Them

October 13, 2026, 2:43 pm OCI OCI Vault ADW PostgreSQL MongoDB Docker Security Python AI Agents DevOps Misc

A secret in OCI Vault is rarely used in one place: the database holds a copy, and so does every app that connects to it. How I built a confirmation-gated agent skill that rotates the secret and every downstream copy without a window where they disagree, why the AI agent gets a version-bound phrase instead of a yes, and what broke in testing.

Continue Reading...

Building an AI Financial Analyst with Oracle Select AI Agent — Part 5

The Builder, and Where I Let the LLM Near the Code

August 31, 2026, 9:00 am ADW Select AI OCI Python PL/SQL Musing

After building the same agent stack twice by hand I wrote a tool to generate it — and deliberately banned the model from writing any of the SQL. Where a language model earns its place in a code generator, and where determinism matters more.

Continue Reading...

Building an AI Financial Analyst with Oracle Select AI Agent — Part 4

When the Tooling Tells You It Worked

August 20, 2026, 9:00 am ADW Select AI OCI PL/SQL Data Warehouse Musing

A PL/SQL object with a compile error still gets created — it just gets created INVALID, and most drivers report that as success. Why that surfaces three layers away as a missing-grant error, and the fixed order I now use to trace an agent failure back to its cause.

Continue Reading...

Building an AI Financial Analyst with Oracle Select AI Agent — Part 3

Custom Tools, and Getting the Password Out of the Code

August 9, 2026, 9:00 am ADW Select AI OCI PL/SQL Machine Learning Python OML4Py

Registering your own PL/SQL functions as agent tools, and running pandas and numpy inside the database through OML4Py. Plus the authentication problem: a stored credential cannot be read back, but the OCI Vault can be — which removes the hardcoded password entirely.

Continue Reading...

Building an AI Financial Analyst with Oracle Select AI Agent — Part 2

The Foundation: NL2SQL and RAG

July 29, 2026, 9:00 am ADW Data Analytics Select AI OCI PL/SQL Data Warehouse

Building the foundation: table comments that make natural-language SQL work, the profiles, and the vector index. Includes the IAM policy that catches everyone — the database needs its own, and being a tenancy admin does not cover it — and the grant problem that everyone blames on roles when the real culprit is something else.

Continue Reading...

Building an AI Financial Analyst with Oracle Select AI Agent — Part 1

What It Is, Why I Went This Route, and How the Pieces Fit

July 18, 2026, 9:00 am ADW Data Analytics Select AI OCI APEX Machine Learning Data Warehouse Musing

Part 1 of a five-part series on building an AI financial analyst inside Oracle Autonomous Database. What Select AI Agent is, why an in-database agent beat the managed service for this use case, and how the four core objects — tool, task, agent, team — stack together.

Continue Reading...

Analytics and Lakehouse Integration Options for Oracle Applications

March 10, 2023, 12:00 am OCI Data Analytics OAC ADW Oracle Lakehouse

A Red Hot session on integration options between Oracle Cloud applications (Fusion, EPM) and the modern data platform on OCI, covering the Lakehouse architecture, extraction methods, and recommended patterns.

Continue Reading...