Oracle Fusion Cloud Database Schema Export for AI context
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.