***** 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.20

- Support MySQL 8.0 default authentication plugin
- Bug fixes and stability improvements

Ratings and Reviews


Couldn’t do anything

Once I downloaded this application, I created a “project.” The only thing I could do was give the project a name, I couldn’t add any data or tables—nothing on any of the menus allowed me to do anything at all. I decided to quit…then discovered I could not quit the application. Quit was not an option from the main menu, though it was an option from the dock…which didn’t close the application. I had to click command, option, escape to pull up a the list of my open applications and do a force quit. I removed this application from my computer. If I missed something, then it should be much clearer how to use this application. The help menu was just the logo. I clicked on the title which looked like a link…nothing.


Crashes Constantly! Lost a full day of work!

This tool has an awesome interface. However, it crashes constantly and has lost my information twice. Using OSX High Sierra


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.


PremiumSoft CyberTech Ltd.
112.9 MB
Developer Tools
OS X 10.8 or later, 64-bit processor
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