4 ms·

Tangentially related, if any macOS users are shopping for a DB client here’s my experience: After many years Sequel Pro (MySQL only) started having problems so

Tangentially related, if any macOS users are shopping for a DB client here’s my experience: After many years Sequel Pro (MySQL only) started having problems so I tried every tool in this class for macOS and ended up standardizing on TablePlus. It supports most common DBMSs, works on Mac and Windows, and apparently has a Linux alpha. I still prefer Sequel Pro’s UI but TablePlus is ok. No critical bugs although import of massive or complex MySQL dumps still works more reliably on the official CLI client.

thenaturalist 6y ago
+1 very happy Tableplus user. Keyboard shortcuts, clear UI, split pane... Much to love. I am in no way affiliated with the product or it's creators, but have seen many SQL clients and can recommend it.
tornquist 6y ago
Have you seen Sequel Ace? It’s a fork of the project that’s maintained again. https://github.com/Sequel-Ace/Sequel-Ace https://github.com/Sequel-Ace/Sequel-Ace I also use Postico for Postgres https://eggerapps.at/postico/ https://eggerapps.at/postico/ the UI there is nice as well. It’s the closest I could find to Sequel Pro.
Vuska 6y ago
I was in the same boat, except I moved to Querious (https://www.araelium.com/querious https://www.araelium.com/querious)
sam_goody 6y ago
Copying from an earlier comment of mine, as it might be useful to someone. # Mysql Only: - Sequel Pro (Free, Pretty, Mac only. Has issues with MySQL v8) - Workbench - https://www.mysql.com/products/workbench https://www.mysql.com/products/workbench (Free, Pretty) - DBForge - https://www.devart.com/dbforge/mysql/studio/editions.html https://www.devart.com/dbforge/mysql/studio/editions.html (Freemium) - Querious - https://www.araelium.com/querious https://www.araelium.com/querious ($50 one time, Mac only) - Sequel Ace - https://github.com/Sequel-Ace/Sequel-Ace https://github.com/Sequel-Ace/Sequel-Ace (Free) # Postgres Only: - Postico ($40, Pretty, Mac only) - PgAdmin - https://www.pgadmin.org https://www.pgadmin.org (Free, Clunky) # SQL Server: - Azure Data Studio - https://docs.microsoft.com/en-us/sql/azure-data-studio https://docs.microsoft.com/en-us/sql/azure-data-studio (Free, Pretty) # Multi DB: - DataGrip ($89 first year, $71 second year, $53/year after that, Clunky, Powerful) - TablePlus ($50, Pretty, Useful) - DBeaver (Free version, Clunky, Powerful) - Heidi (Free, Clunky, Usable) - SQuirrel (Free, Clunky, Usable) - http://sequeljoe.ohwg.net http://sequeljoe.ohwg.net (Free, beta) - Valentina Studio - https://www.valentina-db.com/en/valentina-studio-overview https://www.valentina-db.com/en/valentina-studio-overview (Freemium, Pretty) - Aqua Studio - https://www.aquafold.com https://www.aquafold.com ($500, Clunky) - Navicat Premium ($599, Pretty, has good reputation) - POPSql - https://popsql.com https://popsql.com (free for 2 saved DB connections,12/Mo., Pretty) - Beekeeper Studio (Free, Electron) - DBGate (Free, Electron) - VSCode Extensions (Free, Electron) EDITED based on other comments If I was getting new, I would definitely check out popsql, tableplus, and datagrip first.
- 2citizen 6y ago
  If Azure means Azure Data Studio, it can be extended with other DB via official extensions.
- slenk 6y ago
  I will second DBeaver. It can connect to anything and has made massive improvements since I started using it years ago
  - WrtCdEvrydy 6y ago
    I will admit that DBeaver is great but MongoDB is not supported on the community version so we ended up on Robo 3T for just that one use case.
    - slenk 6y ago
      I never use MongoDB but I did not know that. That's pretty lame.
- nerdponx 6y ago
  If Mysql Workbench makes the list, why not Pgadmin?
- void_mint 6y ago
  I used DBeaver for a few years until I got tired of giving 50% of my machine's resources to it, then switched to TablePlus and have been quite happy. I've never needed more than two tabs so I've never paid, but I absolutely would pay them (it's great). If I was looking for something new right now, I'd try DataGrip first. I'm a huge fan of Jetbrains' products so I'd be happy to pay them for another useful tool. Just my 2c. I'm sure others have different experiences/likes/dislikes
  - vlkr 6y ago
    i am using dbeaver right now, it uses not much resources, just 250mb of ram
