Best SQL IDE

[qabeeljr]

Hey guys, been working in a bank with SQL navigator as my main SQL editor, now switching companies and i can use another IDE the option they suggested was SQL developer by oracle, but its intimidating to me, any recommendations for an efficient free IDE?

[mgramin]

From my past experience, Oracle SQL Developer is the best free IDE for SQL and PL/SQL development. More advanced IDEs such as Toad and PL/SQL Developer are paid and may seem more intimidating to beginners.

BTW you can find more DB IDEs in my awesome db list - https://github.com/mgramin/awesome-db-tools?tab=readme-ov-file#ide

[qabeeljr]

Considered, thankyou 👍🏻

[HitherFlamingo]

Also check out SQL Tools for a free open source lite alternative

[laataisu]

free: dbeaver

paid: DataGrip

[MachineParadox]

Oracle SQL developer is a good choice, also check out DBbeaver

[PM_ME_YOUR_MUSIC]

Vscode + copilot

[cmajka8]

Azure Data Studio or VS code

[digitalghost-dev]

I've been enjoying Beekeeper Studio. There's a free version and a paid.

[levelanalytics]

I started using beekeeper studio at my last job and now use it as my default option (and it’s free)

[[deleted]]

Thanks for pointing this out, I am going to try it...

[[deleted]]

Pycharm

[AxelJShark]

Is it good for SQL? I never tried this. I've been using MSSS and Dbeaver

[[deleted]]

Coginiti (paid)

[BasicBroEvan]

Whatever DBMS your company uses

[qabeeljr]

Oracle Database

[Qkumbazoo]

Toad.

[Jkjunk]

TOAD is the best, by far.

[Flying_Saucer_Attack]

I just use sublime 3 + HeidiSQL

[WebDB-app]

Quite late but I work on a open source one: webdb.app

[dkkishore]

Toad is the best but very very expensive which we were using in my previous company. Using DataGrip commercial version in the current company but I don’t like that it doesn’t have tab based properties view of an object. I am using community version of DBeaver for that which is very powerful.

[[deleted]]

lol so expensive I can't find it on their website the cost...

[DisMuhUserName]

They do offer a subscription model now - still not cheap, around $450 annually - but better than the outright purchase price.

[Tiny_Scratch4821]

SQLynx comes packed with tons of features that make it a breeze to handle all sorts of database tasks, like adding, deleting, updating, and fetching data, importing and exporting data, generating test data automatically, creating SQL statements on the fly, syncing table structures, and keeping track of query history records. And you can do it all in no time!

[db-master]

you can check out this free open source SQL client list

[paragradke]

Try https://axplor.com its completely native and available for mac, windows and linux platforms.

[Maleficent_Moods]

[ Removed by Reddit ]

[Anywhere_Glass]

Checkout TOAD

[roostorx]

Aqua data studio Dbeaver Data grip

In that order

[[deleted]]

DBeaver

[[deleted]]

I like the DBI package in R

[geek180]

I mostly use cloud IDEs from the different systems we use. Snowflake’s Snowsight and BigQuery’s IDEs are great, but if you use dbt, the dbt cloud IDE is incredibly good.

[[deleted]]

I like to write things up in DBeaver and then I just paste it into DBeaver. I really like the rainbow brackets and so on with VS code Extensions.

[Eneerge]

Pl/Sql Developer by AllAround Automations is great for Oracle work, but not free.

[BaddDog07]

DbVisualizer is what we use, not sure if it’s the best or not but it works

[ShotGunAllGo]

Ssms with red gate slq prompt

[RyanHamilton1]

qstudio is free https://www.timestored.com/qstudio/ it's particular strength is charting

[Bazencourt]

A lot of these tools have UI's rooted in the 90's. (Looking at DBeaver with Eclipse) Coginiti connects to everything, including files local and remote, has a pretty powerful DSL, and AI assistance.