***** Navicat Data Modeler is Finalist of 2016 DBTA Reader's Choice “Best Data Modeling Solution *****

Navicat Data Modeler Essentials is a powerful and easy-to-use database design tool for creating and manipulating data models. It supports various database systems, including MySQL, MariaDB, Oracle, SQL Server, PostgreSQL and SQLite.

With Navicat Data Modeler Essentials's features, users can easily create high quality data models and understand database structures.

- Three types of data models: Conceptual, Logical, and Physical
A well-designed model increases both efficiency and data quality, and can be easily understood by a wide variety of audiences. Navicat Data Modeler 2.1 enhances communication and collaboration between business and information-technology professionals by providing the ability to design conceptual, logical, and physical models. You can draw your own shapes, lines and labels using the comprehensive range of drawing tools to enrich your model design.

- Navicat Cloud
Sync your models and virtual groups to the cloud so you can get real-time access to them anytime, anywhere. With Navicat Cloud Collaboration, you can create, organize and share files/projects with your coworkers from anywhere, on any device.

You can take control of your project -- adding members you choose, defining the role of each member, and get visibility into your team activities from the Activity Log to align your team for greater productivity.

Other useful features
- Crow's Foot, IDEF1x and UML Notations
- Add Vertices, Layers, Images, Shapes and Notes/Labels
- Align/Distribute Objects
- Unlimited Undo/Redo
- Zoom in/Zoom out
- Model Conversion
- Full Screen Mode
- Virtual Grouping
- Search Filter

* For more detailed information, please visit:

** For technical questions related to the Mac App Store, please visit:

What's New

Version 2.1.18

Bug fixes and improvements

Ratings and Reviews

Product is unusable for existing databases


While the app is visually appealing, it currently has a serious show-stopper if you want to use it to document an existing MSSQL database. It currently has no way to create a primary key on a table and set it as an identity field. That by itself could be worked around as long as you could make the setting in SSMS, but the app also can’t update an existing model. You have to create it from scratch each time you make a change in the actual db. This prevents you from doing anything other than auto-generating your model if you intend to use it in conjunction with the actual db.

Hopefully a fix is forthcoming.

Just Meh.


For the fact that this is the only DB modeler on the App Store (I could find), this is still terrible. For me, I find that all DB Modelers should work just like MySQL Workbench. I don’t always use MySQL, but I can use Workbench regardless. I can’t find a good reason to keep this on my Mac. The interface isn’t very intuitive. Context menus appear in random locations on screen. The tables and notes are clunky.

Problems with Foreigh Key dialog


This version has a problem with the foreign key diaolog. It stores links the wrong tables and fields, making the foreign keys unusable, when you have more than one foreign key in a table. Hope to get an update soon for this.


PremiumSoft CyberTech Ltd.
111.2 MB
Developer Tools
English, French, German, Korean, Polish, Portuguese, Russian, Simplified Chinese, Spanish, Traditional Chinese
Age Rating
Rated 4+
© 2017 PremiumSoft CyberTech Ltd


  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.

More By This Developer