- Without any hesitation: Sequel Pro. I've been using it for years and really happy with it.Sequel Pro: I've been using this a bit and so far so good. It supports multiple open connections, but only one SQL editor per connection. You can open a SQL file into the editor but then it doesn't clearly display what file you have open which is annoying. Otherwise it seems solid. MySQL workbench: MySQL workbench (for architecting) and Navicat for MySQL (for storing & scheduling common queries and report generation) are both great with enough differences to warrant mentioning both.
- The UI is great and easy to work with. Also worth mentioning is it's very fast.
- Hi Brayant! I suggest you to take a look at TeamSQL, a multi-platform SQL Client for Mac, Windows and Linux. Its super easy to use. Its Multi - Platform Data Client Simple, Effortless, Extensible. Feature: Autocomplete,Executed Query History ( Global & Query based like Git ), Encryption (store your data encrypted using AES-256 ), Color Coding - each database connection has different color,Saved Queries, Folder Structure based in Cloud,Best Database Table Design Editor ever,
- Some recommendations are for MySQL, this is a great tool to run those postgres queries to pull those redshift data that your marketing/finance (insert department) team really really need today :)