Oracle Fusion Cloud Database Schema Export for AI context — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle Fusion Cloud Database Schema Export for AI context

edited Sep 2, 2025 4:26PM in BI Publisher Learning Center 1 comment

I am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can provide this schema file to an AI model to aid in writing SQL statements in BI Publisher.

I know there is oracle documentation on each table on the oracle docs website, but being able to use a single file as a context to an AI model is much more efficient and effective. I don't need backend proprietary information, just basically what is on the docs.oracle.com website for the tables, just as a JSON file.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!