How drawdb-io/drawdb works
drawDB is a browser-based ERD editor and SQL generator. The principal workflow is: a user opens the editor, imports or creates schema objects, edits the diagram through shared state, views the ERD on the canvas, then saves locally or exports SQL/diagram formats. The repository also documents templates, sharing, collaboration, migrations, custom types, and AI-assisted import. Some wiring is inferred from naming and documented capabilities; unsampled implementation details are represented conservatively.
Main entry points: DiagramContext.jsx Diagram State · Canvas.jsx ERD Canvas · ImportSource.jsx Import Dialog · Editor.jsx Editor Workspace
Components 24
Application Shell
- Application Router
src/App.jsx - Editor Workspace
src/pages/Editor.jsx - Diagram Templates
src/pages/Templates.jsx
Diagram Editing
- Editor Controls
src/components/EditorHeader/ControlPanel.jsx - Diagram State
src/context/DiagramContext.jsx - ERD Canvas
src/components/EditorCanvas/Canvas.jsx - Table Renderer
src/components/EditorCanvas/Table.jsx - Relationship Renderer
src/components/EditorCanvas/Relationship.jsx - Note Renderer
src/components/EditorCanvas/Note.jsx - View Renderer
src/components/EditorCanvas/View.jsx - Schema Side Panel
src/components/EditorSidePanel/SidePanel.jsx
Schema Interchange
- Import Dialog
src/components/EditorHeader/Modal/ImportSource.jsx - DBML Importer
src/utils/importFrom/dbml.js - SQL Importers
src/utils/importSQL/index.js - AI Diagram Import
src/utils/importAiDiagram.js - SQL Exporters
src/utils/exportSQL/index.js - Diagram Exporters
src/utils/exportAs - Migration Tools
src/components/EditorHeader/SideSheet/Migration.jsx
Persistence Sharing
- Collaboration Context
src/context/CollabContext.jsx - Local Diagram Store
src/data/db.js - Diagram List
src/components/EditorHeader/Modal/Open/hooks/useDiagramList.js - Share Dialog
src/components/EditorHeader/Modal/Share.jsx
Other components
- Diagram User
- Cloud Diagram Service
Connections 23
- Diagram User → Application Router: opens
- Application Router → Editor Workspace: routes
- Diagram User → Diagram Templates: browses
- Editor Workspace → Editor Controls: renders
- Editor Workspace → Diagram State: provides
- Editor Controls → Diagram State: edits
- Schema Side Panel → Diagram State: edits
- Diagram State → ERD Canvas: supplies state
- ERD Canvas → Table Renderer: renders
- ERD Canvas → Relationship Renderer: renders
- ERD Canvas → Note Renderer: renders
- ERD Canvas → View Renderer: renders
- Diagram State → Collaboration Context: emits changes
- Diagram List → Local Diagram Store: reads diagrams
- Diagram List → Cloud Diagram Service: lists diagrams
- Share Dialog → Cloud Diagram Service: shares diagram
- Editor Controls → Import Dialog: opens
- Import Dialog → DBML Importer: parses DBML
- Import Dialog → SQL Importers: parses SQL
- Import Dialog → AI Diagram Import: requests import
- SQL Exporters → Diagram State: reads schema
- Diagram Exporters → Diagram State: reads diagram
- Migration Tools → Diagram State: compares schema