Note: Plugins are not supported in draw.io for Confluence. Reload your browser tab to load the plugin into the diagram editor.

Select sql in the drop-down list of built-in plugins, then click OK.

From the menu, select Extras > Plugins.

If you want to always use the sql plugin, add it to the plugins list so it will be loaded each time you create or edit a diagram. Tip: To see the various entity relationship styles, enable the Entity Relation shape library (via More Shapes in the left panel), then hover over the various connector shapes to show their descriptions.

Connect the entities and choose the ‘arrow’ shape that defines the relationship.

Your SQL code is converted into entities containing the attributes, as well as the primary and foreign keys your code defines.

Copy and paste your SQL code into the dialog, then click Insert MySQL or Insert SQL Server, whichever matches the code you just pasted.

To create a new diagram with the plugin already loaded, go to Īs SQL and MySQL are the most popular languages used to program and work with relational database systems, has made it easy to automatically create your diagrams from your code.

To complete your entity relationship diagram, connect the entities together and set the connector ‘arrows’ to describe their relationships.

Insert SQL code using the SQL plugin to automatically generate entity shapes, including their attributes, as well as their primary and foreign keys.

This plugin should be used as-is, as an unsupported example for developers. Transforms tabular text stored in the clipboard to generate markup text useful in applications such as Jira. Modified on: Mon, 14 Sep, 2020 at 1:02 PM

Tableplus export