Create account

DEV Community

What are your favorite DB GUI tools?

Madza on September 24, 2020

I like Workbench for MySQL and Compass or Robo 3T for MongoDB.

What DB GUI tools have you tried and which ones do you like best?

Kevin Peters • Sep 25 '20 • Edited

Recently discovered Beekeeper Studio, it is Open Source and free. Based on Electron and Vue.js it is cross-platform which is super nice. On top, it works with most SQL dialects. Personally, I mostly use PostgreSQL in my personal projects so this is just perfect and so much better than pgAdmin.

For work, I use Datagrip since the license is provided. The most used feature there is probably the copy rows as CSV, JSON, or similar. That is the deal breaker there. Hoping Beekeeper introduces this feature as well.

Matthew Rathbone • Sep 25 '20

👋 Beekeeper Studio creator here. We have download table as CSV/JSON, but not copy rows. Like that idea. I'll add it to the feature requests :-)

Julian Jupiter • Sep 27 '20

I uninstalled it immediately coz the tables were not being shown. I commented on one of the posts of Beekeeper on Twitter but got no response. What a horrible experience from both software and its twitter. twitter.com/beekeeperdata/status/1...

nexovec • Dec 29 '23

Don't disclose issues through twitter, please.

Anibal • Sep 26 '20

Wow ! Congratulations. An amazing tool. I didn’t know it, so I will install and checkit

Giancarmine • Sep 25 '20

Beekeeper studio is my favorite one!!!

Please consider add MongoDB support

Also... Way don't add hacktoberfest lable to the issues? 🔥🔥🔥

Matthew Rathbone • Sep 26 '20

Would love too add mongo support, but I'm not a current mongo user, and feels like it deserves some real work to figure out how to display mongo data in a way that works well.

So probably not for a little while I guess? If you have ideas on what results should look like for mongo data please take screenshots and make an issue! It will help me a lot when I build the feature.

dominikhaid • Oct 2 '20

Datagrip would be my Choice for SQL if had a license. It tried it once and it really works well.

Matronator • May 6 '21 • Edited

I wouldn't mention the Electron part if you want to drive people in, not out. Electron apps are cancer.

But back to the topic, I vote DataGrip as well.

Lucas Menezes • Sep 24 '20

For MySQL, PostgreSQL and Oracle I use DBeaver =)

JoelBonetR 🥇 • Sep 25 '20

me too

Derek Crosson • Sep 25 '20

I love DBeaver and that it can generate entity relationship diagrams.

Jason F • Sep 25 '20

+1 for DBeaver.

Julian Jupiter • Sep 27 '20

Their cloud/web version is awesome.

Khanh Le • Sep 25 '20

I like Datagrip from Jetbrain for any kind of DB engine

Sumit Datta • Sep 25 '20 • Edited

I love Workbench too, for PostgreSQL I do not really use a GUI. But then again a typical Django/Laravel/Rails etc admin is a GUI and I have made plenty of those.

Currently I am building a GUI for databases that does not need/mention SQL and builds all queries for you behind the scene. Here is the product and its source on GitHub.

gkTim • Sep 24 '20

Sequel pro and beekeeperstudio both are good. Sequel Pro has now a days some crashing as it is not very actively maintained but still one of the best guis I know. Beekeeperstudio is relatively new but they have a good pace and bring up new features quite quick.

Manuel Dalla Lana • Sep 25 '20

There is a fork of Sequel Pro which is actively maintained: github.com/Sequel-Ace/Sequel-Ace

zakaria chahboun • Dec 7 '22

Beekeeper and DBGate

Madza • Dec 8 '22

Thanks for the insight, zakaria 👍💯✨

Joe Steinbring • Sep 25 '20

I like Navicat if I don't have to pay for it and TablePlus if I do. Both work with whatever DBMS you are looking to use it with.

Pacharapol Withayasakpunt • Sep 24 '20 • Edited

For SQLite, I remembered it was SQLiteStudio, but it seems that the website has updated. (I also remembered that it was never first results on Google...)

I also remembered that DBeaver did its job well, for multiple kinds of RDBMS, based on JDBC.

