Tech Tip #7

Easy Peasy Relationship Diagrams: ERD Editor extension for VS Code

Entity Relationship Diagrams (ERD) are used by Developers, Analysts and Architects to create a visual ‘flow-chart style’ representation that represents relationships among stakeholders, objects, places, concepts or events in an IT system.

Now, you can build these depictions faster than ever before! ERD Editor is a tool that can be used as a web app or extension for Visual Studio Code that allows you to quickly create entity relationship diagrams and saves them in JSON format.

The extension works by first creating a new file with a .erd or .erd.json extension and opening it within Visual Studio Code. once open, you get a blank screen and you can right click anywhere to:

– create a new table, memo or relationship

– control how tables are displayed

– create a database for various database types including SQLite, MySQL, and MariaDB

– import from SQL Schema or a json file

– export to json, SQL Schema, or an image

– automatically arrange tables

– open a differences view for an ERD fileRead more on ERD Editor here!

Read more