Navicat Premium

(28)
4.2 out of 5 stars

Navicat Premium is a database administration tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application.

Work for Navicat Premium?

Learning about Navicat Premium?

We can help you find the solution that fits you best.

Navicat Premium Reviews

Ask Navicat Premium a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 28 Navicat Premium reviews
LinkedIn Connections
Navicat Premium review by <span>Graham L.</span>
Graham L.
Validated Reviewer
Verified Current User
Review Source

"Essential for my iOS/Mac development workflow"

What do you like best?

Offers a nice and tight native feeling user interface. Most tasks can be accomplished in a straightforward manner, quickly and efficiently. Great integration of copy and paste for quickly moving data to other apps, e.g. Excel or Sublime Text. I really like the editing and filtering options in the grid view, they are really powerful in comparison to most GUI clients.

What do you dislike?

Upgrade pricing is too high. There are way too many different flavours and confusing purchasing options. There is gap between appstore and webstore, with disadvantages for the appstore user.

Recommendations to others considering the product

A really good option on the Mac for working with Core Data databases (SQLite) and line of business databases (e.g. Microsoft SQL Server or MySQL). Think what options and databases you really work with an get the edition that matches your needs.

What business problems are you solving with the product? What benefits have you realized?

Opens, manages and edits all types of databases (SQLite, Microsoft SQL Server, MySQL) on my Mac in a common UI. This speeds up development and makes cross-database tasks a breeze.

Sign in to G2 Crowd to see what your connections have to say about Navicat Premium
Navicat Premium review by <span>Ibn H.</span>
Ibn H.
Validated Reviewer
Verified Current User
Review Source

"Interface for Rocket Engineering "

What do you like best?

Yes it is, maintaining databases using CLI is pretty much like some rocket engineering. On our small business having someone else for database administration adds up more expenses. While all of our programmers can manage database using GUI.

Navicat helped our small business a lot. Navicat supports all databases we use with our web and cellphone apps. Not only it has GUI but also gives us accessibility to generate beautiful SQL quires.

What do you dislike?

It's an amazing software, wish the price was little low.

Recommendations to others considering the product

You get what you pay for, this software maybe a bit expensive but it worth the price as GUI database management.

What business problems are you solving with the product? What benefits have you realized?

We are using Navicat for database management. Their wonderful product boosted our development.

What Non-Native Database Management Systems solution do you use?

Thanks for letting us know!
Navicat Premium review by <span>Brian M.</span>
Brian M.
Validated Reviewer
Review Source

"Navicat: I'd Be Lost Without It"

What do you like best?

Having multiple connections opened at once and being able to work in each of those easily. The server monitor is amazing if you use replication. But the best part of navicat is being able to clone a whole database, part of a database or just individual rows by dragging and dropping.

What do you dislike?

The query log could be more user friendly instead of using the operating systems default log application. It would also be nice to have the ability to manager master/slave databases right within Navicat. I will hopefully one day not have to use phpmyadmin anymore and will just be able to do everything that I need to do using Navicat.

Recommendations to others considering the product

If you work with massive databases and/or multiple databases you need to get this

What business problems are you solving with the product? What benefits have you realized?

I can clone entire databases very quickly and easily. It will also let me search every field in every table. Debugging any database server problems, like locked queries, are very handy especially when you can see every server's process that you have set up. With phpmyadmin you will have to go to every individual server to view this.

Navicat Premium review by <span>Caroline E.</span>
Caroline E.
Validated Reviewer
Verified Current User
Review Source

"A good product but not great"

What do you like best?

Navicat has a lot of great features -- I like its ease of setup when connecting to multiple DBs, the ability to use query-builder when you want to visually build queries, and the ease of "beautification" of ugly SQL.

What do you dislike?

The interface is a bit clunky -- to query you need to be in a DB and then hit "new". Viewing table data also requires a new window which is cumbersome if you want to flip between table views. I prefer a simpler reload in same pane, much like you get with Sequel Pro (which I should note is only available on a mac).

Recommendations to others considering the product

Try a few tools to see what you like best.

What business problems are you solving with the product? What benefits have you realized?

When I am working on data problems I tend to go to Navicat if I want to put tables together in query builder or clean up some machine SQL I am debugging. I like it for ease of table info viewing and creating foreign keys. For most other things I prefer other SQL tools.

