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, PostgreSQL, MongoDB, MariaDB, SQL Server, Oracle, SQLite, and Snowflake. Models Workspace Integrate various database types to create multiple models in a single workspace enables you to illustrate different model objects in one diagram. You can efficiently switch between models, perform cross-model management, and share workspaces to foster collaboration and improve overall productivity. Design Tools Design your diagram in a responsive and interactive environment. It includes various diagramming styles and approaches, supporting different types of models, notations, and representations. We keep everything simple and concise so that you can concentrate on your model design. Model Methods Design complex data systems for various applications using Relational, Dimensional, and Data Vault 2.0 methodologies. You can create robust and scalable data structures tailored to specific business requirements, bringing structure and meaning to the data and enabling insightful analysis. Reverse Engineering Create models from existing databases in just a few clicks. Use a step-by-step wizard to import structures from sources like MySQL, MariaDB, SQL Server, PostgreSQL, Oracle, MongoDB, SQLite, Snowflake, and even from an ODBC data source. The resulting models visually represent the database structure, allowing you to organize elements like tables, views, functions and procedures without displaying actual data. Synchronize Database to Model Compare and update your model based on changes made in the actual database, ensuring that the model accurately reflects the current database structure. By synchronizing regularly, you can avoid discrepancies between the model and the database, keeping them up-to-date and aligned to maintain the integrity of the model. Compare Model Workspaces Find and highlight all the differences between model workspaces in minutes to swiftly identify any variances or inconsistencies. Align with your model design needs to ensure consistency across different versions or branches of the model, ultimately enhancing the quality of your models throughout the development and deployment process. Navicat Collaboration Sync your model files and virtual groups to the cloud for a real-time access at anytime and anywhere. With Navicat Collaboration, you can leverage every minute of your day to maximize your productivity. Other useful features - Model conversion: conceptual, logical and physical - Crow's Foot, IDEF1x and UML notations - Code completion and snippet - SQL beautifier - Add vertices, layers, images, notes, labels and shapes - Auto layout - Locking/grouping objects - Align/distribute objects - Connector line - Unlimited undo/redo - Zoom in/zoom out - Copying SQL from diagram objects - Data dictionary - Virtual grouping - Search filter - Export SQL/DDL - Present mode - Focus mode - Dark mode Note: Try Navicat free for 14 days with full app access. Your trial will automatically convert to a paid subscription unless canceled 24 hours before it ends. Terms of Use: https://www.navicat.com/manual/online_manual/en/navicat_data_modeler_4/mac_manual/#/license_agree
