Graphical MySQL tools

Question

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.

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 02 '10 at 00:25

score 4 · Answer 1 · answered Apr 01 '10 at 23:09

4

You can use the MySQL Workbench.
Download here

answered Apr 01 '10 at 23:09

Scott Lundberg

2,364
2
14
22

score 4 · Answer 2 · answered Apr 01 '10 at 23:17

4

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.

answered Apr 01 '10 at 23:17

Grant Palin

342
2
3
18

MySQL GUI Tools are in EOL, it's replaced by MySQL Workbench: http://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

score 2 · Answer 3 · answered Apr 02 '10 at 16:18

2

There is SQLyog.

answered Apr 02 '10 at 16:18

Joe Internet

1,439
8
6

Prof. Moriarty · Answer 4 · 2011-01-23T19:15:53.250

1

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.

edited Jan 23 '11 at 19:15

answered Apr 01 '10 at 23:06

Prof. Moriarty

870
8
12

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

score 1 · Answer 5 · answered Apr 02 '10 at 14:31

1

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

Toad for MySQL
Navicat for MySQL

answered Apr 02 '10 at 14:31

MattB

11,124
1
29
36

score 1 · Answer 6 · answered Apr 03 '10 at 00:06

1

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.

answered Apr 03 '10 at 00:06

John Gardeniers

27,262
12
53
108

score 0 · Answer 7 · answered Apr 02 '10 at 16:47

0

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/

answered Apr 02 '10 at 16:47

gm3dmo

9,632
1
40
35

score 0 · Answer 8 · answered Apr 02 '10 at 16:52

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

score 0 · Answer 9 · answered Apr 02 '10 at 21:42

0

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

answered Apr 02 '10 at 21:42

Kerberos

123
4

score 0 · Answer 10 · answered Apr 02 '10 at 21:53

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.

score 0 · Answer 11 · answered Mar 26 '13 at 17:56

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.

score -1 · Answer 12 · answered Jan 31 '17 at 09:18

-1

dbForge Studio for MySQL - a universal MariaDB and MySQL GUI tool for database administration, management, and development. The IDE allows to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. The MySQL client delivers data and schema comparison and synchronization tools, database reporting tools, backup options with scheduling, and much more features.

answered Jan 31 '17 at 09:18

Devart

99
1

Local etiquette is pretty clear; if you post about your own product, or a project you're involved in, [you must disclose your affiliation in your answers](http://serverfault.com/help/promotion). Be very up-front and explicit about it. – MadHatter Jan 31 '17 at 09:24

Graphical MySQL tools

12 Answers12