Dynamics Business Central Schema Extraction Consultation

Need some consulting on the best method to get the raw schema from dynamics business central cloud in either json, SQL DDL or some other format so that it can be visualized in a database modelling software. Looking to get: table name, field id, field name, field type, primary keys, foreign keys and relate table names.

Through VS code you can download all the symbol .al files where each file contain the complete raw schema of each table but I have only been able to use parsing in python to get this information and its very error prone. There is also the 3rd part site bcentral.dev but I'm looking for full control of the output to put into stand alone data modeler. There's also some vs code plugins like AZ AL Dev Tools but there is no export options.

Just looking for advice on best solution and a bit of help with the proccess.

Please put the keyword "DYNAMICS123" at the start of your response so that we can filter out the automated responses.

Thanks!