Importing SQL Tables, Columns & Data types into Draw.io

4,549 views
Skip to first unread message

Chris

unread,
Apr 18, 2018, 9:28:47 AM4/18/18
to draw.io
I am working with a database that doesn't have many primary keys and I am trying to create a visual mapping of the tables to easily see how they are all linked. Does anyone know of a way to import all tables from a SQL database along with their columns and datatypes into Draw.io? I would like to not have to run an SQL query to create each table one at a time within Draw.io as shown in the below link...


Any help on this is appreciated.

Thanks!

Gaudenz Alder

unread,
Apr 19, 2018, 5:13:55 AM4/19/18
to draw.io
A contribution has been made recently to support SQL Server and MySQL in the plugin, see https://github.com/jgraph/drawio/pull/233

Taylor Funk

unread,
Nov 12, 2022, 9:58:31 AM11/12/22
to diagrams.net Q&A
I have my pr with improvements to sql import, more formats and also ads the foreign relationship arrows.
improved import sql parser to models by lastlink · Pull Request #3091 · jgraph/drawio (github.com). waiting on team to bring the changes in (they won't merge it directly but push their own changes if they decide to keep it).

Taylor Funk

unread,
Jul 23, 2024, 10:47:40 PM7/23/24
to draw.io Q&A
use my updated plugin  https://github.com/funktechno/sqltooling-drawio for sql import and exporting into drawio
Reply all
Reply to author
Forward
0 new messages