Navicat Premium review by <span>Fábio J L.</span>
Fábio J L.
Validated Reviewer
Verified Current User
Review Source

"Versátil, elegante e funcional"

What do you like best?

Poder utilizar o mesmo software para gerenciar diferentes SGBDs. Além da elegância do software dou muito valor a sua parte funcional e performance, nestes pontos o Navicat em geral é muito positivo! Adoro o software.

What do you dislike?

Essa é uma pergunta difícil, não vejo nenhum ponto negativo no software, talvez minha única observação seja em relação ao preço, que no Brasil acaba sendo muito caro por conta do dólar.

Recommendations to others considering the product

Pode adquirir o Navicat Premium sem medo algum, o software é ótimo, está evoluindo a cada dia. Recomendo fortemente este produto baseado na minha própria experiência de uso.

What business problems are you solving with the product? What benefits have you realized?

Gerenciamento de múltiplos SGBDs simultaneamente. O maior benefício foi a agilidade que ganhei ao trabalhar com este software.

Navicat Premium review by <span>Nick L.</span>
Nick L.
Validated Reviewer
Verified Current User
Review Source

"A great tool for people needing a way to automatically sync databases."

What do you like best?

Being able to automatically update a SQL database on a regular schedule. It has to ability to e-mail you results to confirm that the update of a database was successful. It also make editing a SQL database very easy. Set up was pretty painless.

What do you dislike?

The method to set up automatic updating and e-mailing of results could be a little more intuitive.

Recommendations to others considering the product

Would definitely recommend this for easy SQL database editing or syncing between databases. It was a lifesaver for syncing a Pervasive database with an e-commerce SQL database.

What business problems are you solving with the product? What benefits have you realized?

I was able to use Navicat to link an old out of date database with an online SQL database. The purpose was to link an inventory system with an ecommerce store. Without the automation abilities of Navicat, this wouldn't have been possible.

Navicat Premium review by <span>Joshua S.</span>
Joshua S.
Validated Reviewer
Verified Current User
Review Source

"An overall reliable way for me to execute SQL queries"

What do you like best?

The number one best feature of Navicat, trumping any other issue for me, is it's ability to restore a session just the way it was if Navicat or the whole computer freezes and I think I've lost my work. It does tend to freeze fairly often but it's ability to restore the unsaved queries I'd written is HUGE!

What do you dislike?

I don't like that result tabs are erased any time I run a new query. Why can't the results be saved and a new tab added with results? If I want to see multiple results I have to run multiple queries at the same time and waste my own time.

Recommendations to others considering the product

It's a perfectly fine way to query a data warehouse. I'm not really sure it's better than free alternatives but it's not a lot of money either.

What business problems are you solving with the product? What benefits have you realized?

I spend around 50% of my day on Navicat writing and adjusting queries that pull data from my company's data warehouse. All the analyses I do start with Navicat.

Navicat Premium review by <span>Ihsan F.</span>
Ihsan F.
Validated Reviewer
Review Source

"Best UX & Best Support"

What do you like best?

I liked navicat by the ease of use and its capability to support most kind of database types, the ux is best, i could easily manage my database without worry about wrong queries, since navicat will validate all of the executed query before executing it, it also provide us with information on what's wrong with our query

What do you dislike?

too bad that it doesn't support some of database types like mongodb or redis

Recommendations to others considering the product

Use navicat as your GUI editor for your database, it will help you create queries and manage your database with ease

What business problems are you solving with the product? What benefits have you realized?

For initial project creation we often rework the database structure, and navicat helps a lot. Also maintaining database, local backup also can be very helpful.

Navicat Premium review by User in Marketing and Advertising
User in Marketing and Advertising
Validated Reviewer
Verified Current User
Review Source

"Navicat Premium for Analytics "

What do you like best?

The ease of use once downloading and connecting to you DB is awesome. My favorite feature overall, though, is the ability to quickly import and export large data sets. My team uses this product daily and are required to import data very regularly, which is why we went with Navicat over other GUI options. The ability to save frequently used queries which also helps save time in the long run, Navicat also makes it very easy for the user to move between tables and search for specific tables quickly while building and running your queries.

What do you dislike?

My main dislike is the color scheme and overall layout of the product. It is very bland and limited for customization. It is also difficult to Navicat around the tool if you do not know exactly what you are looking for. As I noted on the next page, this product is also rather expensive for the individual logins.

Recommendations to others considering the product

