Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Are there any good graphical tools (preferably free) for navigating a MySQL database? I find myself doing a lot of the same SQL queries to look at data in the tables. I would imagine there's a GUI for doing this that makes life easier. Any one know of such a thing?

Thanks a lot.

share|improve this question
    
All you need is available from the MySQL web site. There are also numerous third party products, both free and commercial. You only need to look. –  John Gardeniers Apr 2 '10 at 0:25

11 Answers 11

You can use the MySQL Workbench.
Download here

share|improve this answer

There are the MySQL GUI Tools, which are free to download. The package includes an administration interface, a database migration toolkit, and a query explorer. The package is cross-platform.

share|improve this answer
    
MySQL GUI Tools are in EOL, it's replaced by MySQL Workbench: wb.mysql.com –  Kedare Jan 23 '11 at 19:32
    
@Kedare Yet they're still usable if you are using MySql 4, which I was nearly a year ago. –  Grant Palin Jan 25 '11 at 23:57

There is SQLyog.

share|improve this answer

Some other ($$) options that offer different capabilities than the ones provided by MySQL/Sun/Oracle/ are:

Toad for MySQL
Navicat for MySQL

share|improve this answer

I use mainly MySQL-Front (shareware) but the developer has abandoned the project, which is currently in Limbo. Another popular choice is HeidiSQL, which is free. Make sure you get the latest version though, as earlier ones were quite buggy.

share|improve this answer

Oracle SQLDeveloper is free (beer):

http://www.oracle.com/technology/products/database/sql_developer/index.html

Squirrel SQL is free (beer/freedom):

http://squirrel-sql.sourceforge.net/

share|improve this answer

You could also use SQL Developer. Some of it's cool features would be:

  • Ability generate a diagram of all the tables and their relationships in a database
  • Ability to export data via right click into CSV, XML, or insert statements in an sql file
  • All your standard cross platform java SQL stuff
share|improve this answer

Premiumsoft Navicat For MySQL is very good tool. But it is not free. You can get more information from here.

share|improve this answer

We use Tora. Wikipedia:

TOra (Toolkit for Oracle) is a free software program for Oracle Database developers and administrators. It features a PL/SQL debugger, an SQL worksheet with syntax highlighting, a database browser and a comprehensive set of database administration tools. TOra also includes support for MySQL and PostgreSQL.

The schema browser includes tools to look at the data, if that's all you need. It's built from Qt and runs on Windows, OSX and Linux. Read the official website, and if you like what you see, download it.

share|improve this answer

There is a PHP based web interface called PHPMyAdmin, which does pretty much what you need. The programmers at the company I work for use it intensively and are very happy with it.

share|improve this answer
1  
This would be a good answer if it didn't start with the statement "There is no free GUI". If you edit that, I'll upvote you. –  rjmunro Jan 17 '11 at 12:05
    
You're right, I left it unedited after being showed that there are free GUIs. Fixed now. –  Prof. Moriarty Jan 23 '11 at 19:16

Valentina Studio is a relatively new product on the db admin scene but its free and available on the desktop for Windows, Linux and Mac OS X (32 and 64 bit versions). You can grab a free copy here or learn more here. Like SQL Developer it also includes diagram generation.

enter image description here

The Pro version adds a bunch of nice features like SQLDIFF, plus a very capable reports designer system.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.