I have a white paper you may be interested in. I just configured a hermes agent on my vps to use a very detailed skills md to connect to my 26ai db and build out everything from the db to pages with apex objects from my phone using its own metadata
The APEX skills md needs quite a bit of work, but here is a breakdown of my Oracle APEX agentic coding setup using hermes and claude code and interfaces via telegram and cli on the server.