DEV Community

Cover image for What are your favorite DB GUI tools?
Madza
Madza Subscriber

Posted on

What are your favorite DB GUI tools?

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?

Top comments (64)

Collapse
Β 
igeligel profile image
Kevin Peters β€’ β€’ 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.

Collapse
Β 
rathboma profile image
Matthew Rathbone β€’

πŸ‘‹ 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 :-)

Collapse
Β 
julianjupiter profile image
Julian Jupiter β€’

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

Thread Thread
Β 
nexovec profile image
nexovec β€’

Don't disclose issues through twitter, please.

Collapse
Β 
anibalardid profile image
Anibal β€’

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

Collapse
Β 
el_giancar profile image
Giancarmine β€’

Beekeeper studio is my favorite one!!!

Please consider add MongoDB support

Also... Way don't add hacktoberfest lable to the issues? πŸ”₯πŸ”₯πŸ”₯

Thread Thread
Β 
rathboma profile image
Matthew Rathbone β€’

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.

Collapse
Β 
dominikhaid profile image
dominikhaid β€’

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

Collapse
Β 
matronator profile image
Matronator β€’ β€’ 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.

Collapse
Β 
lucasm profile image
Lucas MauΓ©s β€’

For MySQL, PostgreSQL and Oracle I use DBeaver =)

Collapse
Β 
joelbonetr profile image
JoelBonetR πŸ₯‡ β€’

me too

Collapse
Β 
juniordevforlife profile image
Jason F β€’

+1 for DBeaver.

Collapse
Β 
derekcrosson profile image
Derek Crosson β€’

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

Collapse
Β 
julianjupiter profile image
Julian Jupiter β€’

Their cloud/web version is awesome.

Collapse
Β 
khanhle81839451 profile image
Khanh Le β€’

I like Datagrip from Jetbrain for any kind of DB engine

Collapse
Β 
brainless profile image
Sumit Datta β€’ β€’ 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.

Collapse
Β 
gktim profile image
gkTim β€’

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.

Collapse
Β 
endelwar profile image
Manuel Dalla Lana β€’

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

Collapse
Β 
zakariachahboun profile image
zakaria chahboun β€’

Beekeeper and DBGate

Collapse
Β 
madza profile image
Madza β€’

Thanks for the insight, zakaria πŸ‘πŸ’―βœ¨

Collapse
Β 
patarapolw profile image
Pacharapol Withayasakpunt β€’ β€’ 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).

Collapse
Β 
madza profile image
Madza β€’

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

Collapse
Β 
steinbring profile image
Joe Steinbring β€’

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.

Collapse
Β 
janproch profile image
Jan Prochazka β€’

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

Collapse
Β 
madza profile image
Madza β€’

Thnaks for sharing this tool πŸ˜‰πŸ‘

Collapse
Β 
dailydevtips1 profile image
Chris Bongers β€’

For me, Sequel Pro and good old phpMyAdmin

Collapse
Β 
rahul_ramfort profile image
Rahul β€’

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.
Collapse
Β 
dailydevtips1 profile image
Chris Bongers β€’

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

Collapse
Β 
madza profile image
Madza β€’

Oh, good days with phpMyAdmin πŸ˜‰ Got the job done still πŸ‘πŸ‘Œ

Collapse
Β 
dailydevtips1 profile image
Chris Bongers β€’

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