This is so much easier and faster than having to click an Edit icon by a record to then pull up a new form. If you need to change some field values, just make the change right there and move to a different record to commit the change. Scroll through or page through the records to get to the one you’re looking for. If the table is small and you’re looking for a specific record, sort on any one or more fields by selecting it, and clicking one button. Review and modify data quickly and easily – Just double-click on a table to open it up in Browse mode. The login information is set up in the connection, so getting to the data is fast-no time taken up with tedious logins. To open one up, we just click it to see a list of all the tables. Simple, fast, and intuitive access to all of your databases from the desktop – Connections to all of the databases we manage are listed right there on the left hand side. We’ve been using Navicat almost exclusively since 2004. It is simply the first of a series of reviews of products and services we use or have tried at Web Site Optimizers.

We did not consult with Navicat in any way in writing this. To be clear, this is not a paid endorsement or advertorial. To do that, we turn to Navicat by PremiumSoft. At Web Site Optimizers, our development team must maintain a large number of MySQL databases. And if so, you want a tool that can give you these abilities easily and powerfully. Whether you develop and maintain a large number of custom built web sites, or if you just need to perform some specific queries on the database for your lone site, there is a good chance you need to access, manage, and/or query a MySQL database.

Navicat 8.0