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.
N/A
Sequel Pro
Score 8.1 out of 10
N/A
Sequel Pro is a relational database software solution offered free and open source. It allows users to access any MySQL database through a Mac.
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, …
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.
It's a great tool when building the software, the ability to add SQL and No-SQL databases. Very convenient to write the queries and generate the filtered data we require. Gives the ability to export, import databases of various formats and generate reports from them. It might not be suitable if you want the data to be seen in a visualized manner
It crashes CONSTANTLY. If you have more than one connection tab open and close one of them, it crashes. If you just have it open in the background, it randomly crashes. If you're using it, it randomly crashes. When you try to send a crash report, the CRASH REPORTER CRASHES.
Can be a bit slow.
No way that I'm aware of to query multiple databases in the same query.
There is quite a lot to learn because Navicat Premium is a very comprehensive database management and development tool, but it's User Interface is intuitive enough to pick up fairly quickly. I have also referred to the documentation on occasion, and can attest that it is quite good. I feel that it works best on a large monitor, but that's fairly common for this sort of software.
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.
It's open-source and very convenient to work with. I can easily import any database I want using a data dump and runt the queries on them to derive the data insights on the data. I might want to use Excel to visualize that, that might be one of the disadvantages.
MySQL Workbench is a wonderful tool, but the routine editing of existing data is note nearly as straightforward as it is in Sequel Pro. The ability to sort a data view with a single click makes Sequel Pro my definite choice. phpMyAdmin is pretty ubiquitous, but the routine editing of existing data is much more cumbersome than it is in Sequel Pro.
