Design tables on the diagram and apply the DDL
Draw tables, columns, keys and relationships on the ER canvas, preview the CREATE and ALTER statements against the live schema in your dialect, and apply them in one transaction.


The ER canvas for a SQL schema, with keys and relationships drawn from the catalog.
What you can do with it
Reverse and forward
Open any schema as a diagram, then add and edit tables, columns, keys and relationships on it.
DDL you can read first
The dialect's CREATE and ALTER statements are previewed against the live schema before anything runs.
One transaction
Applied in one transaction where the engine allows it, with the production confirmation, read-only refusal and audit.
From documents to tables
MongoDB's Data Model plans SQL tables from analyzed collections (child tables for arrays, foreign keys for references) and opens them in design mode.
Export
PNG and SVG images of the diagram.
Related features
Your next query deserves a better IDE.
Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.