Editing Start
Start from the welcome screen, and create tables, memos, table groups, and relationships from the canvas context menu.
Importing or Exporting Files
Import JSON, schema SQL, GraphQL, DBML, or AML in place of the diagram or added below it, and export JSON, schema SQL, or the diagram as a PNG or SVG image.
Table Editing
Add, select, reorder and delete columns, toggle column options, and copy or paste columns.
Table-related Functions
Select, move, copy, duplicate, and delete tables and memos, set colors and view options, define indexes and alternate keys, choose a database, get around the infinite canvas, and compare documents.
Table Groups
Gather related tables in a named, colored box behind them; create, name, color, move, resize, and remove groups, change which tables they hold, hide them, and carry them through Auto Layout, Schema SQL, and DBML.
Relationship Editing
Delete a relationship, change its type, set its ON DELETE and ON UPDATE actions, map it onto existing columns with Map Columns, read the connector notation, work with N:M and identifying relationships, and see how new foreign key columns are named.
Quick Search
Open the command palette to switch tabs, run a command for the current tab, open Find and Replace, change the theme or display language, or jump to a table, column, comment, or memo by typing a prefix.
Find and Replace
Find text in table and column names, comments, and memos, step through every match on the canvas, and replace one match or all of them.
Visualization
Explore the schema as a force-directed Graph or as a Flow of table cards — zoom and pan, light up a table's related tables, and focus on a few tables at a time.
Schema SQL
Read the diagram's DDL on the Schema SQL tab, pick the database, quoting, statements, header, and tables in its options panel, add your own scripts before and after the tables, and save or copy the SQL.
Code Generator
Generate code for twenty-two targets from the diagram, pick the language, database, name case and bracket in the options panel, see which targets write a relationship's ON DELETE and ON UPDATE actions, and save or copy the result.
Undo, Redo
Undo and redo edits, what the history records, and stepping through it with Time Travel.
Settings
Relationship data type sync, maximum comment width, table width recalculation, setting locks (view, tab, and code settings), column display order, and the shortcut list.
Language and Theme
The editor's 25 display languages, right-to-left layout, the theme builder's System, Light, and Dark appearances and its colors, and where each host keeps them.