DEV Community

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

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?

Discussion (60)

Collapse
lucasm profile image
Lucas Menezes

For MySQL, PostgreSQL and Oracle I use DBeaver =)

Collapse
joelbonetr profile image
JoelBonetR

me too

Collapse
derekcrosson profile image
Derek Crosson

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

Collapse
juniordevforlife profile image
Jason F

+1 for DBeaver.

Collapse
julianjupiter profile image
Julian Jupiter

Their cloud/web version is awesome.

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

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

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

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

Collapse
stefanoginobili profile image
Stefano Ginobili

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

;)

Collapse
andrewbaisden profile image
Andrew Baisden

Compass for MongoDB and Valentina Studio for postgresql.

Collapse
madza profile image
Madza Author

I need to pick up a great GUI for PostgreSQL, added to the list ๐Ÿ˜‰ Thanks! ๐Ÿ‘Œ

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 Author

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

Collapse
quasipickle profile image
Dylan Anderson

Heidi SQL

Collapse
railto profile image
Mark Railton

Personally I love DataGrip from JetBrains.

Collapse
mtzagkarakis profile image
Manos Tzagkarakis

IntelliJ ultimate all the way

Collapse
anibalardid profile image
Anibal

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

Collapse
saint4eva profile image
saint4eva

Azure Data Studio.

Collapse
ma2web profile image
ma2web

Compass for Mongodb ๐Ÿ‘

Collapse
madza profile image
Madza Author

Love it too, great tool ๐Ÿ‘๐Ÿ‘Œ

Collapse
krhoyt profile image
Kevin Hoyt

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

Collapse
djnitehawk profile image
Dฤต ฮฮนฮ“ฮžฮ—ฮ›ฯˆฮš

nosqlbooster for mongo.
was using navicat before that.

Collapse
julianjupiter profile image
Julian Jupiter

MySQL Workbench and DBeaver.

Collapse
sdil profile image
Fadhil Yaacob

beekeeperstudio.io/ this is my favourite

Collapse
henryonsoftware profile image
Henry Bui

HeidiSQL for MySQL, NoSQL Booster for Mongo.

Collapse
dabjazz profile image
Yash_Jaiswal

JavaFX, Java swing, MySQL

Collapse
sanchezdav profile image
David Sanchez

I use Sequel Pro and Postico ๐ŸคŸ

Collapse
faridsa profile image
faridsa • Edited

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

Collapse
jordonr profile image
Jordon Replogle

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

Otherwise I mainly use CLI tools.

Collapse
dominikhaid profile image
dominikhaid

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

Collapse
hooopo profile image
Hooopo

DrawERD with mysql & postgresql support

Collapse
ramytamer profile image
Ramy Tamer

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

Collapse
pika1998 profile image
Prafulla Raichurkar

MongoDB Compass

Collapse
duarte2025 profile image
William Mateus Duarte

DataGrip is better db tool

Collapse
_garybell profile image
Gary Bell

DataGrip by JetBrains. It lets me work with several database types in one easy tool. Fewer things to update, and fewer shortcuts to remember

Collapse
3rror profile image
Gianluca Andreotti

I mainly use TablePlus with PostgreSQL.
I like it because it is native, fast and beautiful.

Collapse
joelrozen profile image
Joel Rozen

Mongo -> Robo 3T
Redis -> Redis Desktop Manager
MySQL/Postgres -> DBeaver or Sequel Pro (depending on complexity of what I need to do).

Collapse
v613 profile image
Ceban Dumitru

Dbeaver for mysql and postgress
Toad for oracle

Collapse
zdev1official profile image
ZDev1Official

I like mongodb, it's cool

Collapse
finnanton profile image
Finn

MYSQL Workbench & HeidiSQL are my favorites.
When the Database is very simple i use HeideSQL, otherwise i use HeidiSQL

Collapse
nattakorns profile image
Nattakorn Sanpabopit

I like DBeaver but v7.2 have a problems with oracle connection.