Querious: MySQL on Your Desktop

If you regularly work on website design or development, there’s a good change that you encounter MySQL from time-to-time. It’s a widely popular database system, often coupled with the infamous phpMyAdmin as a visual administration system. For many years, I longed for a better alternative to this clunky, visually dated front-end to MySQL.

Recently, my prayers have been answered in the form of Querious, a native Mac application for managing your MySQL database right from the desktop. This review will take an in-depth look at what Querious has to offer, and how it can make managing a database far more enjoyable.

Connecting

Querious offers a simple interface for connecting to your database, allowing the storage of several favorites down the left hand side:

Connecting to a Database

Connecting to a Database

A full range of connection options are available, and everything is fairly self explanatory. The “small print” to be noted here is that Querious is only capable of connecting to MySQL 5 databases (or later). This may prove a limitation if you’re on a slightly older hosting package and are not running the latest version of the database software. It’s certainly worth checking before purchasing the app!

Once connected, you’ll be offered a column of all the databases/tables in the MySQL installation. Clicking one will take you into one of two different views:

Managing Table Structure

The capabilities of Querious are broadly separated into managing the structure of your database, and managing the data within it. You can swap between these two views through the icons in the upper left corner of the screen.

The structure view is named “Columns”, and allows you to change the type, length, name, and default values of a particular field:

Viewing a database structure and columns

Viewing a database structure and columns

The functionality on offer is fairly straight forward, and works as you’d expect. Changes are made quickly, and a spinner in the upper left tab notifies you that they are being written back to the database.

Managing Data

When swapping to the ‘Content’ view, you’ll be shown all the records contained within a particular table. Sorting by a particular column responds immediately (an updated view is not requested from the database):

Viewing and editing database content

Viewing and editing database content

Searches can be performed on individual columns or the whole table, and work as you’d expect. To edit a particular record, you can double click it. This will bring up an editor window and allow you to change the value:

Editing a field

Editing a field

Upon clicking ‘OK’ you’re returned to the database and the change is made in the background.

Other Features

Operations

Operations

If you’re a slightly more advanced MySQL user, you’re able to perform specific SQL queries through the “Query” tab. This works well, and the feature to automatically save a query history is very useful.

In addition, a variety of MySQL operations can be performed with one click. These include: Analyze, Check, Flush, Repair and Optimize. Results are displayed in a dialog window. Full SQL import and export is supported, and you can choose files directly from your desktop. The exporting window offers a range of functionality:

Exporting Data

Exporting Data

Three export options are available: CSV, Tab Seperated, or SQL. You can select a particular database and tables to export, along with whether you’d like to include options such as drop/create table. During exporting, you’ll see a progress bar and updates on what’s happening behind the scenes.

Even more useful is the ability to copy-and-paste several rows to the clipboard, automatically formatted as CSV, SQL or Tab Separated content. Upon clicking copy (or hitting a keyboard shortcut), you are asked how you’d like to export the data. This is one of my favorite features, as it’s far more user friendly than any other option available.

Conclusion

If you’re looking for a user friendly front-end to MySQL, Querious is certainly worth taking a look at. I’m thoroughly impressed with everything the app is capable of, and would certainly recommend it as an excellent desktop solution. The only downside is the occasional application hang as data is read/written from the database. This rarely happens, and everything usually works seamlessly.

