Chris Farrell

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