Home / server / Questions / 128627
In Process
Shlomo Shmai
Asked: 2010-04-02 15:00:54 +0800 CST

Graphical MySQL tools

  • 772

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.

mysql graphical-user-interface architecture

12 Answers

  1. You can use the MySQL Workbench.
    Download here

    • 4

  2. 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.

    • 4

  3. There is SQLyog.

    • 2

  4. 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.

    • 1

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

    Toad for MySQL
    Navicat for MySQL

    • 1

  6. 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.

    • 1

  7. 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/

    • 0

  8. 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
    • 0

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

    • 0

  10. 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.

    • 0