2

Is there a drag and drop query browser's like this for free or linux (except for Navicat, which is not free) enter image description here

1

[Update] OP has idicated that this answers his question. I leave the others below, in case they are of any use to others in future.

Valentina Studio Pro includes a visual SQL query builder and you can use most of its abilities within the free Valentina Studio on Windows, Linux and Mac OS X.

enter image description here


FlySpeed SQL Query has both a free, and a paid for ($34.99) version. It looks just like NaviCat and can run in Linux using Wine.

enter image description here


Easy Query BUilder is similar, and free. It doesn't mention Linux, but should be worth trying with Wine.

enter image description here


Also, read https://www.quora.com/What-are-some-good-visual-SQL-query-builders and do some Googling. Could you pelase help us by posting here what you decide to use? Thanks

  • Thank you soo much :) :) – sampath wijesinghe Apr 20 '17 at 3:59
  • but after installing fly speed in linux it says "Error creating object. Please verify that the Microsoft Data Access Components 2.1 (or later) have been properly installed" what can i do ?? – sampath wijesinghe Apr 20 '17 at 4:11
  • OIC. Sounds like its looking for ODBC connectors. All that I suggest is to try to find some & put them in the sam edirectory as the executable. Or, try one of the others. I am sure that you can easilly fdind suitable software just by Googling. Good luck – Mawg Apr 20 '17 at 6:53
  • 1
    @Mawg Might be a good idea to split your answer, so it gets clear which one is the "accepted" recommendation. Not a "must", just a "consideration". Especially as candidates not running natively are often not much preferred (that's almost as recommending a Windows user Linux software to run in a VM ;) Side-note: Navicat isn't native either (at least it wasn't when I last checked it; it came bundled within its own Wine embedding). – Izzy Apr 21 '17 at 9:01
  • 1
    @Mawg query builder not in the free version but there is query editor. no different in query editor. It is same as the query builder that shows in the your answer. – sampath wijesinghe Apr 24 '17 at 3:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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