Navicat comes in several specific database flavors, including MySQL, SQL Server, SQLite, Oracle and PostgreSQL. Navicat Premium handles support for all of those databases combined. First and foremost, The interface feels like it is a native mac app. It is so incredibly intuitive that setting up a connection to a local or remote database doesn’t take longer than a minute. Once connected, navigating through the database schemas is as simple as point and click; everything flows exceptionally well. Kudos to the application designers, they did a tremendous job.
Here are my top 5 favorite (and most useful) features of Navicat:
1. Connect using SSH / HTTP Tunnel
W O W . I’ll be honest, my jaw almost hit the floor when I saw this feature. I’ve often had problems connecting to remote MySQL databases because of various permission issues. I can’t describe just how useful this feature is. All I have to do is create an SSH tunnel to my server with my SSH credentials, and I can connect to the DB at localhost with absolutely no issues. This feature alone makes this product worth every penny in my book.
2. Database Wide Search
The name says it all. There have been many times when I am looking for a particular piece of data nested in some unknown table. Rather than writing a complex query, Navicat will just search all of the tables for you; it’s fast and painless.
3. The Reverse Database to Modeling Tool is insane!
This is probably one of the coolest feature’s I’ve ever seen in a DB tool. Just select Reverse Database to Model and Navicat will literally take all of the database tables and lay them out in a graphical data modeler. It’s awesome. You can then make changes to the DB via the graphical model and SYNC it back with the tables. This feature is AWESOME.
4. Import / Export
Last but not least, the import/export feature of Navicat makes it so incredibly easy to backup or restore your databases without having to go through the effort of either doing is via the command line or through phpMyAdmin. It’s a real time saver.
5. Many Different Database Flavors Available
Navicat Premium handles database connections for MySQL, SQL Server, SQLite, Oracle and PostgreSQL. I personally only use the MySQL and PostgreSQL, but that’s part of what makes Navicat so great (and affordable). You don’t necessarily have to shell out for the most expensive package if you don’t need it. Just focus on the databases that you care about to keep your costs low, and you still get all of the same features.
Ease of Use: 10
Look and Feel: 10
Overall Rating: 10/10
Price: $69 – $249 | Trial? Yes | Navicat Homepage