I recently moved my workflow from Windows to macOS. As a longtime Windows user, I've been searching for apps and utilities to replace those that aren't present on macOS so I don't have to utilize a VM or remote into a Windows box to complete tasks. One big hole for me was Microsoft's SQL Server Management Studio. My organization uses integrated Windows Authentication for its SQL servers and I couldn't get the SQL Extension to work in Visual Studio Code due to issues with Kerberos. Similar problems occurred with other SQL clients, but DbGate worked out of the box.
Admittedly, I fumbled around a bit with the UI since I am so used to SSMS but I've gotten comfortable with it now and have made it a permanent part of my toolbelt. I'd recommend anyone looking for a cross-platform SQL client to give DbGate a shot.
It is simple to understand intricate relationships and change data effectively thanks to its user-friendly interface and robust data browser, above all the data speed is too impresive as compare to other DB tools. All things considered, it's a good option for handling various databases in a contemporary way. Highly Recommended.
Until recently, my company's stack was very Microsoft heavy. We used MSSQL server almost exclusively. My go to tool was Toad, but that is expensive especially for a small team with a low budget. I tried DBeaver, HeidiSQL and a few others. DbGate has been the best so far - I have been using it for about 18 months now. My main requirements are the ability to save SQL snippets and a multi tabbed interface - preferably with color coded tabs based on which database it is connected to - I often do green for test/dev databases and red for production for example. Now that we are starting to get more postgresql into the mix, having a tool that is engine-agnostic is helpful too.
Top features (for me at least):
Multi tabbed - you can open multiple tables, multiple queries etc and if needed can do a split screen to view tables/queries/views side-by-side - and tabs can be color coded for easy identification
Ability to switch quickly between data view / structure / sql code
Ability to edit table data in a grid/spreadsheet like fashion and save changes in bulk (or even just copy the SQL for later use)
Easy to see all objects in a schema - Tables/Views/Procedures/Functions/Triggers
The only thing I'd like to see is easy source/version control - but I'm yet to find any tool that does that well
