Database objects

Create, modify and create a model using professional tools, and most importantly, without the need for advanced knowledge of SQL. Thanks to the easy-to-use tools, you always know exactly what you are working on. In addition, Navicat Data Modeler provides three most important notation notations: Crow Foot, IDEF1x and UML. With our program you can create a professional model with just a few clicks.

Model types

Navicat Data Modeler enables you to create a high-quality and readable conceptual, logical or physical model for a wide audience. Using the model conversion option, you can quickly convert the business model into a technical model, and eventually into a physical model, including export to the database. The model is a general picture of the structure of the database, its tables, views and relations between its objects, which serves a much more effective organization of the database and makes the cooperation of many departments of the company much more efficient.

Mapping the database to the model

Mapping the database to the model is one of the key features of Navicat Data Modeler, thanks to which you will create an ER diagram based on the existing database structure. You can also create a completely new structure, all in an easy and fun way with the graphical editor. Thanks to the graphical representation of the database throughout the design time, you will see all relationships between tables, their attributes, indexes, uniques, comments and other objects depending on the selected database type. Navicat Data Modeler allows you to connect to MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, SQLite databases and to make direct connections or ODBC sources.

Compare and sync

Synchronization to the database is a function that will create the actual structure in the database based on the graphical model of the data structure. This is the inverse of data mapping. Additionally, synchronization to the database will first compare the current structure to the modified structure. You can also synchronize only designated tables or links.

SQL code generator

Navicat Data Modeler is not only a tool for visualizing the structure in the form of an ER diagram. The SQL code generation function gives you full control over the created data structure - you can individually adjust each of its elements: relations, comments, character set, etc. Thanks to this, you will save many hours of work.

Basic editing options

Add points, layers, images, shapes, comments, and labels, align objects, unlimited undo / redo, auto-arrange items, search filter and much more.

Choose

Transfer

Table

View

Key
foreign

Label

Comment

Image

Shape

Layer

Arrange
automatically

Navicat Data Modeler fully supports Navicat Cloud. Synchronize your model and virtual groups on any device and in any place. Thanks to the Navicat Cloud service, you can use every minute of your day to the full and productively.