I need a free MySQL manager with a visual query builder.

I used to use EMS manager for MySQL in Windows but since I'm trying to be a Ubuntu user now, I need another tool with a visual query builder to save me time of creating queries.

A lot of posts online mention that MySQL Workbench has a visual query builder but I couldn't find it. All it has is an ERR from database which is making a reverse engineering for any database.

I need something like that to create a query, not ERR. Something like:

Visual query builder

1 Answer 1


OpenOffice / LibreOffice has a graphical query designer in its database application.


enter image description here

  • 1
    I'm beginning to like Ubuntu already :) , it even can connect to remote database. Freeeeeeeeeeeeedoooooooooooom
    – medo ampir
    Jan 13, 2014 at 9:59
  • Does this support MySQL though Rinzwind?
    – Thomas Ward
    Jan 20, 2014 at 23:18
  • 1
    @ThomasW. Yes. LO/OO has a mysql connector
    – Rinzwind
    Jan 21, 2014 at 8:53
  • Also it supports postgresql db via libreoffice-sdbc-postgresql package
    – Anwar
    Nov 24, 2016 at 17:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .