# drawdb-io/drawdb architecture

> Architecture diagram of the GitHub repository drawdb-io/drawdb, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-20). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/drawdb-io/drawdb
- Repository: https://github.com/drawdb-io/drawdb

## Overview

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: [`src/context/DiagramContext.jsx`](https://github.com/drawdb-io/drawdb/blob/main/src/context/DiagramContext.jsx) (Diagram State), [`src/components/EditorCanvas/Canvas.jsx`](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Canvas.jsx) (ERD Canvas), [`src/components/EditorHeader/Modal/ImportSource.jsx`](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/Modal/ImportSource.jsx) (Import Dialog), [`src/pages/Editor.jsx`](https://github.com/drawdb-io/drawdb/blob/main/src/pages/Editor.jsx) (Editor Workspace)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_application["Application Shell"]
  node_app["Application Router<br/>[App.jsx]"]
  node_editor["Editor Workspace<br/>[Editor.jsx]"]
  node_templates["Diagram Templates<br/>[Templates.jsx]"]
end

subgraph group_editing["Diagram Editing"]
  node_control_panel["Editor Controls<br/>[ControlPanel.jsx]"]
  node_diagram_state["Diagram State<br/>[DiagramContext.jsx]"]
  node_canvas["ERD Canvas<br/>[Canvas.jsx]"]
  node_table_view["Table Renderer<br/>[Table.jsx]"]
  node_relationship_view["Relationship Renderer<br/>[Relationship.jsx]"]
  node_note_view["Note Renderer<br/>[Note.jsx]"]
  node_view_renderer["View Renderer<br/>[View.jsx]"]
  node_side_panel["Schema Side Panel<br/>[SidePanel.jsx]"]
end

subgraph group_interchange["Schema Interchange"]
  node_import_modal["Import Dialog<br/>[ImportSource.jsx]"]
  node_dbml_import["DBML Importer<br/>[dbml.js]"]
  node_sql_import["SQL Importers<br/>[index.js]"]
  node_ai_import["AI Diagram Import<br/>[importAiDiagram.js]"]
  node_export_sql["SQL Exporters<br/>[index.js]"]
  node_export_formats["Diagram Exporters"]
  node_migration_tools["Migration Tools<br/>[Migration.jsx]"]
end

subgraph group_storage["Persistence Sharing"]
  node_collab_context["Collaboration Context<br/>[CollabContext.jsx]"]
  node_local_store[("Local Diagram Store<br/>[db.js]")]
  node_diagram_list["Diagram List<br/>[useDiagramList.js]"]
  node_share_ui["Share Dialog<br/>[Share.jsx]"]
end

node_user(("Diagram User"))
node_cloud_api[("Cloud Diagram Service")]

node_user -->|"opens"| node_app
node_app -->|"routes"| node_editor
node_user -->|"browses"| node_templates
node_editor -->|"renders"| node_control_panel
node_editor -->|"provides"| node_diagram_state
node_control_panel -->|"edits"| node_diagram_state
node_side_panel -->|"edits"| node_diagram_state
node_diagram_state -->|"supplies state"| node_canvas
node_canvas -->|"renders"| node_table_view
node_canvas -->|"renders"| node_relationship_view
node_canvas -->|"renders"| node_note_view
node_canvas -->|"renders"| node_view_renderer
node_diagram_state -.->|"emits changes"| node_collab_context
node_diagram_list -->|"reads diagrams"| node_local_store
node_diagram_list -.->|"lists diagrams"| node_cloud_api
node_share_ui -.->|"shares diagram"| node_cloud_api
node_control_panel -->|"opens"| node_import_modal
node_import_modal -->|"parses DBML"| node_dbml_import
node_import_modal -->|"parses SQL"| node_sql_import
node_import_modal -.->|"requests import"| node_ai_import
node_export_sql -->|"reads schema"| node_diagram_state
node_export_formats -->|"reads diagram"| node_diagram_state
node_migration_tools -->|"compares schema"| node_diagram_state

click node_app "https://github.com/drawdb-io/drawdb/blob/main/src/App.jsx"
click node_editor "https://github.com/drawdb-io/drawdb/blob/main/src/pages/Editor.jsx"
click node_templates "https://github.com/drawdb-io/drawdb/blob/main/src/pages/Templates.jsx"
click node_control_panel "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/ControlPanel.jsx"
click node_diagram_state "https://github.com/drawdb-io/drawdb/blob/main/src/context/DiagramContext.jsx"
click node_canvas "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Canvas.jsx"
click node_table_view "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Table.jsx"
click node_relationship_view "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Relationship.jsx"
click node_note_view "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Note.jsx"
click node_view_renderer "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/View.jsx"
click node_side_panel "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorSidePanel/SidePanel.jsx"
click node_collab_context "https://github.com/drawdb-io/drawdb/blob/main/src/context/CollabContext.jsx"
click node_local_store "https://github.com/drawdb-io/drawdb/blob/main/src/data/db.js"
click node_diagram_list "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/Modal/Open/hooks/useDiagramList.js"
click node_share_ui "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/Modal/Share.jsx"
click node_import_modal "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/Modal/ImportSource.jsx"
click node_dbml_import "https://github.com/drawdb-io/drawdb/blob/main/src/utils/importFrom/dbml.js"
click node_sql_import "https://github.com/drawdb-io/drawdb/blob/main/src/utils/importSQL/index.js"
click node_ai_import "https://github.com/drawdb-io/drawdb/blob/main/src/utils/importAiDiagram.js"
click node_export_sql "https://github.com/drawdb-io/drawdb/blob/main/src/utils/exportSQL/index.js"
click node_export_formats "https://github.com/drawdb-io/drawdb/tree/main/src/utils/exportAs"
click node_migration_tools "https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/SideSheet/Migration.jsx"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_app,node_editor,node_templates,node_user toneBlue
class node_control_panel,node_diagram_state,node_canvas,node_table_view,node_relationship_view,node_note_view,node_view_renderer,node_side_panel,node_cloud_api toneAmber
class node_import_modal,node_dbml_import,node_sql_import,node_ai_import,node_export_sql,node_export_formats,node_migration_tools toneMint
class node_collab_context,node_local_store,node_diagram_list,node_share_ui toneRose
```

## Components

### Application Shell

- [Application Router](https://github.com/drawdb-io/drawdb/blob/main/src/App.jsx): `src/App.jsx`
- [Editor Workspace](https://github.com/drawdb-io/drawdb/blob/main/src/pages/Editor.jsx): `src/pages/Editor.jsx`
- [Diagram Templates](https://github.com/drawdb-io/drawdb/blob/main/src/pages/Templates.jsx): `src/pages/Templates.jsx`

### Diagram Editing

- [Editor Controls](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/ControlPanel.jsx): `src/components/EditorHeader/ControlPanel.jsx`
- [Diagram State](https://github.com/drawdb-io/drawdb/blob/main/src/context/DiagramContext.jsx): `src/context/DiagramContext.jsx`
- [ERD Canvas](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Canvas.jsx): `src/components/EditorCanvas/Canvas.jsx`
- [Table Renderer](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Table.jsx): `src/components/EditorCanvas/Table.jsx`
- [Relationship Renderer](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Relationship.jsx): `src/components/EditorCanvas/Relationship.jsx`
- [Note Renderer](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/Note.jsx): `src/components/EditorCanvas/Note.jsx`
- [View Renderer](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorCanvas/View.jsx): `src/components/EditorCanvas/View.jsx`
- [Schema Side Panel](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorSidePanel/SidePanel.jsx): `src/components/EditorSidePanel/SidePanel.jsx`

### Schema Interchange

- [Import Dialog](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/Modal/ImportSource.jsx): `src/components/EditorHeader/Modal/ImportSource.jsx`
- [DBML Importer](https://github.com/drawdb-io/drawdb/blob/main/src/utils/importFrom/dbml.js): `src/utils/importFrom/dbml.js`
- [SQL Importers](https://github.com/drawdb-io/drawdb/blob/main/src/utils/importSQL/index.js): `src/utils/importSQL/index.js`
- [AI Diagram Import](https://github.com/drawdb-io/drawdb/blob/main/src/utils/importAiDiagram.js): `src/utils/importAiDiagram.js`
- [SQL Exporters](https://github.com/drawdb-io/drawdb/blob/main/src/utils/exportSQL/index.js): `src/utils/exportSQL/index.js`
- [Diagram Exporters](https://github.com/drawdb-io/drawdb/tree/main/src/utils/exportAs): `src/utils/exportAs`
- [Migration Tools](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/SideSheet/Migration.jsx): `src/components/EditorHeader/SideSheet/Migration.jsx`

### Persistence Sharing

- [Collaboration Context](https://github.com/drawdb-io/drawdb/blob/main/src/context/CollabContext.jsx): `src/context/CollabContext.jsx`
- [Local Diagram Store](https://github.com/drawdb-io/drawdb/blob/main/src/data/db.js): `src/data/db.js`
- [Diagram List](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/Modal/Open/hooks/useDiagramList.js): `src/components/EditorHeader/Modal/Open/hooks/useDiagramList.js`
- [Share Dialog](https://github.com/drawdb-io/drawdb/blob/main/src/components/EditorHeader/Modal/Share.jsx): `src/components/EditorHeader/Modal/Share.jsx`

### Other components

- **Diagram User**
- **Cloud Diagram Service**

## Connections

- 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
