Navicat Data Modeler is a powerful and cost-effective database design tool that helps users create high-quality conceptual, logical, and physical data models. Allow you to visually design database structures, execute reverse or forward engineering programs, import models from ODBC data sources, generate complex SQL/DL, and print models to files.

With just one click, the process of creating complex entity relationship models and generating SQL scripts can be simplified. Navicat Data Modeler supports various database systems, including MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite.

Database objects

Use a professional object designer to create, modify, and design your model for tables and views. You don't need to write complex SQL to create and edit objects, you will know what options you are using. In addition, Navicat Data Modeler supports three standard symbols: Crow's Foot, IDEF1x, and UML. A feature rich, easy-to-use, and user-friendly drawing tool that allows you to create a complete data model with just a few clicks.

Model type

Navicat Data Modeler enables you to build high-quality conceptual, logical, and physical data models for a variety of people. By using the model transformation function, you can convert a conceptual business level model into a logically associated database model, and then convert it into a physical database. From drafting your system design outline, to viewing relationships and setting properties and fields for entities, tables, and views linked. You can easily configure precise changes to the database structure and create organized and more efficient database systems.

reverse engineering

Reverse engineering is one of the main features of Navicat Data Modeler. Load the existing database structure and create a new ER chart. You can visualize the database model and see how elements are interrelated, such as attributes, relationships, indexes, unique keys, comments, and other objects, without displaying actual data. Navicat Data Modeler supports multiple different databases: direct connection, ODBC, MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite.

Comparison and synchronization

The synchronization to database function allows you to fully understand the differences among all databases. After the comparison is completed, you can view the differences and generate synchronization scripts to update the target database to match your model. Flexible settings allow for customized options for comparison and synchronization.

SQL code generation

Navicat Data Modeler is not only a tool for creating ER charts and designing databases. Its SQL export function also allows you to have complete control over the final SQL script and generate various parts of the model, referencing integrity rules, annotations, character sets, etc., saving you work time.

Standard design tools

The ability to add vertices, layers, images, shapes, notes, and labels, align or distribute objects, undo or redo infinitely, automatically adjust layouts, search filters, and more.

1. choice
2. move
3. surface
4. view
5. Foreign key
6. label
7. note
8. image
9. shape
10. layer
11. automatic
12. Adjust the layout

Navicat Collaborative Collaboration

Navicat Data Modeler is fully integrated with our cloud solution. Synchronize your models and virtual groups to the cloud for real-time access anytime, anywhere. With Navicat collaboration, you can make the most of every minute and second of the day to maximize your work efficiency.