Navicat Data Modeler 5
Developer Tools
Only for Mac
Free · In‑App Purchases
Mac
Navicat Data Modeler is a visual database design tool built to support data governance. Enforce schema consistency, build entity-relationship diagrams, reverse-engineer live databases, and generate target SQL across your data stack.
Supports MySQL, PostgreSQL, MongoDB, MariaDB, SQL Server, Oracle, SQLite, and Snowflake.
Unified Model Types & Hybrid Workspace
Work across conceptual, logical, and physical models in one workspace, and keep them aligned.
- Hybrid Model Canvas: Design logical entities and physical objects like tables, views, and functions side-by-side on the same canvas.
- Model Mapping: Align a logical design with the physical schema so both stay in sync.
- Model Conversion: Convert a conceptual model to logical, then to physical.
Model Methods
Design for transactional systems and data warehouses.
- Three Methodologies: Relational, Dimensional, and Data Vault 2.0.
- Visual Modeling: Map the structure on the canvas so the method stays readable.
Naming Standards & Glossary
Strengthen data governance while keeping names consistent across models and teams.
- Auto Formatting: Draft with business terms. Navicat applies your casing, separators, and prefixes.
- Shared Glossary: Keep standard definitions on the canvas for business and engineering.
- Import & Export: Share glossaries across projects as CSV.
Model Design
AI-Powered Design - Build, optimize, and debug database structures with AI.
- Create Tables: Type simple instructions to build complete tables with auto-configured column names and data types.
- Optimize Tables: Analyze existing structures to suggest missing fields, recommend indexes, audit data types, and auto-fill comments.
- Debug Views: Find and fix errors automatically. Scan your code to detect and fix typos, syntax errors, and complex logic bugs.
Database Objects - Design database structures on a visual canvas.
- Object Design: Built-in visual designers for Tables, Collections, Views, Functions, Procedures, and more.
- Notations: Crow’s Foot, IDEF1X, and UML.
Interactive Table Design - Rearrange table structures on the canvas.
- Create Tables: Drag fields onto the canvas to create a new table.
- Move Fields: Drag fields between tables.
- Duplicate Fields: Hold Ctrl or Cmd while dragging to copy a field.
Bulk Editor
View fields in a hierarchical list. Filter them, and batch-edit properties across multiple tables.
Design & Canvas Tools
Design your diagram in a responsive and interactive environment.
- Vertices, layers, images, notes, labels and shapes
- Auto layout
- Locking/grouping objects
- Align/distribute objects
- Connector line
- Copying SQL from diagram objects
Data Dictionary
Strengthen data governance with audit-ready documentation. Easily generate customizable templates, automate PDF exports, and share metadata reports with stakeholders to maintain compliance.
Reverse Engineering
Rebuild a model from a live database or from SQL.
- Reverse Database to Model: Connect with a native driver or ODBC. Generate an ER diagram from the live schema and relationships. Structure only. No data is pulled.
- Import SQL to Model: Paste DDL or import a .sql file. Build a new diagram, or add to one you already have.
Export Model to SQL File
Generate DDL for the whole model, or a selected subset. Set referential integrity rules, comments, and character sets.
Compare Model Workspace
Compare two model workspaces side by side. Highlight structural differences across team copies or design branches.
Navicat Collaboration
Sync model workspaces to Navicat Cloud or Navicat On-Prem Server so the team works from one copy.
Other useful features
- Code completion and snippet
- SQL beautifier
- Virtual grouping
- Search filter
Note: Try Navicat free for 14 days with full app access. Your trial will automatically convert to a paid subscription unless canceled 24 hours before it ends.
Terms of Use: https://www.navicat.com/manual/online_manual/en/navicat_data_modeler_5/mac_manual/#/license_agree
Ratings & Reviews
- This app hasn’t received enough ratings or reviews to display an overview.
- Hybrid Model : Bridge logical entities and physical structures within a single model.
- Naming Standards & Glossary : Support centralized glossaries and standardized naming rules across schemas.
- Bulk Editor : View and edit fields across multiple tables simultaneously.
- Import SQL to Model : Generate data models directly from SQL scripts.
- New Table Actions : Move fields between tables and create new tables directly on the canvas.
- Alignment Guide : Visual snapped alignment guides for canvas object positioning.
- And More.
The developer, PremiumSoft CyberTech Ltd., indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .
Data Not Linked to You
The following data may be collected but it is not linked to your identity:
- Usage Data
- Diagnostics
Accessibility
The developer has not yet indicated which accessibility features this app supports. Learn More
Information
- Seller
- PremiumSoft CyberTech Ltd.
- Size
- 375.9 MB
- Category
- Developer Tools
- Compatibility
Requires macOS 14.6 or later.
- Mac
Requires macOS 14.6 or later.
- Mac
- Languages
English and 11 more
- English, French, German, Indonesian, Japanese, Korean, Polish, Russian, Simplified Chinese, Spanish, Thai, Traditional Chinese
- Age Rating
4+
- 4+
- In-App Purchases
Yes
- Monthly Subscription $37.99
- Yearly Subscription $379.99
- Copyright
- © 2026 PremiumSoft CyberTech Ltd.