Best Interactive Environment for SQL?

Question

What's, for you, the best interactive environment for crafting SQL queries around here?Things I'm wondering about:* basic syntax help / autoindent* red underline for indicating errors* function autocomplete* table and field autocomplete* partial results streaming* progress indicators* table exploration (looking at a table catalog etc.)* "workbench" where you can save multiple queries* link to visualization tools* link off to more powerful statistical analysis tools...

dundercoder · Accepted Answer

DataGrip by Jetbrains is decent. I really like the autocomplete found in the psql client as well. Sublime Text has a few sql plugins that help with code readability.

stephenr · Answer

Depends what flavour of SQL you want to use. As pointed out already the DB plugin/DataGrip 'stand alone' app from Jetbrains is not bad, and has pretty wide language/protocol support.For MySQL/compatible stuff, I still end up back on SequelPro though, because it's much "lighter", IMO.

lilfermat · Answer

I enjoy TablePlus throughly! I would download the free version and try it out. It&rsquo;s a game changer for people that do majority of the their transformation and modeling in SQL. (Along with DBT).

slipwalker · Answer

i used to love AquaDataStudio, but their license price went nuts sometime ago, since then, i have been orbiting around datagrip.

Best Interactive Environment for SQL?

DataGrip by Jetbrains is decent. I really like the autocomplete found in the psql client as well. Sublime Text has a few sql plugins that help with code readability.

Depends what flavour of SQL you want to use. As pointed out already the DB plugin/DataGrip 'stand alone' app from Jetbrains is not bad, and has pretty wide language/protocol support.
For MySQL/compatible stuff, I still end up back on SequelPro though, because it's much "lighter", IMO.

I enjoy TablePlus throughly! I would download the free version and try it out. It’s a game changer for people that do majority of the their transformation and modeling in SQL. (Along with DBT).

i used to love AquaDataStudio, but their license price went nuts sometime ago, since then, i have been orbiting around datagrip.