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.2
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, connecting shapes and turning a link into a real foreign key, the table designer, live SQL, 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 & Live Panel
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. A live SQL panel docks under the canvas and regenerates as you edit, so you can see what a change does to your schema without opening a dialog. DROP TABLE IF EXISTS and CREATE INDEX on foreign-key columns are export options, and tables spread across several diagrams can be written as one script.
📥 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.
🔗 Draw a Link, Get a Foreign Key
Draw a line between two Table shapes and ERPDesk offers to turn it into a real foreign key — pick an existing child column or let it create a conventionally-named one, choose the column it references, and say whether it is required. One undo step, and it appears in your generated SQL rather than only on the diagram. Choose Just draw the line if you only want the picture.
📐 Align, Distribute & Nudge
Align, distribute and make-same-size for any multi-selection, with the same commands in the Edit menu, the canvas right-click menu and the Properties panel — which now stays open when more than one shape is selected, so appearance edits apply to all of them at once. Nudge with the arrow keys, hold Shift for a coarser step, and Fit to content sizes a shape to its own rows.
🌓 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
SQL schema diagram
ER diagram with relationships
Class diagram editor
Latest Release
Version 1.2 — September 1, 2026
1.1 closed a full audit of the app — 20 correctness bugs, 3 dark-mode defects and 14 workflow gaps — including drag-to-connect, which was the only way to create a connection and never worked, exports that baked in the selection handles, and a Properties panel where nothing was undoable. Dark mode went from half-done to complete. Alongside it: drawing a link between two tables now offers to make it a real foreign key that reaches the generated DDL, a live SQL panel sits under the canvas, and the interface had a proper pass. 1.2 then fixed an unreadable Model Explorer selection and a packaging script that stamped the wrong version.