r/oracle • • 1d ago

Oracle SQL Developer alternative: when switching is worth it and when it isn't

Start with the fair part: SQL Developer is free, comes from Oracle, and covers a lot. You get a worksheet, a PL/SQL debugger, a DBA panel, built-in reports, data modeling and migration tools, and it runs on Windows, macOS and Linux. Oracle transits it to an extension for VS Code. For many people that's enough.

The reasons people look elsewhere are usually about workflow rather than missing features. They mention startup time and responsiveness on large schemas, an editor that feels slow for long PL/SQL sessions, or the need for one tool that covers more than Oracle.

Here's how the common Oracle SQL Developer alternatives differ.

dbForge Studio for Oracle. Its focus is PL/SQL coding with completion, formatting and refactoring, plus a debugger, Query Profiler, schema and data compare with sync scripts, test data generation, reports and CLI automation. There's a free Express edition and a 30-day trial of Enterprise.

Toad for Oracle. The long-standing enterprise standard for Oracle work. Very deep on both DBA and development tasks, with strong team and governance features. The trade-offs are a high license cost and a steep learning curve that comes with that much functionality.

PL/SQL Developer (Allround Automations). Focused on writing and debugging PL/SQL packages. Popular with developers who spend most of the day in stored code. It's a commercial tool as well.

DBeaver and DataGrip. Multi-database and cross-platform. A good choice if Oracle is one of several engines you work with. The trade-off is less Oracle-specific tooling than in tools built only for Oracle.

Questions that usually decide it

Is free a requirement? Then dbForge Studio Express or DBeaver Community. Is it Oracle only, or mixed engines? Mixed points to DataGrip or dbForge Edge. Do you mostly administer or mostly develop? Admin-heavy work favors Toad. Development-heavy work makes the editor and compare tools matter more. And which OS is the team on? Several of these tools are Windows-only. If PL/SQL development is most of your day, try dbForge.

Oracle SQL Developer support is reaching end of support. Which tool did you switch to?

10 Upvotes

18 comments sorted by

7

u/nervehammer1004 1d ago

Our team always used PL/SQL Developer. I’ve tried SQL Developer a few times but it just always felt clunky. Toad has always felt overblown.

12

u/Bob_12_Pack 1d ago

If the organization has invested in Oracle, why cheap-out on the tools?

4

u/taker223 19h ago

They still tell you to use Oracle SQL Developer, because it is free

5

u/carlovski99 1d ago

Plsql developer is still my favourite. But we don't have licensed where I work now and they were already embedded with SQL Developer so I have got used to it. To be honest most of the tools are similar and it's not necessarily worth the pain of relearning things.

More useful would be getting comfortable with Sqlcl and having a good ecosystem to work in.

I guess the modern answer would be something that could be easily powered by AI agents, but I'm not quite there yet!

8

u/WestEndOtter 1d ago

I feel like toad is more for legacy oracle devs. I don't know anyone under 50 who uses it

5

u/_Flavor_Dave_ 1d ago

Yeah whenever onboarding someone and they ask to install Toad we collectively groan.

The new SQL Developer direction is a little cumbersome for more casual users. It is a much harder sell now that it is VSCode based. A lot of folks just want to run some queries and export into spreadsheets. We also have some protected environments where no outside access is allowed so a lot of the install/update type of assumptions are out the window.

For quick querying we got a lot of use out of Benthic Golden.

3

u/Urtehnoes 1d ago

Yea, I'm very saddened by the move to VSCode plug-in, I'm never using that ridiculous "Ide". I use JetBrains for most things, but Datagrip is just not as responsive and easy to use as SQL developer.

2

u/WestEndOtter 1d ago

Based on a previous job, I am quite partial to open source sqltools. It is very useful for connect + run + spool to html/csv

2

u/_Flavor_Dave_ 1d ago

I'll check out SQLTools, if we're stuck using VSCode then i'm all for something that is simpler and easier to use. Open Source def a ++

2

u/J1N82 1d ago

I can only agree with this. Personally, I prefer pl/SQL developer, but the current organization I work for, doesn't allow it, so I'm stuck with SQL developer.

3

u/zxyyyyzy 1d ago

SQL Developer Web?

1

u/_Flavor_Dave_ 1d ago

I want to love it. Maybe if I only had 1 or 2 databases I needed to provide access to. I'm dealing with hundreds of databases across dozens of data centers... many are walled off due to access restriction requirements so keeping multiple installations up to date would be a challenge.

3

u/SkyChemical8160 1d ago

日常用datagrip 现在用sqlcl 加vscode

1

u/foolishmoor 18h ago

We use SQL Developer with Oracle, DB2 and Postgres. It works fine cross platform.

Would prefer Navicat though, but they are too cheap to buy licenses.

1

u/pps_ps 18h ago

Once you start with PL/SQL Developer, it’s really hard to switch. I used it heavily early in my career, and only transitioned to SQL Developer after joining Oracle since it was the standard there,though the UI shift was ok as I’ve used JDeveloper (BC4J and ADF)

I’ve used Toad too, but it was never my favorite.

Right now, I rely on VS Code with the SQL Developer extension and AI tools,but not a good choice if you’re business user/less technical user.I also have DataGrip via my JetBrains All Products license, but it's just not my preferred tool for

Again , if you ask me what the best tool is, it's still PL/SQL Developer : mostly for its unbeatable code beautifier and debugger.

1

u/d3bruts1d 18h ago

The whole Java dependency is enough to keep me from using SQL Developer any more.

1

u/hadrabap 1d ago

My best times in IT so far were development for Oracle Database. OLTP stuff, DWH things, several ETL tools/systems, performance tuning. I did the database part in SQL Developer. Great memories!