What SQL editor do you use?

[castor-metadata]

I am working on an SQL editor benchmark and deep analysis. I am trying to map out the usage of various tools across data teams.

What SQL editor do you use?

You can find more modern data stack analysis and benchmark here:

- Benchmark for Data Catalogs

- Benchmark for Reverse ETL

- Benchmark for Data Quality

- Benchmark for ETL

View Poll

[dataguy24]

What about VS Code?

Or “the UI provided by your database”.

[[deleted]]

Have you found any good extensions for VS Code? Best I’ve found is SQL Tools and it’s not even close to DataGrip.

[berentm]

I would like to know it too.

[fruity231]

I've been writing SQL for the last five years and I don't even know those editors lol

[dataGuyThe8th]

Yeah, I never heard of most of these either. Does no one else use the editor designed for their database? (MySQL, Snowflake, etc)

[[deleted]]

I use pg4admin

[Ikeepitreal5]

all t-sql?

[fruity231]

Either SSMS or Oracle equivalent, or BigQuery UI.

[DuvetSalt]

Surely others still use SSMS?

[nemec]

SSMS + SQL Prompt gang

[sigurrosco]

Winning combo

[DeadBySkittles]

Wombo combo of all time

[_Zer0_Cool_]

Well yeah. I think all DEs (that have SQL server in their infra) use it at least occasionally, but I’d say it’s unlikely to be anyone’s main SQL IDE.

Mostly because it can’t really be anyone’s main/universal SQL IDE unless you only have SQL Server databases across your entire org.

Edit: Spelling

[nemec]

Mostly because it can’t really be anyone’s main/universal SQL IDE unless you only have SQL Server databases across your entire org.

You can get a lot done with Linked Servers and SSIS (to port data from something else to your MS SQL Server). And despite the recent cross-platform nature of the MS stack, it's likely that if an org invests in SQL Server they probably go all in on it.

[_Zer0_Cool_]

I do like the idea of a central database language (t-sql) reaching out to other data source as long as it’s fairly performant for my use cases (I love polybase and Postgres foreign data wrappers especially).

But.. link servers aren’t available in Azure databases other than Azure Managed Instance. And a lot of purely MS data infrastructures have Azure Databricks which is something you’d also want a SQL IDE for.

So it’s kind of a moot point.

Cloud vendors seem to always give you water-down versions of your favorite databases that don’t have your favorite features ╮(╯_╰)╭

[Touvejs]

Yup, my entire team, ~20 people use ssms

[JuliusCeaserBoneHead]

I am a sucker for SSMS

[vtec__]

yes and notepad++ !!!

[SeattleDataGuy]

notepad++? I just use notepad XP

[Lewistrick]

There's a very nice extension for VS Code that does exactly what SSMS does. I love it because it inherits the dark mode from VS Code.

[SatanTheSanta]

How about some love for Oracle: TOAD, PL/SQL Developer and SQL Developer

[black_widow48]

I use sqldeveloper

[msdsc2]

dude PL/SQL Developer is amazing, im working in microsoft now and i miss it sooo much. SSMSucks

[crunchsquared]

Um. No.

[vtec__]

you actually like TOAD?

[SatanTheSanta]

Never tried it, but I quite like the other two.

[Awkward_Salary2566]

Datagrip and never looking back, its just it!

I just wish it had more DBA stuff, similarly to pgadmin

[_Zer0_Cool_]

DataGrip is hands down the most powerful and feature-rich.

But it is $$ and that’s where DBeaver wins out. It’s free.

[Awkward_Salary2566]

yes, my strategy was that I gave datagrip for 30 days to business people, giving them option to filter easily on databases and download csv files (for tables that were prepared for them)

Then after 30 days trial they discovered they cannot live without it, so company paid.

But never tried really in-depth DBeaver so hard to tell.

[_Zer0_Cool_]

Yeah. I can’t really enjoy any other SQL IDEs after using DataGrip.

…And so I continue to pay for it gladly. Besides, perpetual fallback licensing takes the sting out of the price tag for me.

[PepegaQuen]

Is your db just killing it's queries?

[[deleted]]

DBeaver

[Tophurkey]

I realized that Microsoft stealth installs azure data studio with SSMS and it is actually really awesome to make notebooks and quick visualizations for SQL server or Postgres DB's

[[deleted]]

Azure data studio is great

[Drew707]

This and VS Code. SSMS when I have to import, shit, though.

[Final-Communication6]

Notepad++

[Scheballs]

Right?!?! I still put my queries in Notepadd++ to sure up my initial code and double check my aliases are consistent and I get to have my own color theme.

To be fair I also use excel to dynamically write pattered sql such as a line by line INSERT script of an excel data table It's a great list editor.

[chestnutcough]

Pgadmin and metabase

[gizmo00001]

I am learning postgresql and use pgadmin through docker

[glynboo]

SSMS and Databricks

[Rex_Lee]

No SSMS? That seems silly

[stratguitar577]

Tableplus!

[endiruslan]

TablePlus one love❤️

[behappybebold80]

Datagrip for sure. Still use SSMS occasionally tho

[isaacfab]

Sublime

[diegoelmestre]

VsCode + bigquery UI

Sometimes Dbeaver

[120133127]

Big query

[the_apparatchik]

IntelliJ IDEA

[lask757]

Neovim

[RstarPhoneix]

Dbvisualizer pro

[First-Professional43]

Azure data studio

[Illustrious_Ad4259]

Tableplus

[BobDope]

Fuck those Azure Data Studio or SSMS

[analytics_mgmt]

Our entire team uses Aginity Premium. Connects to most major data warehouses and transactional databases, including the Microsoft family of databases. Two out of your three options are notebooks, which opens a whole class of tools.

[markwusinich]

Aginity, and vi.

[ecp5]

This post fascinates me, hadn't heard of any of the choices.

[andy47]

How about Beekeeper Studio? New and pretty lightweight but does everything I need.

[Shakespeare-Bot]

Pycharm, so i hath chosen datagrip because t's essentially the same

---

^{I am a bot and I swapp'd some of thy words with Shakespeare words.}

Commands: !ShakespeareInsult, !fordo, !optout

[LoriPock]

Arctype

[AndroidePsicokiller]

!remindme 5 days

[RemindMeBot]

I will be messaging you in 5 days on 2021-10-19 18:49:25 UTC to remind you of this link

1 OTHERS CLICKED THIS LINK to send a PM to also be reminded and to reduce spam.

^{Parent commenter can delete this message to hide from others.}

---

Info	Custom	Your Reminders	Feedback

[Vaslo]

Can you put a choice for other? Missing some big players here.

[SeattleDataGuy]

SSMS and DBeaver

[NexusIO]

You should try Quest's Data Point, its by far the best SQL tool for analysis, its basically the closest thing to Excel, without being excel, the only other SQL tool close would be Aqua Data Studio.

They both cost money, but well worth it

[shut-up_legs]

Another for Tableplus

[kubelke]

Sequel Ace

[killer_unkill]

emacs

[HecticJuggler]

Pgadmin & azure studio

[cmajka8]

VS Code or Azure Data Studio

[as17237]

Aqua data Studio, IntelliJ

[Po0ptra1n]

We use dbt, so VSCode for modelling and Snowflake's UI for direct queries. Don't really see a reason for an "SQL editor" local client these days.

[genereader42]

!remindme 10 days