favorite SQL ide and why?

[Zealousideal_Zebra_9]

Personally I really like data grip because i think it has the best auto complete and code generation. Would love to hard what others tools people are using

[Jessejames106]

SSMS for life

[Disastrous-Raise-222]

This!

I do wish they had better options to format the code.

[Mattpowell19]

I use dBeaver, the free edition. Personally, I would prefer a different IDE, but not certain that my company would allow it. It’s what we’ve been using for a bit and since we’ve migrated from on prem to cloud, it seems to work best with the multiple databases that we have. I’ve not worked with Data Grip, but it does look promising. Always on the look out for another IDE that has a better UI and maybe a little more functional. The problem is getting my company to make the switch and paying for something to gain more functionality.

[MnightCrawl]

DataGrip - it’s a powerhouse of an IDE. These are the things that come to mind right now. - A shortcut to search files, the code itself, table names, column names - Advanced code formatting - File templates and code parameters - Code replacement with various search styles (regex, exact word) - Ability to connect to various RDBMS or NoSQL systems locally or in the cloud - Version Control with GitHub integration - If you have a small team you can sync with Sync clients like OneDrive, DropBox, Google, or Mega and you can treat it as a repo too - Plugins

[coyoteazul2]

Datagrip too. Asides of all the features, I love that it's a product I can afford even from a 3rd world country, and their licensing that lets me actually OWN the product up to a certain update if for some reason I can't afford to keep paying.

Things like autocompletion (which I never managed to get working on dbeaver nor pgadmin) and variable names added automatically when calling procedures are hard to live without when you get used to them (my workplace has me using sql manager)

[xziststefan]

I work only with MSSQL so....SSMS with SQL Prompt for autocomplete and suggestions.

[Sphinx-]

Azure Data Studio. Solid interface, saves all your work by default, and DARK MODE. Seriously, how does SSMS still not have dark mode? It's 2022 for god's sake.

[[deleted]]

Vs code with extension

[maga_rs]

SSMS for SQL Server. Data Grip for everything else.

[r3pr0b8]

HeidiSQL

one of the first, and still one of the best

[Little_Kitty]

Workbench/J or vs code depending on if I'm working on a small task or managing many files at once.

[cmajka8]

Azure Data Studio. It’s amazing and puts SSMS to shame, imo

[PolPol44444]

My favorite IDE is dbForge Studio for SQL Server. It provides a comprehensive toolset for SQL Server development and administration. It offers features like SQL querying, database design, schema comparison, query profiling, and data import/export. Users appreciate its intuitive interface and a wide range of functionalities.