I would recommend using this product if exporting data sets is important to your daily activities. The product is great for both Postgres and Redshift users The only downfall is the price of the individual logins.

What business problems are you solving with the product? What benefits have you realized?

I work on an analytics group at a media company and we use this tool to access our database in order to provide clients with detailed reporting. The benefits realized from using this product is the amount of time saved importing/exporting data over other similar products.

Navicat Premium review by <span>Daniel B.</span>
Daniel B.
Validated Reviewer
Verified Current User
Review Source

"Making database administration easier!"

What do you like best?

Navicat Premium is very good for developers this making database mangament easier. I using this every day for mangament databases.

Navicat Premiuim offers very easy interface for databases.

WIthout some functions of Navicat i can't work.

You can manage multiple databases with multiple database engines in one program.

It's easy and good for not expirenced users with SQL language.

Why it's very good for Developers?

Because you don't must spent much time for write SQL books for create table or another thing related to this.

And i like the Navicat Cloud!

In two words Navicat Premium is good software for database mangament for multiple databases and multiple database engines like MySQL, MariaDB, MSSQL, PostgreSQL.

What do you dislike?

The licensing system of this software is isn't good for multiple platforms users.

Recommendations to others considering the product

I recommend this if you don't have very good skills with command line or MySQL Workbench

What business problems are you solving with the product? What benefits have you realized?

As a developer dealing with multiple projects, I have a single place to easily connect to client databases and synchronise changes with local copies of the database for further development.

Navicat has also been instrumental in the past with a project requiring data from multiple databases of different types (mssql and mysql) to be pooled together, processed and then pushed forward to a publicly accessible database online. Navicat facilitated this and was even able to be scheduled to complete the task on a daily basis.

Navicat Premium review by <span>Oisin A.</span>
Oisin A.
Validated Reviewer
Verified Current User
Review Source

"Database modelling and management made easy"

What do you like best?

A very intuitive interface and some great hidden gems (like scheduling queries and data transfers) make Navicat a great tool for any developer dealing with multiple databases on a daily basis.

The modelling tool, which you can then use to synchronise schema changes, can simplify and help organise the development process for a project. Data backups are easy to do, and the query builder (with queries you can save) is so easy to use you barely even need to know SQL.

Finally, the ability to save multiple connections and use ssh tunnels makes this product really stand out against the competition

What do you dislike?

The interface has a tabbed layout when you have multiple queries/tables open, however you are unable to rearrange these tabs and if you accidentally remove a tab it creates a new window which you can no longer put back into the old tab grouping.

Recommendations to others considering the product

A very easy to use solution with some features that make it very worth it compared to the free equivalents out there. The price is very reasonable as well

What business problems are you solving with the product? What benefits have you realized?

As a developer dealing with multiple projects, I have a single place to easily connect to client databases and synchronise changes with local copies of the database for further development.

Navicat has also been instrumental in the past with a project requiring data from multiple databases of different types (mssql and mysql) to be pooled together, processed and then pushed forward to a publicly accessible database online. Navicat facilitated this and was even able to be scheduled to complete the task on a daily basis.

Navicat Premium review by <span>Sazzad Hossain S.</span>
Sazzad Hossain S.
Validated Reviewer
Verified Current User
Review Source

"One of the most used database administration tool for me"

What do you like best?

I can manage my local environment databases and remote databases also. Navicat has cloud sync feature that i love very much as because i don't have to worry for reserving address and usernames all the time. I can access from multiple locations within my 1 account which was synced with Navicat.

Their interface is great and every single table or fields are very much easy to create and maintain.

What do you dislike?

Database table or fields collation system has to search the entire name and then it appears. The bottom next/ forward button, sometimes confused. SQL extension files import feature is unavailable within Import Wizard. It has to be click from execute SQL file.

Recommendations to others considering the product

Great application software for managing multiple local and cloud databases within the software. Also has feature that can be sync the database settings/ login information's within Navicat server. Easy to manage and access the database. Very much easy to make relationship within tables.

What business problems are you solving with the product? What benefits have you realized?

Connecting local and remote database servers within accessing the web browser. Navicat has the facility that maintain all the things from the software and don't need to access the web database server.

Navicat also supports SSH and HTTP tunnels that can be accessible via various methods.

Navicat Premium review by <span>Akram Hasan S.</span>
Akram Hasan S.
Validated Reviewer
Verified Current User
Review Source

