{"repo":"tobilg/duckerd","free":true,"listed":false,"github":"https://github.com/tobilg/duckerd","clone":"git clone https://github.com/tobilg/duckerd.git","description":"CLI to create an ER Diagram from DuckDB database files","language":"TypeScript","stars":158,"topics":["cli","database-diagram","duckdb","erd","erdiagram"],"license":null,"category":"cli-tools","readme_excerpt":"DuckERD CLI A CLI tool for generating ERD diagrams from DuckDB databases. Prerequisites - Node.js (v18.19.0 or later) Installation To install the CLI tool, run: Usage Generate an ERD diagram of the database schemas. Options: - -d, --database : Path to the database file - -t, --theme [theme] : Theme of the chart (choices: default , forest , dark , neutral , default: default ) - -o, --output : Path to the output file - -m, --mmd-output : Path to write the Mermaid source ( .mmd ) file (default: cleaned up after rendering) - -w, --width [width] : Width of the page (default: 1024 ) - -H, --height [height] : Height of the page (default: 768 ) - -f, --outputFormat [format] : Output format for the generated image (choices: svg , png , pdf , default: png ) - -e, --expand-structs : Expand STRUCT columns into individual sub-field rows (e.g. full name STRUCT(given VARCHAR, family VARCHAR) becomes full name given and full name family ) Example: It's possible that you need to re-run the command after the first execution, because the DuckERD CLI automatically installs the @mermaid-js/mermaid-cli package globally when it's missing on your system. Usage example Download the example database For this example we use the AWS IAM database from the AWS IAM Data project. Generate the ERD Then, we can generate the ERD as PNG with the neutral theme and otherwise default settings: Result","default_branch":null,"files":null,"tree":[],"storefront":"/r/tobilg","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tobilg/duckerd/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}