Navicat Data Modeler 3 4+

Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more.

Simplify the task of creating complex entity relationship models and generate the script SQL with a simple click. Navicat Data Modeler supports various database systems, including MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite.

Model Types: 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 3 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 Collaboration
Navicat Data Modeler is fully integrated with our cloud solution. Sync your model files and virtual groups to the cloud for a real-time access at anytime and anywhere. With Navicat Collaboration, you can leverage every minute of your day to maximize your productivity.

Other useful features
- Model Conversion
- 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
- Virtual Grouping
- Search Filter
- Full Screen Mode
- Dark Mode

Note: Try Navicat free for 14 days. This trial subscription includes full access to the Navicat app. Your trial will turn into a paid subscription automatically after the free trial ends. If you don't want to renew it, cancel it at least 24 hours before the end of your trial.

Terms of Use: https://www.navicat.com/manual/online_manual/en/navicat_data_modeler_3/mac_manual/#/license_agree