"Pro Database management software"

What do you like best?

I like their synchronize feature very much, it let's you synchronize database structure and data from one host to another simply and accurately. No tension of data lost or data mismatch. Another thing will be I like they support all major databases and their cloud feature. I can work with any database I want MySQL, SQLite, MSSQL, Oracle and many more. Their cloud feature helped me store and synchronize my projects online and access from any device I want. Data modeling, report builder, graph those can be remark as well. Overall BOSS of Database management.

What do you dislike?

For database management I don't think they missed anything. Yet their price is very high and expansive, they should lower the price so small business and individuals can use their amazing software for database management.

Recommendations to others considering the product

If you care about your data, you should give a try this software.

What business problems are you solving with the product? What benefits have you realized?

We are using Navicat for database management and data backup. This software is very helpful and easy to use.

Navicat Premium review by User in Automotive
User in Automotive
Validated Reviewer
Verified Current User
Review Source

"Decent MySQL Tool"

What do you like best?

The various wizards are pretty straightforward and convenient. Useful for importing and exporting data, as well as some automated query building.

What do you dislike?

After long periods of use I often end up with memory issues. I'm not sure if there is a memory leak within Navicat or if it just has trouble with data caching. It's always fixed after a program restart, but it can be annoying.

Recommendations to others considering the product

It's not bad, but can have trouble with really large data sets

What business problems are you solving with the product? What benefits have you realized?

we use Navicat Premium as our primary MySQL tool and have realized benefits with using a standardized tool across all of our database developers.

Navicat Premium review by <span>Martina .</span>
Martina .
Validated Reviewer
Review Source

"I used Navicat Premium for PostgreSQL (versions 11.2 and 12.0) during my database course."

What do you like best?

I like the modern user interface best. All the functionalities I need are at hand, it is an easy-to-understand tool for beginners, and it's easy to find every option you need.

What do you dislike?

There is nothing I don't like about the tool, I had no problems using it.

Recommendations to others considering the product

If you are looking for a database modeling and administration tool, which is easy to use and looks good, Navicat Premium is a great choice for you.

What business problems are you solving with the product? What benefits have you realized?

I have used Navicat Premium to teach my database course. My students were able to focus on creating database models in a simple and modern environment.

Navicat Premium review by <span>Gustavo G.</span>
Gustavo G.
Validated Reviewer
Verified Current User
Review Source

"Best Database GUI "

What do you like best?

The most advance database query GUI to improve your work.

With this solution you can build and export usefull report to your cowrokers

What do you dislike?

The license price, its to expensive right now

Recommendations to others considering the product

best SQL GUI query interface

What business problems are you solving with the product? What benefits have you realized?

Database query to exports as report such as csv, excel, text.

Navicat Premium review by <span>Paul B.</span>
Paul B.
Validated Reviewer
Review Source

"Great for queries, not so good for maintenance"

What do you like best?

Navicat is GREAT for querying multiple flavors of SQL in the same program. It is also the best program available that will allow you to access MS SQL Server from a Mac. Connecting to the various servers is simple, and running queries, executing and writing stored procedures, and other data-related processes are very simple.

What do you dislike?

Anything maintenance-related: backups/restores, user account permissions, and data migrations are either impossible with Navicat or so hidden that I couldn't figure out how to do them.

Recommendations to others considering the product

It's not a replacement for the tools from your favorite SQL vendor, but it comes pretty close. Works great for simple data tweaking.

What business problems are you solving with the product? What benefits have you realized?

Accessing a MS SQL Server, MySQL Server, and an Oracle server from a Mac.

Navicat Premium review by <span>Daniel J.</span>
Daniel J.
Validated Reviewer
Verified Current User
Review Source

"Great product for MySQL"

What do you like best?

I like the interface and multiple connections management, the query ui and capabilities are really nice too.

What do you dislike?

I dislike how different the Mac and Windows versions are.

What business problems are you solving with the product? What benefits have you realized?

Database management and administration.

Navicat Premium review by User
User
Validated Reviewer
Verified Current User
Review Source

"Best db manager ever, just love it"

What do you like best?

How easy it is to build queries, even if you're not an expert in sql it helps you a lot.

What do you dislike?

It gets stuck when importing large .sql files, last hours and hours with no results.

Recommendations to others considering the product

Just try it, you will love it, specially if you don't have so much knowledge on sql.

