Navicat Data Modeler is a graphical editor of database structures, with which you can easily and quickly create a structure of any complexity level. Using the program, you can create a data structure presentation also based on an ODBC connection, and also generate SQL / DDL code and much more. In addition, you can create different types of models, logical model, conceptual model, or physical model.
Create relationships in your database with a few clicks. Navicat Data Modeler supports many database systems: MySQL, MariaDB, Oracle, SQL Server, PostgreSQL and SQLite.
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â € ™ s 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.
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.
En
