Navicat

Score7.6 out of 10

14 Reviews and Ratings

What is Navicat?

Navicat Premium is a multi-connection database development and administration tool which can simultaneously connect 7 databases (MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite) from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas and Huawei Cloud, developerws can quickly and easily build, manage and maintain databases.

Categories & Use Cases

Database Management

Schema maintenance
Maintaining schema integrity via regular maintenance
Category average: 8.7
User management
Tools to help manage user and role administration
Category average: 8.6
Database change management
Automated scripts for implementing database changes
Category average: 8.7

Performance optimization tools
Performance optimization tools measure and maintain overall responsiveness and efficiency of queries, database structures, etc.
Category average: 8.4
Database status reporting
Detailed reports on database performance, configuration, security, vulnerabilities, etc.
Category average: 8.6
Version control tools
Version control tools ensure code integrity is maintained in a team coding environment
Category average: 8.1

#1 most frequent

Professional, Scientific, and Technical Services

21.2%

47 installations of 222

#2 most frequent

Information

16.7%

37 installations of 222

#3 most frequent

Manufacturing

8.6%

19 installations of 222

Robert Gravelle View profile

Senior Developer in Information Technology at Recognia by Trading Central (51-200 employees employees)

Use Cases and Deployment Scope

Although I retired as a Senior Full-stack Developer a couple of years ago, I still use Navicat Premium for smaller consulting jobs. At my previous job, Navicat Premium allowed me to access our various local and cloud databases from a single application. Now, it's just nice to be able to quickly switch from one database type to another.

Although I've heard from business users that they benefit greatly from the Visual Query Builder, for me, it's the auto-suggest feature that I like best. It helps me quickly locate functions, stored procs, tables, fields, and other database objects quickly!

Pros

Really helpful auto-completion.
Can connect to multiple (different) database types simultaneously.
Can generate some really impressive charts.
The new data dictionary tool is great!

Cons

A tad pricey for non-professional enthusiasts.
Free trial could be longer.

Return on Investment

It's made me much more productive.
I used to use a free tool like most of my coworkers. Never looked back since switching.
I saved some of my common SQL as snippets, which I reuse a lot.

Usability

Alternatives Considered

DBeaver, Rapid SQL and MySQL Workbench

Other Software Used

Microsoft Visual Studio Code, GitKraken, Docker

Shelby Kolb View profile

Data Analyst at PlayStation (1001-5000 employees employees)

Use Cases and Deployment Scope

I use Navicat to easily query data from our data warehouse for multiple business needs. This allows me to easily manipulate and analyze data from multiple sources and combine these multiple sources to answer complex business questions. Navicat is a great tool for our analysts, such as myself, who are not extremely advanced in SQL queries.

Pros

Easy to understand
Simple UI/UX
Easy to connect data

Cons

There is room for improvement with customer support and vendor account management
Onboarding option/support for new team members within the business using the tool
More product/feature updates and trainings

Return on Investment

Improved efficiencies with analysis, freeing up time for our analysts to focus on additional projects and requirements
Navicat has been able to make our complex data more user-friendly, accessible, and approachable throughout the organization. This has resulted in more data-driven business decisions, proving better results.
Overall ROI for various marketing initiatives has improved due to strategic use of data-driven decision making

Alternatives Considered

Tableau Desktop

Other Software Used

Tableau Desktop, Google Analytics, MySQL

Jay Moore View profile

CIO in Information Technology at The National Beta Club (11-50 employees employees)

Use Cases and Deployment Scope

My development team uses Navicat to query data and to assist in writing queries to be used in our php codebase. It can be used to test and queries independently from the php logic.

Pros

Design Tables
View query results
User management
Save queries

Cons

Filter table
Save to external file

Return on Investment

Assisting new employees with understanding our DB
Reduce debugging and testing time with being able to visualize data/queries
Allowing non-SQL users to execute queries to get real-time data.

Alternatives Considered

DataGrip and MySQL Workbench

Other Software Used

DataGrip

Maurice Samuels

DBA in Information Technology at Duquesne Light Company (1001-5000 employees employees)

Pros

Access via standard html
Alert notification

Cons

Remote deploy databases
Clone databases

Return on Investment

Similar features to OEM provided very easy to use, out-of-the-box functionality.
No large infrastructure changes were needed to deploy and install.

Alternatives Considered

Oracle Enterprise Manager

Benjamin Plotkin

Technical Project Manager in Information Technology at California State University, Northridge (1001-5000 employees employees)

Pros

Navicat Premium is a great tool for managing multiple different database connections, as it supports a wide variety of database systems, including MariaDB, MySQL, Oracle, PostgreSQL, SQL Server, and SQLite databases. Credentials and network information are easily configured and stored for multiple connections.
Navicat Premium allows users to define and store queries for reuse, and it supports advanced job scheduling options, allowing the construction and invocation of singular and batched jobs. I use these features to run periodic schema audits on data warehouse tables to ensure our department's data dictionary remains accurate.
Navicat Premium provides a robust data browser view that allows users who are not SQL experts to quickly and easily filter datasets, and directly add, update, and delete table rows.

Cons

Navicat Premium's documentation can be hit-or-miss, as there are several versions available, and it's not always clear which documentation is current for the version at hand.
Navicat Premium's query building interface is not as easy to use or feature-rich as standard IDE and text editor tools, and I've had some issues in the most recent release build with queries auto-running in the middle of making edits, causing a lack of responsiveness in the inbuilt editor -- however, Navicat offers users the ability to edit queries via an external editor, which mitigates these issues to some degree.
In the data browser view, paged data navigation sometimes behaves unexpectedly or fails to work whatsoever, requiring a session restart to correct.
The process of saving a data export file is cumbersome, requiring navigation through several windows, and I believe it could be significantly streamlined to improve user experience.

Return on Investment

Practically speaking, Navicat Premium has enabled our department to support database maintenance and extension, migrations, and customer data reporting and analysis requests, without requiring staffers to be database mavens, thereby extending our limited (non-profit) resources in a significant manner.
In the long term, we may find our perpetual licenses will age out of usefulness, given that major version updates are (not unreasonably) unavailable for perpetual licensing. However, three years in, we've found it to continue to provide value. And going forward, should a major version upgrade be required, upgrade licensing is available at a reduced cost.
As we are a non-commercial organization -- part of the California State University system -- Navicat Premium's one-time license cost is low enough to provide a great value for our department, given the large suite of features it offers; at current non-commercial pricing, one perpetual seat costs out at $599. If you are a commercial organization, the "enterprise edition" is what you'll need to purchase, and at $1,299 per perpetual license, it may be tougher to justify the expenditure. However, Navicat Premium's support for a wide variety of database systems does positively differentiate this product!

Alternatives Considered

Sequel Pro

Other Software Used

Tableau Desktop, 1Password, Zotero

dbForge Studio (Edge)

SQLyog

Toad Edge

MySQL Workbench

Navicat

What is Navicat?

Categories & Use Cases

Key Features

Top Performing Features

Schema maintenance

User management

Database change management

Areas for Improvement

Performance optimization tools

Database status reporting

Version control tools

Most Frequent Users

Professional, Scientific, and Technical Services

Information

Manufacturing

Reviews

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Pros

Cons

Return on Investment

Alternatives Considered

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Related Products