On May 27, 2024, Navicat has released the latest version 17! In the latest version, Navicat has released new modeling capabilities, enhanced data visibility, and better and more intelligent empowerment for business decision-making. Now let's take a look at what this version update includes!

Model

Quick modeling and simplified execution

Creating multiple models in a workspace allows you to illustrate different model objects in a single chart, simplifying the browsing and understanding of complex systems. Additionally, support for functions/procedures allows you to predefined processes and operations during the model phase.

Fast and accurate design

Design your charts using various chart styles in a responsive and interactive environment. Arrange relevant elements in layers, lock or combine specific elements, apply automatic layout to selected elements, and rearrange connections. Experience faster and more efficient complex model design.

Seamless synchronization

Compare the model workspace and synchronize the database with the model, or perform reverse operations to automatically apply changes from one party to the other. Navicat ensures seamless integration between databases and models, keeping them up-to-date and consistent.

Data dictionary

Define and record your database

Create stunning documents for each database element using our new data dictionary tool. You can choose from a series of pre designed templates and customize them according to your preferences. Set up automated processes to export documents as PDFs and share them with stakeholders via email. The data dictionary can also be used in the model workspace.

Data analysis

Enhance data integrity

Integrate data analysis tools in the data viewer to provide a comprehensive view of your data. By providing a series of visual charts to display the analysis results, you can analyze the data types, formats, distributions, and statistical properties in the dataset.

You can interact with visual charts to further explore data, such as delving into specific data segments, filtering data based on certain criteria, or highlighting data points of interest. These interactions help you gain a deeper understanding of the data and the characteristics of each column of data.

Query

About queries, it's clear at a glance

Navicat has greatly improved its query interpretation capabilities. It supports various formats, including visualization JSON、 Interpretation of text and statistical plans for query execution. Represent high energy consuming or inefficient operations through graphics and highlighting, Navicat allows you to gain a deeper understanding of how queries interact with the database, which helps identify areas that need optimization or troubleshooting, thereby improving query performance and overall database efficiency.

Reliable capture and comparison of query results

By fixing the query results, a specific set of results can be retained for future reference. Navicat preserves a specific set of data at a given point in time, along with its corresponding SQL and runtime. Whether you need to perform in-depth analysis or comparison, the ability to fix query results ensures that you have a reliable and unchanged dataset.

Table configuration file

One configuration, easy switching

Configure and save different combinations of filtering, sorting order, and column display for frequently used tables. Depending on the purpose, you can save multiple configurations and easily switch between them without having to reconfigure the tables every time you access them.

URI

Direct access for seamless collaboration

Shared server object URI can facilitate collaboration among team members. No matter where team members are located, Navicat provides a shortcut for easy access to objects. Click on the URI to quickly open the object in Navicat. This eliminates the need for manual navigation to locate objects, allowing everyone to focus on their tasks without unnecessary complexity.

Connect

Intuitive settings and advanced search functionality

Establishing connections through a user centered interface provides a simple process for initiating connections, even for those with limited technical expertise. With advanced filtering and search functions, you can quickly and accurately find specific server types. Merge and manage multiple connection configuration files and create URI based connections, further optimizing efficiency and user friendliness.

Multiple connection properties in an interface

"Manage Connections" provides a new method of managing multiple connection properties simultaneously from a centralized location, allowing you to perform efficient batch operations. You can personalize your connection management by setting stars for connections based on priority, assigning colors based on their importance, or grouping them. By using "Manage Connections", everything will be organized and easily accessible, saving time and effort in searching for specific connections.

BI

Explore interrelated insights

Now, all charts with the same data source on the dashboard can be connected to each other. When you select a data point on one of the charts, all other charts linked to the same dashboard page from the same data source will immediately update to reflect your selection. This real-time coordination allows you to observe patterns, correlations, and trends in different visual representations of data.

Easily expand and customize data using intuitive custom expressions

No need to write complex queries or remember complex formulas. Navicat provides an intuitive way to derive new data points or transform existing data using specific formulas or expressions. You can easily create custom expressions and perform advanced calculations without the need for manual data processing.

Connect to MongoDB and Snowflake to enhance data analysis capabilities

By integrating MongoDB and Snowflake, our BI functionality has taken data visualization and analysis to a new level. Whether you are using MongoDB's NoSQL database or Snowflake's cloud data platform, our tools enable you to create stunning and content rich charts.

Aggregation pipeline design for MongoDB

Gradually build aggregation pipelines through clear and responsive UI. You can use drag and drop functionality to add and rearrange stages to achieve the desired data flow. Through this visualization interface, you can track the data flow for each stage. It provides real-time feedback and result preview at different stages of the pipeline. Navicat enables you to verify the accuracy and correctness of data conversion, and fine tune pipelines for optimal performance.

Focus mode

The focus mode is a new feature in Navicat. It provides a non-interference environment that allows you to focus on tasks related to the database. Whether you are querying data, designing database structures, viewing database data, or analyzing database performance, you can make the most of your workspace and focus on specific tasks without being distracted by irrelevant information.

Redis Sentinel

Navicat manages and monitors independent Redis Redis cluster and Redis Sentinel deployment provide comprehensive support. You can interact with Redis through various features of Navicat, which provide a convenient interface for connecting to Redis, executing commands, and processing data stored in Redis.

Linux ARM version

Navicat provides ARM support for the Linux platform. You can benefit from the stability, scalability, and security features provided by Linux, allowing you to seamlessly develop and deploy databases on ARM Linux systems.