mekster 6y ago
Same. SequelPro's interface was very intuitive but too bad the development stalled and SequelAce just didn't work as expected. (Somehow connecting through SSH just kept failing for no good reason when other SSH related tools just worked.) TablePlus got good enough with its interface, though there are still some parts still feeling unintuitive like ordering of columns through numbering instead of drag/drop style but it's the best of workable solutions. (DataGrip is too heavy)

thenaturalist 6y ago

+1 very happy Tableplus user. Keyboard shortcuts, clear UI, split pane... Much to love. I am in no way affiliated with the product or it's creators, but have seen many SQL clients and can recommend it.

tornquist 6y ago

Have you seen Sequel Ace? It’s a fork of the project that’s maintained again. https://github.com/Sequel-Ace/Sequel-Ace https://github.com/Sequel-Ace/Sequel-Ace I also use Postico for Postgres https://eggerapps.at/postico/ https://eggerapps.at/postico/ the UI there is nice as well. It’s the closest I could find to Sequel Pro.

Vuska 6y ago

I was in the same boat, except I moved to Querious (https://www.araelium.com/querious https://www.araelium.com/querious)

sam_goody 6y ago

Copying from an earlier comment of mine, as it might be useful to someone. # Mysql Only: - Sequel Pro (Free, Pretty, Mac only. Has issues with MySQL v8) - Workbench - https://www.mysql.com/products/workbench https://www.mysql.com/products/workbench (Free, Pretty) - DBForge - https://www.devart.com/dbforge/mysql/studio/editions.html https://www.devart.com/dbforge/mysql/studio/editions.html (Freemium) - Querious - https://www.araelium.com/querious https://www.araelium.com/querious ($50 one time, Mac only) - Sequel Ace - https://github.com/Sequel-Ace/Sequel-Ace https://github.com/Sequel-Ace/Sequel-Ace (Free) # Postgres Only: - Postico ($40, Pretty, Mac only) - PgAdmin - https://www.pgadmin.org https://www.pgadmin.org (Free, Clunky) # SQL Server: - Azure Data Studio - https://docs.microsoft.com/en-us/sql/azure-data-studio https://docs.microsoft.com/en-us/sql/azure-data-studio (Free, Pretty) # Multi DB: - DataGrip ($89 first year, $71 second year, $53/year after that, Clunky, Powerful) - TablePlus ($50, Pretty, Useful) - DBeaver (Free version, Clunky, Powerful) - Heidi (Free, Clunky, Usable) - SQuirrel (Free, Clunky, Usable) - http://sequeljoe.ohwg.net http://sequeljoe.ohwg.net (Free, beta) - Valentina Studio - https://www.valentina-db.com/en/valentina-studio-overview https://www.valentina-db.com/en/valentina-studio-overview (Freemium, Pretty) - Aqua Studio - https://www.aquafold.com https://www.aquafold.com ($500, Clunky) - Navicat Premium ($599, Pretty, has good reputation) - POPSql - https://popsql.com https://popsql.com (free for 2 saved DB connections,12/Mo., Pretty) - Beekeeper Studio (Free, Electron) - DBGate (Free, Electron) - VSCode Extensions (Free, Electron) EDITED based on other comments If I was getting new, I would definitely check out popsql, tableplus, and datagrip first.

2citizen 6y ago
If Azure means Azure Data Studio, it can be extended with other DB via official extensions.
slenk 6y ago
I will second DBeaver. It can connect to anything and has made massive improvements since I started using it years ago
- WrtCdEvrydy 6y ago
  I will admit that DBeaver is great but MongoDB is not supported on the community version so we ended up on Robo 3T for just that one use case.
  - slenk 6y ago
    I never use MongoDB but I did not know that. That's pretty lame.
nerdponx 6y ago
If Mysql Workbench makes the list, why not Pgadmin?
void_mint 6y ago
I used DBeaver for a few years until I got tired of giving 50% of my machine's resources to it, then switched to TablePlus and have been quite happy. I've never needed more than two tabs so I've never paid, but I absolutely would pay them (it's great). If I was looking for something new right now, I'd try DataGrip first. I'm a huge fan of Jetbrains' products so I'd be happy to pay them for another useful tool. Just my 2c. I'm sure others have different experiences/likes/dislikes
- vlkr 6y ago
  i am using dbeaver right now, it uses not much resources, just 250mb of ram

mekster 6y ago

Same. SequelPro's interface was very intuitive but too bad the development stalled and SequelAce just didn't work as expected. (Somehow connecting through SSH just kept failing for no good reason when other SSH related tools just worked.) TablePlus got good enough with its interface, though there are still some parts still feeling unintuitive like ordering of columns through numbering instead of drag/drop style but it's the best of workable solutions. (DataGrip is too heavy)