ERPDesk – UML Designer for Windows
A clean, fast UML designer for ER diagrams, class diagrams, business-process flows, and sequence diagrams. Design tables visually and generate real SQL for PostgreSQL, MySQL, SQL Server, or SQLite — or import existing SQL and see it laid out as a diagram. Round-trip with other UML tools via XMI 2.1, and export to PNG, SVG, or PDF.
Download Desktop Version 1.0
Available on the Microsoft Store — free trial included, no subscription, no ads.
One project, many diagrams
A saved .umlproj file is a project that can hold many diagrams — an ER diagram, a class diagram, and a flowchart all in one place. Switch between them with the tab strip or jump to any element from the Model Explorer tree.
Design tables visually, generate real SQL
The Table (SQL) shape carries structured columns — name, type, length/scale, PK / FK / nullable / unique / auto-increment, default. ERPDesk emits a complete CREATE TABLE script for your choice of dialect:
PostgreSQL
MySQL
SQL Server
SQLite
— with the right identifier quoting, type mapping, and auto-increment idiom for each. -- WARNING comments flag tables without a primary key, dangling foreign keys, and duplicate names.
Changelog — what's new in each release
Full release notes — from the first canvas engine through shape libraries, properties panel, toolbox, file / export, UX polish, multi-diagram projects, SQL generation, SQL import, auto-layout, branding, and XMI 2.1 round-trip.
View the full changelogUser Guide — every panel, every workflow
Step-by-step walkthrough — welcome screen, toolbox, canvas, properties panel, multi-diagram projects, table designer, SQL generation and import, XMI export and import, exporting to PNG / SVG / PDF, and keyboard shortcuts.
Read the User GuideFeatures
📐 ER, Class, Process & Sequence Diagrams
Full UML shape catalog — entities, weak entities, attributes, multivalued / derived attributes, relationships, classes (regular / abstract / interface / enum), processes (start / end / task / gateway / data object / data store), and sequence lifelines with activations and combined fragments.
🧰 Toolbox with Search & Recents
Left sidebar with a tab per diagram type, a search box that flat-filters every shape by name, and a Recently used section so your common shapes are always close at hand. Click to drop at the centre of the view or drag onto the canvas.
🗂️ Multi-Diagram Projects
One project, many diagrams — an ER diagram, a class diagram, and a flowchart all in one .umlproj. Tab strip above the canvas to switch; Model Explorer shows the project tree (diagrams → elements) and you can double-click any element to jump to it.
⚙️ Properties Panel — No Modal Dialogs
Right sidebar that follows your selection. Per shape: name, italic / abstract flags, stereotype, fill and border colour (swatches or hex), border style and thickness, font size. Per connection: label, routing, line colour and style, start / end arrowheads. Canvas: grid size, snap, background.
🗄️ SQL DDL Generation
Design tables with structured columns and generate a complete script for PostgreSQL, MySQL, SQL Server, or SQLite — correct identifier quoting, type mapping, and auto-increment per dialect. Live dialect switch, syntax-styled preview, copy or save as .sql.
📥 SQL Reverse Engineering
Paste a CREATE TABLE script or load a .sql file — ERPDesk parses tables, columns, primary keys and foreign keys, draws them on a new diagram, and lays them out automatically. Handles quoted / bracketed / back-ticked identifiers and the four supported dialects.
🔄 XMI 2.1 / UML 2.x Interchange
Export as OMG-standard XMI 2.1 + UML 2.x so other UML tools can read it — Visual Paradigm, Enterprise Architect, StarUML, Modelio, MagicDraw, ArgoUML. Lossless round-trip for ERPDesk: an extension block carries layout, colours, and full column metadata.
📏 Auto-Layout
A layered Sugiyama-style arrange that places nodes into columns by their distance along connections. Overlap-free, cycle-safe, and deterministic. One undoable click — reachable from the ⊞ Arrange toolbar button. Applied automatically to SQL imports, so reverse-engineered schemas come in tidy.
🖼️ Canvas with Snap, Zoom & Pan
Infinite grid (crisp 1px at any zoom), Ctrl + scroll to zoom to the cursor, middle-drag to pan, rubber-band multi-select, eight-handle resize. Fit-to-screen and reset-zoom in one click; the current zoom is always shown at the bottom-right.
🚀 5 Starter Templates
The welcome screen offers Blank, Basic ER, Basic Class Diagram, Basic Flowchart, Basic Sequence, and the SQL Schema starter — two linked tables ready to export as a DDL script.
🎨 Export: PNG, SVG, PDF
Save your diagram as a high-resolution PNG, a scalable SVG, or a single-page PDF — or export just the selected shapes as PNG, or Copy as Image to paste straight into another app.
⏪ Undo / Redo & Auto-Save
Bounded undo / redo (capacity 100) covering every structural and property change. Auto-save every couple of minutes to a recovery file. The title bar shows an asterisk for unsaved changes, and ERPDesk asks Save / Don't Save / Cancel before discarding work.
🌓 Light & Dark Themes
Toggle from the View menu — persisted across launches. Chrome follows the theme; the canvas keeps the document's own paper background. Press ? any time for the keyboard cheat sheet.
🔌 Offline & Private
Runs 100% offline — no telemetry, no cloud, no accounts. Settings live in %AppData%\ERPDesk; auto-save lands in %TEMP%.
Screenshots
Welcome screen & templates
ER diagram with SQL preview
Class diagram editor
Multi-diagram tab strip & Model Explorer
Latest Release
Version 1.0
Canvas engine, full shape catalog, properties panel, toolbox, multi-diagram projects, SQL generation across four dialects, SQL reverse engineering, auto-layout, XMI 2.1 round-trip, and PNG / SVG / PDF export.