How valeragav/drawio-sql-er works
drawio-sql-er is a draw.io plugin that turns SQL DDL—or a read-only PostgreSQL schema—into an editable ER diagram. The main workflow is source selection, schema parsing, diagram generation and placement; users can then update, compare, rearrange, highlight, or export the diagram. The README documents all major capabilities. Some implementation excerpts are partial, so edges between components are included only where the excerpts, SOURCE INDEX references, or README support them.
Main entry points: plugin.js SQL ER plugin · drawio.js Graph and draw.io XML · introspect.js PostgreSQL introspection · layout.js Diagram layout
Components 18
Schema input
- SQL parser
src/parser.js - PostgreSQL introspection
bridge/introspect.js - Schema API server
scripts/server.js
Diagram generation
- Graph and draw.io XML
src/drawio.js - Schema grouping
src/groups.js - Diagram layout
src/layout.js - Relationship routing
src/routing.js - Page placement
src/placement.js
Diagram operations
- Page updates and reflow
src/page.js - Schema comparison
src/diff.js - Difference highlighting
src/highlight.js - Diagram legend
src/legend.js - SQL export
src/export.js - Mermaid export
src/mermaid.js
Plugin interface
- SQL ER plugin
src/plugin.js - Table selection
src/select.js
Other components
- draw.io user
- PostgreSQL database
Connections 22
- draw.io user → SQL ER plugin: provides SQL or commands
README.md - SQL ER plugin → SQL parser: parses SQL
src/plugin.js - SQL ER plugin → Table selection: selects tables
src/plugin.js - SQL ER plugin → PostgreSQL introspection: requests schema
- SQL ER plugin → Schema API server: requests schema API
- Schema API server → PostgreSQL introspection: reads schema
scripts/server.js - PostgreSQL introspection → PostgreSQL database: queries catalogs
bridge/introspect.js - PostgreSQL introspection → SQL parser: produces DDL for
bridge/introspect.js - SQL ER plugin → Graph and draw.io XML: builds diagram
src/plugin.js - Graph and draw.io XML → Schema grouping: computes groups
src/drawio.js - Graph and draw.io XML → Diagram layout: lays out nodes
src/drawio.js - Graph and draw.io XML → Relationship routing: routes links
src/drawio.js - Diagram layout → Schema grouping: uses groups
src/layout.js - Diagram layout → Relationship routing: uses routing
src/layout.js - SQL ER plugin → Page placement: places diagram
src/plugin.js - SQL ER plugin → Page updates and reflow: updates page
src/plugin.js - Page updates and reflow → Graph and draw.io XML: builds replacement graph
src/page.js - SQL ER plugin → Schema comparison: compares schemas
src/plugin.js - SQL ER plugin → Difference highlighting: highlights differences
src/plugin.js - SQL ER plugin → Diagram legend: adds legend
src/plugin.js - SQL ER plugin → SQL export: exports SQL
src/plugin.js - SQL ER plugin → Mermaid export: exports Mermaid
src/plugin.js