Navicat Data Modeler is a powerful and cost-effective database design tool that helps users create high-quality conceptual, logical and physical data models. Enable you to visually design database structures, execute reverse or forward engineering programs, import models from ODBC data sources, generate complex SQL/DDL, 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

Create, modify, and design your model using a professional object designer, suitable 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 versatile, 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. Using the model transformation function, you can convert a conceptual business level model into a logical relational database model, and then convert it into a physical database. From drafting your system design outline to viewing relationships and setting attributes and fields for linked entities, tables, and views. 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 related to each other, such as attributes, relationships, indexes, unique keys, annotations, and other objects, without displaying actual data. Navicat Data Modeler supports a variety of different databases: direct connection, ODBC, MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite.

Comparison and synchronization

The synchronization to database function provides you with a comprehensive understanding of the differences between 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 that allow for custom options for comparison and synchronization.

SQL code generation

Navicat Data Modeler is not only a tool for creating ER charts and designing databases. Its export SQL function also allows you to fully control the final SQL script, and generate all parts of the generative model, reference integrity rules, comments, character sets, etc., which can save your working time.

Standard design tools

Add vertices, layers, images, shapes, notes, and labels, align or distribute objects, have the ability to undo or redo infinitely, automatically adjust layout, search and filter, and more.

• choice
• move
• surface
• view
• Foreign key
• label
• note
• image
• shape
• layer
• automatic
• Adjusting the layout

Navicat 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 collaborative collaboration, you can make the most of every minute of the day to maximize your work efficiency.