Since I use MongoDB Atlas, I rarely use Compass, (but I need it sometimes, especially outside Atlas).

Madza • Sep 25 '20

I use Atlas too, but find Compass to be way faster and more intuitive, those are the main reasons I use it 👍

Chris Bongers • Sep 25 '20

For me, Sequel Pro and good old phpMyAdmin

Rahul • Sep 25 '20

Hope you're using the nightly build of Sequel Pro. If not you should consider switching to Sequel Ace.
Perks:

App doesn't crash when one of the tabs is closed
Filter using multiple columns on a table.

Chris Bongers • Sep 25 '20

Just the plain build haven't seen Sequel Ace, but let me give it a try

Madza • Sep 25 '20

Oh, good days with phpMyAdmin 😉 Got the job done still 👍👌

Chris Bongers • Sep 25 '20

100% it's maybe something I'm just used to, but it works

Stefano Ginobili • Sep 25 '20

For MongoDB I use NoSQLBooster. What I appreciate is:

good JS editor
intellisense (paid version)
useful option to mark a connection as read-only, especially when you are connecting to a production environment just to run a query
monitoring tools
query history
...and so on

;)

Mark Railton • Sep 25 '20

Personally I love DataGrip from JetBrains.

Alena Subotina • Jan 21 '22

I prefer dbForge Studio for MySQL. It is an ultimate IDE for MySQL and MariaDB database development, management, and administration.

Madza • Jan 21 '22

Thanks for insight 🙏❤

Jan Prochazka • Sep 29 '21

For MySQL, PostgreSQL, SQLite , MS SQL and MongoDB you can try DbGate. I am DbGate creator

Madza • Sep 29 '21

Thnaks for sharing this tool 😉👍

Dylan Anderson • Sep 25 '20

Heidi SQL

Andrew Baisden • Sep 24 '20

Compass for MongoDB and Valentina Studio for postgresql.

Madza • Sep 25 '20

I need to pick up a great GUI for PostgreSQL, added to the list 😉 Thanks! 👌

Julian Jupiter • Sep 27 '20

MySQL Workbench and DBeaver.

dominikhaid • Oct 2 '20

For PostgreSQL I use Admin.
For MySQL the Workbench.
Datagrip would be in there but at the moment I got no license.

Ramy Tamer • Sep 26 '20

dbdiagram.io for database design and Tableplus to connect to almost any database engine.

Manos Tzagkarakis • Sep 26 '20

IntelliJ ultimate all the way

ma2web • Sep 24 '20

Compass for Mongodb 👍

Madza • Sep 25 '20

Love it too, great tool 👍👌

Kevin Hoyt • Sep 25 '20

Querious for MySQL, and TablePlus for SQLite. TablePlus supports other databases (including MySQL), but for some reason I just use it for SQLite.

Dĵ ΝιΓΞΗΛψΚ • Sep 25 '20

nosqlbooster for mongo.
was using navicat before that.

David Sanchez • Sep 25 '20

I use Sequel Pro and Postico 🤟

Fadhil Yaacob • Sep 29 '20

beekeeperstudio.io/ this is my favourite

Anibal • Sep 26 '20

Inise robo3t for mongodb.
Mysql workbench for mysql. But reading comments I didnt know Beekeeper. So i will install it

saint4eva • Sep 26 '20

Azure Data Studio.

Yash_Jaiswal • Sep 25 '20

JavaFX, Java swing, MySQL

William Mateus Duarte • Sep 25 '20

DataGrip is better db tool

farid • Sep 25 '20 • Edited

I'm using workbench mostly to db design, and Sequel Pro for operations.

Jordon Replogle • Sep 25 '20

For work connecting to MS SQL I use Azure Data Studio.

Otherwise I mainly use CLI tools.

hooopo wang • Sep 25 '20

DrawERD with mysql & postgresql support

Milan Mitrovic • Jan 1 '22

Datagrip from JetBrains is by far the best IDE for databases. It can't be compared with a other tools available in the market... Datagrip, then 5 empty places, then any other tool.