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.
Create, modify, and design your models using professional object designers, available for Tables and Views. Without the need to write complex SQL to create and edit objects, you’ll know exactly what you are working on. Also, Navicat Data Modeler supports three standard notations: Crow’s Foot, IDEF1x and UML. Using our feature-rich, simple, and user-friendly drawing tools, you can develop a complete data model with just a few clicks.
Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Using the Model Conversion feature, you can convert a conceptual business-level model into a logical relational database model and then into a physical database implementation. From sketching a big picture of your system design to viewing relationships and working with attributes and columns from linked entities, tables and views. You can easily deploy accurate changes to database structures and build organized and more effective database systems.
Reverse Engineering is one of the key features of Navicat Data Modeler. Load existing database structures and create new ER diagrams. Visualize database models so you can see how elements such as attributes, relationships, indexes, uniques, comments, and other objects relate to each other without showing actual data. Navicat Data Modeler supports different databases: Direct connection, ODBC (*Only for Windows and macOS Edition), MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite.
Comparison and Synchronization
The Synchronize to Database function will give you a full picture of all database differences. Once your databases are compared, you can view the differences and generate a synchronization script to update the destination database to make it identical to your model. Flexible settings enable you to set up a custom key for comparison and synchronization.
SQL Code Generation
Navicat Data Modeler is not only a tool for creating ER diagrams and designing your databases. Its Export SQL feature also gives you full control over the final SQL script and allows you to generate individual parts of your model, referential integrity rules, comments, character sets, etc., potentially saving you hundreds of hours of work.
Standard Designing Tools
Add vertices, layers, images, shapes, and notes/labels, align/distribute objects, unlimited undo/redo capacity, auto layout, search filter, and more.