Navicat Data Modeler is a visual database design tool built to support data governance. Enforce schema consistency, build entity-relationship diagrams, reverse-engineer live databases, and generate target SQL across your data stack.
Supports MySQL, PostgreSQL, MongoDB, MariaDB, SQL Server, Oracle, SQLite, and Snowflake.
Hybrid Model Canvas:
Design logical entities and physical objects like tables, views, and functions side-by-side on the same canvas.
Model Mapping:
Align a logical design with the physical schema so both stay in sync.
Model Conversion:
Convert a conceptual model to logical, then to physical.
Three Methodologies:
Relational, Dimensional, and Data Vault 2.0.
Visual Modeling:
Map the structure on the canvas so the method stays readable.
Auto Formatting:
Draft with business terms. Navicat applies your casing, separators, and prefixes.
Shared Glossary:
Keep standard definitions on the canvas for business and engineering.
Import & Export:
Share glossaries across projects as CSV.
Build, optimize, and debug database structures with AI.
Type simple instructions to build complete tables with auto-configured column names and data types.
Optimize Tables:
Analyze existing structures to suggest missing fields, recommend indexes, audit data types, and auto-fill comments.
Find and fix errors automatically. scan your code to detect and fix typos, syntax errors, and complex logic bugs.
Design database structures on a visual canvas.
Object Design: Built-in visual designers for Tables, Collections, Views, Functions, Procedures, and more.
Notations: Crow’s Foot, IDEF1X, and UML.
Rearrange table structures on the canvas.
Create Tables: Drag fields onto the canvas to create a new table.
Move Fields: Drag fields between tables.
Duplicate Fields: Hold Ctrl or Cmd while dragging to copy a field.
View fields in a hierarchical list. Filter them, and batch-edit properties across multiple tables.
Connect with a native driver or ODBC. Generate an ER diagram from the live schema and relationships. Structure only. No data is pulled.
Paste DDL or import a .sql file. Build a new diagram, or add to one you already have.
Flatpak supported distributions.
Debian 10, Debian 11, Debian 12, Debian 13, Ubuntu 20.04, Ubuntu 22.04, Ubuntu 24.04, Ubuntu 26.04, Fedora 44, Linux Mint 20, Linux Mint 21, Linux Mint 22, Deepin 20, Deepin 23, Deepin 25, KylinOS Desktop 10, Pop!_OS 20.04, Pop!_OS 22.04
Debian 11, Debian 12, Debian 13, Ubuntu 22.04, Ubuntu 24.04, Ubuntu 26.04, Fedora 44, Linux Mint 20, Linux Mint 21, Linux Mint 22, Deepin 23, Deepin 25, KylinOS Desktop 10, Pop!_OS 20.04, Pop!_OS 22.04













