Skip to main content
TrustRadius
Navicat

Navicat

Overview

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…

Read more
Recent Reviews
Read all reviews
Return to navigation

Pricing

View all pricing
Navicat

Navicat

N/A
Unavailable

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…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

1 person also want pricing

Alternatives Pricing

DBeaver

DBeaver

$11
per month per user
What is DBeaver?

DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.

DataGrip

DataGrip

$9.90
per month per user
What is DataGrip?

DataGrip, from JetBrains, is a database IDE that is tailored to suit the specific needs of professional SQL developers.

Return to navigation

Product Details

What is Navicat?

Navicat Competitors

Navicat Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(11)

Attribute Ratings

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
January 30, 2020

Navicat Premium: Better than advertised, almost better than OEM

MS
Maurice Samuels
DBA
Duquesne Light Company (Utilities, 1001-5000 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
The Navicat monitor sub-application is being used to monitor various cloud databases and MySQL. OEM required too much patching and another software alternative was needed to accomplish monitoring heterogenous databases. Ease of connectivity was a requirement also, and Navicat monitoring being accessible via standard html met that requirement. Most features were identical to OEM (alert notification, performance monitoring, etc).
Pros and Cons
  • Access via standard html
  • Alert notification
  • Remote deploy databases
  • Clone databases
Likelihood to Recommend
Very complimentary features to Oracle Enterprise Manager make Navicat Premium very easy to use and navigate. Some very important features are missing, like online replication and disaster recovery deployment and configuration. Robust language support is available too without large i/o overheard for multibyte language sets. No SQL database support has been added and assists with HIVE and large data set management.
Navicat Feature Ratings
Database Development (5)
68%
6.8
Version control tools
70%
7.0
Test data generation
70%
7.0
Performance optimization tools
80%
8.0
Schema maintenance
70%
7.0
Database change management
50%
5.0
Database Administration (4)
70%
7.0
User management
70%
7.0
Database security
70%
7.0
Database status reporting
70%
7.0
Change management
70%
7.0
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
Pros: Mac OS, Linux, Windows OS support. Cloud db support for all major vendors. Standard HTML accessibility. Standard/Enterprise edition compatibility. Remote and performance monitoring, alert notification, online query analyzing.
Cons: No disaster recovery management, installation, deployment. No clone database support. Monitoring templates are missing so each configured "monitoring" item has to be addressed discretely.
Support Rating
7
Very robust online community and well as excellent support staff. Easy to follow video tutorials. Detailed sample configurations are provided with guided walk-throughs via remote classroom instruction. Very fast response from support staff. No internal hires were necessary for support as vendor support staff fully met all technical expertise. 24/7 incident reporting and tracking is great.
June 29, 2019

Navicat Premium: The Cat's Pajamas for Erstwhile Database Admins

BP
Benjamin Plotkin
Technical Project Manager
California State University, Northridge (Education Management, 1001-5000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
Navicat Premium is the go-to database development tool used in my organization (Student Affairs IT). It is a cost-effective tool that enables staffers to query our on-premises and cloud-based databases (Oracle and MySQL as of this writing) for extraction and reporting purposes, as well as supporting database audits, schema modifications, and granular editing of table rows for maintenance, troubleshooting, and extension of our web applications.
Pros and Cons
  • 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.
  • 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.
Likelihood to Recommend
Navicat Premium is a very well-rounded tool with a reasonable licensing fee given its feature set. It is primarily suited for technical resources who must work with a variety of different database systems, but who may not be database or command line tool wizards. However, its query building and job batch scheduling feature support end-users as they build competency, and it continues to hold its value even as users outgrow their training wheels.
Navicat is probably not so appropriate for DBAs and others for whom database development and management is already a career path; these folks have their preferred toolsets, both vendor-supplied and homegrown, and they might consider the additional licensing cost to outweigh the value they'd personally get out of Navicat.
Navicat Feature Ratings
Database Development (5)
40%
4.0
Version control tools
N/A
N/A
Test data generation
N/A
N/A
Performance optimization tools
N/A
N/A
Schema maintenance
100%
10.0
Database change management
100%
10.0
Database Administration (4)
70%
7.0
User management
100%
10.0
Database security
100%
10.0
Database status reporting
N/A
N/A
Change management
80%
8.0
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
While Sequel Pro is a great shareware tool, it's limited to MySQL databases; while our department does use MySQL databases, we also use Oracle databases, so Navicat Premium's multi-product support is an absolute requirement.
Navicat Premium also provides data browser support, including filtering, to empower less technically-minded users to query and manipulate databases, an option not available in Sequel Pro. And the job scheduling and batching features of Navicat Premium further distinguish it above the admirable, if limited, Sequel Pro.
Other Software Used
Return to navigation