What business problems are you solving with the product? What benefits have you realized?

It's not that expensive and it helps me save time on doing queries.

Navicat Premium review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source

"Gets the Job Done"

What do you like best?

Navicat works well for SQL basics. It's easy to write queries and manage databases on a small scale.

What do you dislike?

Very few shortcuts. Navicat does not offer any autogeneration for fields or functions.

Recommendations to others considering the product

It's fine for the basics. If I had the choice I might seek out a web based IDE for collaboration purposes.

What business problems are you solving with the product? What benefits have you realized?

Easy access to postgres database.

Navicat Premium review by <span>Saeed M.</span>
Saeed M.
Validated Reviewer
Verified Current User
Review Source

"One of the best database management softwares"

What do you like best?

Stability, speed, features. Server monitor is the best part of navicat

What do you dislike?

sometimes it crashes, and in big query it's not fast enough. and multi threading could be better

What business problems are you solving with the product? What benefits have you realized?

I managed MySql with Navicat, It helps me to manage easier than other database management softwares.

Navicat Premium review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Excellent For Database Management"

What do you like best?

It is very to use and to save frequently used queries. A nice interface too.

What do you dislike?

Too many steps needed to export. And running batches of scheduled queries could be much easier.

Recommendations to others considering the product

Give it a shot. I've yet to find a better solution out there for running queries.

What business problems are you solving with the product? What benefits have you realized?

Database management (running SQL queries).

Navicat Premium review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source

"Gets the job done but could be better"

What do you like best?

It is easy to find your way around the product

What do you dislike?

Exports of csvs don't pull well into excel sometimes, Can not search columns in a table, can not figure out how to schedule queries to run and save.

Recommendations to others considering the product

Understand how Navicat exports your data before sending off a CSV for a data request

What business problems are you solving with the product? What benefits have you realized?

Pulling data from our database

Navicat Premium review by User in Public Relations and Communications
User in Public Relations and Communications
Validated Reviewer
Verified Current User
Review Source

"Essential version of Premium works well for novice SQLers."

What do you like best?

I'm a first-time Navicat (and SQL) user. Since several of my coworkers use the platform for work, I tried it as well. It's great for the basics that I use it for: queries and downloads.

What do you dislike?

I have not experienced any issues yet with Navicat Premium Essentials.

Recommendations to others considering the product

Definitely worth a look if you're a novice, and it's probably good for experts as well.

What business problems are you solving with the product? What benefits have you realized?

My company uses SQL a lot for data collection and organization. The only problem is, I never learned how to use SQL.

Navicat Premium Essentials has proven to be a great tool for novices to use.

Navicat Premium review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Gets the job done"

What do you like best?

Simple to set up and get started. My use of Navicat is fairly low-touch so what I need to do, it works well and gets me the data I need.

What do you dislike?

Occasional timeouts. I also wish the error notification was a bit more specific.

What business problems are you solving with the product? What benefits have you realized?

Querying our database to get at data I need to track our performance.

Navicat Premium review by User in Higher Education
User in Higher Education
Validated Reviewer
Review Source

"Great querying tool"

What do you like best?

Navicat is a great tool for accessing data from multiple tables.

What do you dislike?

The graphics/color scheme could be improved.

What business problems are you solving with the product? What benefits have you realized?

We are accessing data from thousands of tables in our data warehouse, from many different sources. We can quickly pull together data using Navicat to meet business needs.

Navicat Premium review by Administrator in Package/Freight Delivery
Administrator in Package/Freight Delivery
Validated Reviewer
Review Source

"Great choice for managing complicated database ecosystems"

What do you like best?

Love being able to use one product to handle all our databases, from Postgres to SQL Server to SQLite. Best of all database managers I've tried at doing this.

What do you dislike?

It's a fairly pricey product, and a few of the synchronizations (data, structure) have unexpected restrictions.

What business problems are you solving with the product? What benefits have you realized?

Small team, so we need a consistent interface to manage all our databases.

Navicat Premium review by User in Civil Engineering
User in Civil Engineering
Validated Reviewer
Verified Current User
Review Source

"good product"

What do you like best?

easy to use and I can setup my database for quick connect

What do you dislike?

nothing much,

need some time to figure out

What business problems are you solving with the product? What benefits have you realized?

database quick connect

Kate from G2 Crowd

Learning about Navicat Premium?

I can help.
* We monitor all Navicat Premium reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.