silviuilie/d2-erd-from-oracle-db

generate d2lang entity relationship diagram from oracle database instance

based on d2lang d2-erd-from-postgres

arguments

• url db url

options

• exclude - comma separated list of tables to exclude; no default value
• nulls - y/n, show nullable column attribute; default value n
• d2 - d2 options; default value --layout=dagre.

examples

render ERD for TEST_PDB excluding USERS table including nullability column attributes with some d2 arguments like layout etc

    node index.js 127.0.0.42:1521/TEST_PDB --exclude USERS  -n y --d2 '--debug --layout=tala -s'

wil produce something like :

help

    node index.js -h

NOTES :

• tala engine FK rendering points to PK column as oposed to the free layout engines (sql_table connections point to exact row)
• Oracle 19c and JSON_ARRAYAGG
  • describe distinct relationships using other methods? oracle 19.10 json_arrayagg not implemented .. agregation : https://asktom.oracle.com/ords/f?p=100:11:0::::P11_QUESTION_ID:9546118900346418681

TODOs

• test oracle 23 oracle 18
• render in some other way the NULLABLE / NOT NULL attribute
• flat query (table object not json) ?

Related

Create Entity-Relationship Diagrams from SQL Create statements using d2lang and dioxus rust

https://github.com/mdauthentic/db2erd