A desktop app for designing database schemas visually. Draw tables, connect columns, and export the result as SQL for PostgreSQL, MySQL, MariaDB, SQLite or SQL Server.
- Visual editor: drag tables, connect columns by dragging between them, reconnect a relationship by dragging either end, auto layout, minimap, search, notes on the canvas.
- Schema detail: primary keys, unique and nullable flags, defaults, comments, enum types, multi-column indexes, one-to-one and many-to-one relationships with ON DELETE / ON UPDATE actions, and a one-click junction table for many-to-many.
- Five engines: each design targets PostgreSQL, MySQL, MariaDB, SQLite or SQL Server. Changing the engine converts column types and defaults.
- SQL in and out: export a script for any supported engine, or import
CREATE TABLEscripts to draw an existing schema. - Images: export the diagram as PNG or SVG.
- Plain files: every project is one readable JSON file in a folder you choose.
- Issue checker: the status bar lists problems that would break the exported SQL, such as duplicate names or mismatched key types.
Download the installer from the latest release:
Joinery_<version>_x64-setup.exe— the recommended installerJoinery_<version>_x64_en-US.msi— for managed deployments
The installers are not code-signed, so Windows SmartScreen shows a warning the first time. Choose More info → Run anyway. docs/signing.md explains the options for signing, including the free ones.
Joinery is built and tested on Windows 10 and 11. It needs the WebView2 runtime, which is already part of Windows 11 and current Windows 10.
See the user guide and the keyboard shortcuts. Press ? in the editor for the shortcut list.
On first launch Joinery asks where to keep projects; the default is Documents\Joinery. Each project gets its own folder containing a single project.joinery.json. You can move a project, open one from any folder, or change the default folder in Settings. The format is described in docs/file-format.md.
Requirements: Bun, Rust and the Tauri prerequisites for Windows.
bun install
bun run tauri dev # run the app with hot reload
bun test # unit tests, including SQL run on SQLite and PostgreSQL
bun run typecheck
bun run tauri build # installers in src-tauri/target/release/bundleMore in docs/development.md, including how releases are made.
See CHANGELOG.md.
