Navicat Data Modeler
Mac OS Developer Tools
Navicat Data Modeler 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.
Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc.
With Navicat Data Modeler'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.0 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.
- Reverse engineering
With the reverse engineering feature, you can create models from existing databases with just a few simple clicks. Using a step-by-step wizard, you can import existing database structures and create models from different sources such as MySQL, MariaDB, SQL Server, PostgreSQL, Oracle, SQLite, and even from an ODBC data source. The resulting models graphically show the structure of a database so that you can see and organize data elements, such as tables, views and relations without showing the actual data.
- Forward engineering
With the forward engineering feature, your visual data model can be transformed into a physical database on any servers supported by Navicat Data Modeler - MySQL, MariaDB, SQL Server, PostgreSQL, Oracle and SQLite. You can also compare your model with a live database to capture the differences in objects and properties, so that you can get a full analysis before expanding and upgrading your existing system. Additionally, you can export a model directly to DDL script to streamline the process of writing SQL statements.
- Navicat Cloud
Navicat provides users with our Navicat Cloud service. Sync your models and virtual groups to the cloud so you can get real-time access to them anytime, anywhere.
Other useful features
- Crow's Foot, IDEF1x and UML Notations
- Add Vertices, Layers, Images, Shapes and Notes/Labels
- Auto Layout
- 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:
- New user interface design
- Support 3 model types - Physical, Logical and Conceptual.
- Support MariaDB databases.
- Support Views in Physical Model.
- Support Model Conversion.
- Support to sync model files and virtual group information to Navicat Cloud.
- Support adding shapes.
- Enhanced Table Designer