A free solution is available – Sequel Pro. We’ll cover this in a future review, but in testing I found it not to offer the same polished experience. If you don’t mind parting with $25 (and your server supports MySQL 5), Querious is certainly worth the money.


  • http://didats.net didats

    Thanks for the review. The features currently better than SequelPro.

    Btw, Did you tested store procedure?

  • http://eugeniogrigolon.com Eugenio Grigolon

    Nice review! I’ll give a try (tired of the same phpMyAdmin layout).

  • applestar

    I tried it a few weeks ago and bought it immediately. Its great since you can tunnel your SQL access through ssh. No need to open port 3306 to the public, as no-one would really consider. Then, you can use this little app for both, local and remote (productive) SQL databases. Its a great lifesafer for developing – in my case PHP/MySQL

  • Roland

    anything it can do that Navicat for MySQL (free) can’t do?
    except the not-being-cocoa part….

    • http://didats.net didats

      Thanks for mentioning Navicat. It really can do anything. But unfortunately, its not free.

    • dave

      navicat does do it all… including crashing all the time and it’s big, clunky & slow.. by definition a typical windows app & I prefer the lighter, faster more solid feel of a mac app.

      Navicat ARE NOT mac developers and the mac version is way behind their windows version and until they get someone in there who can make it nice the right way I won’t pay for an update from them again.

      I brought Querious up here months back on a different post and have been using it since they brought it out and I love it, I can leave it open all day and not worry about it crashing on me.

  • http://www.snipe.net snipe

    Thanks very much for this review – looks like an amazing app. I’m throwing down the $25 for it now, after having tried it because of your review. It’s about time Mac users got a great db management app :)

  • http://www.snipe.net snipe

    Hey, one quickie – does Querious not store passwords in the favorite connections? Or am I just missing something.

    • http://davidappleyard.net David Appleyard

      It seems to work fine for me!

    • http://www.wittistribune.com Witti

      Same problem here.

  • http://www.twitter.com/phillipsmn Mason

    Thanks for mentioning SequelPro because as I was reading your post, the first thought I had was, “how does this compare with SequelPro?” I like SP. There’s also a beta app in the wild called Dolphin which has some really nice UI notification effects and other benefits, but it’s not ready for full-time production use as far as I’m concerned.

  • http://www.simpleleap.com/cram/mac.htm Patrick Chukwura

    This seems quite interesting. I’ve been looking for such a tool

  • Pingback: Querious: MySQL en tu escritorio, Carrero

  • http://www.weatheredwatcher.com David Duggins

    Do any of you know that MySQL has it’s own collection of tools? Thats right….You can get the MySQL GUI tools for Windows, Mac and Linux. The Mac version is awesome with alot of the Mac coolness you expect. It is a phenomenal…I’ve been using them for the past year now.
    For a review, I just finished one up. http://www.weatheredwatcher.com/blog to check it out.

    • dave

      The mysql tool set really sucks, horrible to use, crashes all the time, a complete time waster IMO.

      • http://www.weatheredwatcher.com David Duggins

        Interesting. I’ve been using the mysql tools for about a year now and I have never had any issues with them except for when I am using a massive database…and I have yet to find any gui tools that can handle massive dbs as well as the tried and true command line.

      • Gregory

        I second that. I used it a day and managed to make it crash quite often. Too often. It isn’t a reliable product as far as I’m concern. Navicat is good and has some nice features but is soo windows that I don’t want to use it unless it’s my last option.

        Querious IMO offers a very good alternative. It lacks a few things and could benefit a few improvements here and there but it does the job remarkably well. Their team has proved to be responsive to some of my requests and bug reports. I just need to be patient enough to wait for the 1.0 stable release.

        Btw, I have yet to see a good way of handling big chunks of data with the console and the command line… A grid of 102×68 characters can’t beat a good gui for most of the tasks (or is it just me?)

  • http://appbeacon.com Justin

    Wow! About a month or two ago, I wrote off Querious in some other blog comments after trying it out. I am a die hard fan of SQLYog – even on a Mac via Parallels or CrossOver. I’d sworn off all others because SQLYog is so perfect.

    However, I just installed and tried this latest release. It seems much better than before. The SSH tunneling works perfectly. The copying features are great and …

    Well, SQLYog running in CrossOver is a pain in the butt because of the different keys.

    I’m going to try Querious for the next few days. I just may be giving up SQLYog on the Mac.

    • Capt. Sparrow

      No where near to SQLyog.

  • http://www.twenstudio.com/ Twenstudio

    Nice !

  • http://www.rossgardt.de Benedikt R.

    DBSolo is also okay. It’s user interface is not the best, but it works:
    http://www.dbsolo.com

  • Patrick

    I find I sometimes need a few tools to get the job done. http://squirrel-sql.sourceforge.net/ is also worth a look as it will connect to any JDBC compliant RDMS (ie. MySQL, Postgres, SQL Server, Oracle….).

  • Pingback: Chris Mallinson » Blog Archive » Querious – MySQL Client for OSX

  • http://curiositea.fr Ana

    Hi,

    My SQL database is on 1&1 and I don’t know how make the connection with Querious. Anyone can help me ? What I am supposed to write on the ‘socket’ and ‘port’ fields ?

    Thanks

  • http://www.mirko.rs Mirko

    Nothing can replace Navicat for me, it has the most features by far! But the UI isn’t so nice as in Querious.

  • http://lumixmedia.net Marcos Cerutti

    Hi there! I have seen some MySQL GUI around, sure, this one is really cool, MySQL tools crashes too much, and so on… So, some days ago I discovered MySQL buddy, it´s for free, really easy install (it´s php), an you you need MySQL for webdev, I believe you will have Apache running. try it out folks, it was the easyest way to use MySQL I ever saw (despite CLI).

    p.s. I do not work for the MySQL buddy producers ;)

  • Simon

    Sequal Pro is the go. Works with any version of MySQL (unlike Querious). 10/10 for this, and it’s free to download.

  • Pingback: The Ultimate Roundup of 85 Mac Apps for Web Designers and Developers

  • Tom Anderson

    You can check one more tool – Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of MySQL, as well as, SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.

theatre-aglow
theatre-aglow
theatre-aglow
theatre-aglow