ER Studio - Data Modeler

Design at the Speed of Thought. The ER Diagram Editor Crafted for Mac. Tired of wrestling with spreadsheets and messy lines? Just drop entities onto the canvas and drag to connect. A beautiful, precise data model is ready in seconds. 【INTUITIVE CANVAS】 ・ Freely place and drag entities with smooth, spring animations ・ New entities automatically avoid overlapping ・ Click background to clear selection, selected items are highlighted ・ Add new entities instantly from the toolbar button or right-click menu 【FLEXIBLE ENTITIES & ATTRIBUTES】 ・ Double-click or use the sidebar to rename entities ・ Entity width auto-resizes from 150 to 500 to fit your content ・ Add attributes with one click, double-click to rename ・ 5 essential data types: INTEGER, DECIMAL, DATE, TIME, TEXT ・ Full support for composite primary keys. Set or remove with one click, primary keys are bolded and sorted to the top ・ Deleting an attribute automatically cleans up related relationships 【BEAUTIFULLY CONNECTED RELATIONSHIPS】 ・ Drag from the right handle of any attribute to connect with smooth bezier curves ・ Classic crow's foot notation instantly shows primary & foreign key relationships ・ Click to select and highlight any relationship, right-click to delete ・ Automatically connects from the optimal side based on entity positions 【TOTAL CONTROL WITH THE NEW INSPECTOR SIDEBAR】 ・ Select any entity or relationship to edit it directly in the sidebar ・ Entity Inspector: Manage all attributes in a table - name, data type, primary key toggle, and delete ・ Relationship Inspector: Change source and target entities and attributes via dropdowns - no need to redraw ・ Swap direction with one click ・ View, manage and add multiple relationships between the same entities in one place ・ Toggle sidebar visibility from the toolbar (⌥⌘0) 【FROM DIAGRAM TO SHAREABLE SCHEMA】 ・ Generate a reference SQL-like schema in one click ・ Exports CREATE TABLE and ALTER TABLE ... ADD FOREIGN KEY statements ・ Correctly handles composite PRIMARY KEY and FOREIGN KEY constraints ・ Safely quotes Japanese and special characters with "" ・ Copy to clipboard or save as a .sql file ・ Available from the toolbar or menu (Shift+Cmd+E) ・ *This is a reference pseudo-schema for documentation and sharing, not executable SQL for a specific database 【SIMPLE & PRIVATE FILE MANAGEMENT】 ・ Save and open your diagrams as .erdata files (Cmd+O / Cmd+S / Shift+Cmd+S) ・ Includes sample entities to explore right after launch ・ Automatically converts legacy data types for compatibility Get started right away and explore all diagramming features. Love it? Unlock file saving forever with a single one-time purchase. Your data stays private on your Mac.

Developer Tools · iPhone, iPad · Free

Screenshots

ER Studio - Data Modeler screenshotER Studio - Data Modeler screenshotER Studio - Data Modeler screenshotER Studio - Data Modeler screenshot

Download