Feature Matrix
| Standard | Enterprise | |
| Connection | ||
| SQLite 2 and 3 |  |  |
| Secure connection: HTTP Tunnel | | |
| Centralized connection management | | |
| Connection profiles | | |
| Customize connection colorings | | |
| Export/import connection settings | | |
| Navicat Collaboration | ||
| Collaboration: create projects, add members | | |
| Synchronize connection settings, queries, snippets and virtual group information | | |
| Synchronize BI workspaces and model workspaces | | |
| Data Viewer and Editor | ||
| Grid view | | |
| Form view | | |
| Data profiling | | |
| Text, hex, image or web viewer and editor | | |
| Foreign key data selection | | |
| Filter and sort | | |
| Table profile | | |
| Find and replace | | |
| Query Processing | ||
| Query editor with syntax highlight | | |
| Code completion | | |
| Code snippet | | |
| Query builder | | |
| Visual explain | | |
| Pin query result | | |
| SQL beautifier and minifier | | |
| Find and replace | | |
| Create parameter queries | | |
| Console | | |
| Object Designer | ||
| Database object design tools | | |
| View builder | | |
| SQL preview | | |
| AI Assistant | ||
| ChatGPT, Deepseek, Google Gemini, Ollama, xAI Grok, Anthropic Claude, Alibaba Qwen | | |
| Attach database structures | | |
| Compare and contrast responses from multiple AI models | | |
| Multiple chat rooms | | |
| Ask AI | ||
| Explain SQL queries | | |
| Tune and optimize SQL queries | | |
| Format and beautify SQL queries | | |
| Convert SQL queries for different databases | | |
| Customize and pin AI actions for quick access | | |
| Find and fix SQL errors | | |
| BI | ||
| Over 20 chart type options | | |
| Visualize live data | | |
| Customized fields | | |
| Customize multiple pages dashboard | | |
| Add interactive controls | | |
| Present mode | | |
| Model | ||
| Physical model | | |
| Relational, dimensional and data vault 2.0 model method | | |
| Reverse database to model | | |
| Synchronize database to model | | |
| Synchronize model to database | | |
| Export model to SQL file | | |
| Compare model workspaces | | |
| Auto layout | | |
| Add vertices, layers, images, notes, labels and shapes | | |
| Print database diagrams to PDF and graphic files | | |
| Import and Export | ||
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON | | |
| Import data from ODBC, MS Excel, MS Access, DBF | | |
| Export data to MS Excel, DBF | | |
| Export data to MS Access (Windows Edition only) | | |
| Structure and Data Manipulation | ||
| Data transfer | | |
| Data synchronization | | |
| Data generation | | |
| Data dictionary | | |
| Copy and paste data across databases | | |
| Backup and Restore | ||
| Backup/restore database | | |
| Convert backup file into SQL script | | |
| Dump/execute SQL file | | |
| Automation | ||
| Set schedule on : query, backup, data transfer, data synchronization, data generation, data dictionary, BI, model, import, export | | |
| Run profiles from different servers in a single batch job | | |
| Include attachment for export file in notification email | | |
| Server Security | ||
| Manage user | | |
| Other Useful Features | ||
| ER diagram view | | |
| Open object via URI | | |
| Virtual grouping | | |
| Database wide search | | |
| Favorites list | | |
| Focus mode | | |
| Dark mode | | |
Connection
| SQLite 2 and 3 |
Enterprise  Standard  |
| Secure connection: HTTP Tunnel |
Enterprise Standard |
| Centralized connection management |
Enterprise Standard |
| Connection profiles |
Enterprise Standard |
| Customize connection colorings |
Enterprise Standard |
| Export/import connection settings |
Enterprise Standard |
Navicat Collaboration
| Collaboration: create projects, add members |
Enterprise Standard |
| Synchronize connection settings, queries, snippets and virtual group information |
Enterprise Standard |
| Synchronize BI workspaces and model workspaces |
Enterprise |
Data Viewer and Editor
| Grid view |
Enterprise Standard |
| Form view |
Enterprise Standard |
| Data profiling |
Enterprise Standard |
| Text, hex, image or web viewer and editor |
Enterprise Standard |
| Foreign key data selection |
Enterprise Standard |
| Filter and sort |
Enterprise Standard |
| Table profile |
Enterprise Standard |
| Find and replace |
Enterprise Standard |
Query Processing
| Query editor with syntax highlight |
Enterprise Standard |
| Code completion |
Enterprise Standard |
| Code snippet |
Enterprise Standard |
| Query builder |
Enterprise Standard |
| Visual explain |
Enterprise Standard |
| Pin query result |
Enterprise Standard |
| SQL beautifier and minifier |
Enterprise Standard |
| Find and replace |
Enterprise Standard |
| Create parameter queries |
Enterprise Standard |
| Console |
Enterprise Standard |
Object Designer
| Database object design tools |
Enterprise Standard |
| View builder |
Enterprise Standard |
| SQL preview |
Enterprise Standard |
AI Assistant
| ChatGPT, Deepseek, Google Gemini, Ollama, xAI Grok, Anthropic Claude, Alibaba Qwen |
Enterprise Standard |
| Attach database structures |
Enterprise Standard |
| Compare and contrast responses from multiple AI models |
Enterprise Standard |
| Multiple chat rooms |
Enterprise Standard |
Ask AI
| Explain SQL queries |
Enterprise Standard |
| Tune and optimize SQL queries |
Enterprise Standard |
| Format and beautify SQL queries |
Enterprise Standard |
| Convert SQL queries for different databases |
Enterprise Standard |
| Customize and pin AI actions for quick access |
Enterprise Standard |
| Find and fix SQL errors |
Enterprise Standard |
BI
| Over 20 chart type options |
Enterprise |
| Visualize live data |
Enterprise |
| Customized fields |
Enterprise |
| Customize multiple pages dashboard |
Enterprise |
| Add interactive controls |
Enterprise |
| Present mode |
Enterprise |
Model
| Physical model |
Enterprise |
| Relational, dimensional and data vault 2.0 model method |
Enterprise |
| Reverse database to model |
Enterprise |
| Synchronize database to model |
Enterprise |
| Synchronize model to database |
Enterprise |
| Export model to SQL file |
Enterprise |
| Compare model workspaces |
Enterprise |
| Auto layout |
Enterprise |
| Add vertices, layers, images, notes, labels and shapes |
Enterprise |
| Print database diagrams to PDF and graphic files |
Enterprise |
Import and Export
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON |
Enterprise Standard |
| Import data from ODBC, MS Excel, MS Access, DBF |
Enterprise Standard |
| Export data to MS Excel, DBF |
Enterprise Standard |
| Export data to MS Access (Windows Edition only) |
Enterprise Standard |
Structure and Data Manipulation
| Data transfer |
Enterprise Standard |
| Data synchronization |
Enterprise Standard |
| Data generation |
Enterprise Standard |
| Data dictionary |
Enterprise Standard |
| Copy and paste data across databases |
Enterprise Standard |
Backup and Restore
| Backup/restore database |
Enterprise Standard |
| Convert backup file into SQL script |
Enterprise Standard |
| Dump/execute SQL file |
Enterprise Standard |
Automation
| Set schedule on : query, backup, data transfer, data synchronization, data generation, data dictionary, BI, model, import, export |
Enterprise Standard |
| Run profiles from different servers in a single batch job |
Enterprise Standard |
| Include attachment for export file in notification email |
Enterprise Standard |
Server Security
| Manage user |
Enterprise Standard |
Other Useful Features
| ER diagram view |
Enterprise Standard |
| Open object via URI |
Enterprise Standard |
| Virtual grouping |
Enterprise Standard |
| Database wide search |
Enterprise Standard |
| Favorites list |
Enterprise Standard |
| Focus mode |
Enterprise Standard |
| Dark mode |
Enterprise Standard |
