Navicat 15 Adds New Capabilities

Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, Microsoft SQL Server, MongoDB, Oracle, PostgreSQL, and SQLite databases from a single application. It is compatible with cloud databases like Alibaba Cloud AsparaDB, Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud. Huawei Cloud, MongoDB Atlas, and TencentDB. Using Navicat you can quickly and easily build, manage and maintain your databases.

Of course, if you only use one of those database systems, you can purchase a Navicat license for just that DBMS (for example MySQL or Oracle). I have discussed Navicat in the blog before (see here) but today I’d like to talk about the new features added to the latest and greatest release of Navicat, version 15.

The first important new feature is support for native Linux for the user interface. Navicat already is supported on Windows and MacOS, but the new Linux support makes it easier for Linux users to deploy Navicat on the operating system they prefer. Navicat 15 supports the following Linux variants: Ubuntu 12.04, Ubuntu 14.04, Ubuntu 16.04, Ubuntu 18.04, CentOS 6.7, CentOS 7, Fedora 22, Fedora 23, Fedora 26, Linux Mint 13, Linux Mint 17.3, openSUSE 13.2, openSUSE 42.1, and Debian 9.

Charting

A significant new feature of Navicat 15 is the ability to turn your database data into visuals to have clear insights through charts and graphs. Let’s walk through a short example.

I created a table with my record and CD collection in a MySQL database. Here is a screen shot of Navicat displaying the first rows of the table.

table records cds

 

Now suppose I want to create a pie chart of the various formats of recorded music in my collection (CD, records, etc.). I would choose the Charts option from the Navicat menu bar as shown here:

charts

I then select the data source (my record collection table), refresh the data, and choose a chart type from the selection bar. I chose a pie chart, as shown here:

charts-pie

The resulting pie chart shows what I suspected, that I have more CDs than I have vinyl records!  Here is the pie chart created by Navicat.

just the pie chart

It really is that simple. And this is just one of the many types of charts that you can create from your data using Navicat 15. In addition to pie charts, you can create bar charts, line charts, area charts, scatter charts, heat maps, and tree maps, all with a few simple clicks.

Data Transfer

Moving data is always a tricky and time-consuming endeavor. DBAs and developers are always looking for easier ways to move data (or subsets of data) from one place to another. Well, Navicat 15 also offers a new approach for transferring data.

This new design simplifies moving and transferring data using Navicat with an intuitive user interface. You can customize the fields and specify the number of rows you wish to transfer.

An example of the user interface is shown here:

data-transfer

SQL Builder

Another significant new capability in Navicat 15 is the SQL Builder, which can be used to build queries visually. This feature is particularly helpful for new coders who are not overly familiar with SQL syntax, but it can also be beneficial to old pros who just want to click and build SQL instead of hammering out the code themselves.

Choose the New Query option on the toolbar, and then click the Query Builder to open it. You will be presented with a screen showing your database objects on the left, and on the right you will see two sections: a diagram design and the SQL syntax below it, as shown below:

Query Builder

The SQL Builder only support SELECT statements, that is, it is a SQL query builder. Of course, Navicat supports building any SQL statement in a non-visual fashion using its SQL Editor.

Once you have the SQL Builder up all you have to do to get started is to drag a table or view from the left pane to the Diagram Design pane or double-click it to add it to query. Here we see the same panel as above after I dragged my albums table to the top pane:

Query Builder albums

Next, we need to decide on the columns to include in the query. This is accomplished by checking the column names in the Diagram Design pane. Here we see the results of me having clicked on three columns:

Query Builder columns selected

You can further supply additional components of the SQL by pointing and clicking, such as Group By, Having, and Order By clauses. When complete, you simply click Build to create the SQL, or Build and Run to create and execute the statement.

Here we see the results of running the simple SQL statement I built:

Query Builder executed.png

Additional New Features

Navicat 15 comes with more in-depth modeling features. You can use it to deliver a full picture of differences between a model and the database. And you can generate scripts to update the destination database with any differences you discover.

Navicat 15 also supports dark mode. You can set Navicat to display a data theme as opposed to the typical white background. This setting can be quite useful for those with eyesight issues, or for anyone that prefers not to use a white theme. An example screen shot in dark mode is shown below:

dark mode

Summary

The latest version of Navicat offers up some nice features that make it easier to manage, use, and administer your heterogeneous database environment. Consider taking a look at it to make simplify your database development and administration tasks. You can download a free trial here.

About craig@craigsmullins.com

I'm a data management strategist, researcher, and consultant with over three decades of experience in all facets of database systems development and implementation.
This entry was posted in DBA. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s