sqlER Diagram Editor

This extension provides an entity-relationship (ER) diagram modelling tool that synchronises with your SQL data definition code. Changes made to the SQL will automatically be reflected in the ER diagram, and vice-versa.

Usage

The ER diagram is stored as a .sqler file alongside your SQL file. Opening this file will launch the diagram editor.

To create a new ER diagram:

Create a new diagram from the command palette using the sqler.createDiagram action.

To create a diagram from an existing SQL file:

Open the SQL file, then use the sqler.openDiagram action in the command palette, or click the corresponding toolbar icon.

Compatibility

Currently, the tool only officially supports SQLite syntax. It may work with other dialects of SQL, but more advanced features may not be supported.