The G2 on SQL Developer

SQL Developer Pros and Cons: Top Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users value the ease of use in SQL Developer, praising its intuitive interface and comprehensive documentation. (4 mentions)

Users appreciate the efficiency in handling database tasks with SQL Developer, streamlining their workflow significantly. (2 mentions)

Users find the well-documented error codes and tutorials helpful for explaining issues and resolving doubts effectively. (1 mentions)

Users appreciate the easy integrations in SQL Developer, streamlining queries, tuning, and database management seamlessly. (1 mentions)

Users appreciate the intuitive syntax and UI of SQL Developer, enhancing their data manipulation and project building experience. (1 mentions)

Users experience slow performance with SQL Developer, particularly when handling large databases and queries. (3 mentions)

Users report frequent connection issues that lead to delays and affect the overall usability of SQL Developer. (2 mentions)

Users experience slowness with large databases, which can hinder performance and user satisfaction. (1 mentions)

Users find the poor interface design of SQL Developer contributes to a sluggish and outdated experience with the tool. (1 mentions)

Top Pros or Advantages of SQL Developer

1. Ease of Use

Users value the ease of use in SQL Developer, praising its intuitive interface and comprehensive documentation.

See 4 mentions

See Related User Reviews

Jahnavi Y.

Enterprise (> 1000 emp.)

4.5/5

"Best tool for using SQL and database management"

What do you like about SQL Developer?

User friendly interface, shortcuts and options to handle the sql code

Verified User

Mid-Market (51-1000 emp.)

5.0/5

"It's great for teaching"

What do you like about SQL Developer?

It's easy to explain to the people and clarify their doubts and also each error code is well documented when it triggers on the basis of which you can

2. Database Management

Users appreciate the efficiency in handling database tasks with SQL Developer, streamlining their workflow significantly.

See 2 mentions

See Related User Reviews

Neeraj D.

Small-Business (50 or fewer emp.)

5.0/5

"Understanding SQL Developer: Easy Data Management"

What do you like about SQL Developer?

The best thing about SQL Developer is its ability to efficiently handle database tasks. I can write, test, and debug SQL queries quickly, which helps

Verified User

Enterprise (> 1000 emp.)

3.5/5

"Intuitive and All-in-One, But UI Feels Outdated and Sometimes Slow"

What do you like about SQL Developer?

It iIt can feel slow or laggy at times, especially with large queries or connections. Some features are a bit outdated compared to modern database to

3. Documentation

Users find the well-documented error codes and tutorials helpful for explaining issues and resolving doubts effectively.

See 1 mentions

See Related User Reviews

Verified User

Mid-Market (51-1000 emp.)

5.0/5

"It's great for teaching"

What do you like about SQL Developer?

It's easy to explain to the people and clarify their doubts and also each error code is well documented when it triggers on the basis of which you can

4. Easy Integrations

Users appreciate the easy integrations in SQL Developer, streamlining queries, tuning, and database management seamlessly.

See 1 mentions

See Related User Reviews

Verified User

Enterprise (> 1000 emp.)

3.5/5

"Intuitive and All-in-One, But UI Feels Outdated and Sometimes Slow"

What do you like about SQL Developer?

It iIt can feel slow or laggy at times, especially with large queries or connections. Some features are a bit outdated compared to modern database to

5. Features

Users appreciate the intuitive syntax and UI of SQL Developer, enhancing their data manipulation and project building experience.

See 1 mentions

See Related User Reviews

Arpit K.

Mid-Market (51-1000 emp.)

5.0/5

"An amazing data analysis and management tool"

What do you like about SQL Developer?

As an SQL developer I really like to play with data. It is good and easier to use SQL . The best part in SQL is it's syntax and UI which we can use an

Top Cons or Disadvantages of SQL Developer

1. Slow Performance

Users experience slow performance with SQL Developer, particularly when handling large databases and queries.

See 3 mentions

See Related User Reviews

Jahnavi Y.

Enterprise (> 1000 emp.)

4.5/5

"Best tool for using SQL and database management"

What do you dislike about SQL Developer?

Sometimes take time to open and run the queries. Everything is fine other than that.

Neeraj D.

Small-Business (50 or fewer emp.)

5.0/5

"Understanding SQL Developer: Easy Data Management"

What do you dislike about SQL Developer?

It can be slow with big databases and may feel a little heavy on the system at times.

2. Connection Issues

Users report frequent connection issues that lead to delays and affect the overall usability of SQL Developer.

See 2 mentions

See Related User Reviews

Arpit K.

Mid-Market (51-1000 emp.)

5.0/5

"An amazing data analysis and management tool"

What do you dislike about SQL Developer?

As such I like nothing about sql it's easier to use some time there is connection issue which occurs and it's not an big deal I think.

Verified User

Mid-Market (51-1000 emp.)

5.0/5

"It's great for teaching"

What do you dislike about SQL Developer?

I think it takes too long to connect to their server due to which tho the query execution time is low

3. Limitations

Users experience slowness with large databases, which can hinder performance and user satisfaction.

See 1 mentions

See Related User Reviews

Neeraj D.

Small-Business (50 or fewer emp.)

5.0/5

"Understanding SQL Developer: Easy Data Management"

What do you dislike about SQL Developer?

It can be slow with big databases and may feel a little heavy on the system at times.

4. Poor Interface Design

Users find the poor interface design of SQL Developer contributes to a sluggish and outdated experience with the tool.

See 1 mentions

See Related User Reviews

Verified User

Enterprise (> 1000 emp.)

3.5/5

"Intuitive and All-in-One, But UI Feels Outdated and Sometimes Slow"

What do you dislike about SQL Developer?

It can feel slow or laggy at times, especially with large queries or connections. Some features are a bit outdated compared to modern database tools,

Top-Rated Alternatives

View All Alternatives

G2 reviews are authentic and verified.

Here's how.

Megha K.

Enterprise (> 1000 emp.)

1/16/2024

"Best IDE for SQL and Oracle Databases"

5/5

What do you like best about SQL Developer?

SQL Developer is easy to use, handy tool. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Heavy IDE that takes a lot of memory to start. Review collected by and hosted on G2.com.

Deepak A.

Software Engineer

Mid-Market (51-1000 emp.)

4/26/2024

"The best SQL tool ever"

4.5/5

What do you like best about SQL Developer?

We can connect to many servers at once and work on them simultaneously. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing to dislike, everything is good and works smooth. Review collected by and hosted on G2.com.

Shreya .

Package Specialist

Enterprise (> 1000 emp.)

11/16/2023

"Robust tool with various advantages"

4.5/5

What do you like best about SQL Developer?

User Friendly Interface,SQL Coding and Editing,Database Administration tools & Integration with Oracle products Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

It's an intensive resource with a steep learning curve and have limited non-oracle database support Review collected by and hosted on G2.com.

What problems is SQL Developer solving and how is that benefiting you?

Transferring data between different databases, importing/exporting data in various formats, and managing data movement within Oracle databases. Performing administrative tasks such as user management, schema comparison, indexing, backup and recovery, and monitoring database performance. Generating reports and visualizing data using graphical tools within SQL Developer, allowing users to analyze and present data in a more understandable format. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

11/12/2023

"Development tool to handle data base"

5/5

What do you like best about SQL Developer?

SQL Developer tool provide an integrated development environment to handle SQL commands on the platform.

It is user friendly and easy to use.

This platform provide an environment wher we can execute our SQL command to handle the data in database. Her we can connect to the Oracle data base and handle the tables database in it.

It is platform indipendent and user friendly platform.

Error fixing and customer support is quite good when compared to other platform.

We can also use a option to export or import the data in database. Using this feature we can export data and import in other Oracle database by importing the exported file in it.

We can also use the backup functionality to backup the data from loss.

Here we can also share or send the sql commands we execute in one system to other system by saving the sql file. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There is no dislike as per the platform but some time faced issue to connect data base. Review collected by and hosted on G2.com.

What problems is SQL Developer solving and how is that benefiting you?

I can easily connect database and use the data in it.

The IDE is platform indipendent and can use the integrated development environment functionality wher we not need to write entire command it will automatically popup the next executable commands or provide the options to select.

I can easily find errors and fix it. I can use this tool in mac and windows.

I can easily write the sql commands and handle the methods storprocedure and indexes easily.

The main problem I solved using this developer tool is it is a user friendly tool to connect and maintain database wher I can create user login as well.

I can easily save the commands that I executed to handle the database by saving the file and send to my local and open it in other PC or laptop.

I use the functionality of import and export the data base from one device to other in a simple and faster way by using this tool.

This tool also provide the backup functionality to backup the database on the shedule manner we select. Review collected by and hosted on G2.com.

Lisandro F.

Data Engineer Sr Consultant

Mid-Market (51-1000 emp.)

9/12/2023

"All required features in a single free tool"

4.5/5

What do you like best about SQL Developer?

SQL Developer is very simple to install and use, while includes dozens of features that allow you to connect, design, develop, monitor and administer an Oracle database. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Being a JAVA application, sometimes it is slow to open new tabs and performing some actions at UI level compared with native compiled tools. Review collected by and hosted on G2.com.

Daniel F.

Programming/Analyst

Enterprise (> 1000 emp.)

4/1/2017

"Best SQL IDE out there!"

4.5/5

What do you like best about SQL Developer?

SQL Developer integrates everything I've ever wanted or needed to do developing in SQL. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

There's an occasional time that a query/process won't be able to be stopped and I must kill the application. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Developer:

It's a highly used software, and for good reason. I believe it's the best SQL IDE available. I can quickly work through it creating my SQL scripts. I feel very enabled using it. Review collected by and hosted on G2.com.

What problems is SQL Developer solving and how is that benefiting you?

Quick development of SQL scripts with built in tools to create tables/links/synonyms, etc. Review collected by and hosted on G2.com.

Chandan T.

Software Engineer

Mid-Market (51-1000 emp.)

10/5/2023

"Simplest tool for querying multiple DB"

5/5

What do you like best about SQL Developer?

Pretty simple and straightforward.

Jdbc driver upload option is fine and simple.

SQL script writing and result exporting options.

Built-in feature to write/update data without having knowledge of SQL language Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Nothing in this tool to be disliked. It has got almost everything what a developer would require. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

2/14/2024

"Easy to use open source tool"

5/5

What do you like best about SQL Developer?

It has been around for very long & hence has huge support base. It is the go to tool for connecting with Oracle database. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Export functionalities are limited and sometimes few excel functionalities do not work. Review collected by and hosted on G2.com.

Sheraz A.

Professional Freelancer

Mid-Market (51-1000 emp.)

10/6/2023

"SQL Developer your Database Solutions"

5/5

What do you like best about SQL Developer?

SQL Developer give you dynamic data management solutions, he use different keys like primary, foreign key to make the smart solutions for getting data from database as early as possible to accomodate user requirements, He use different tools to create database which be managed easier Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

If manual procedure adapt to create database it will affect the data performance and fetching and database management after deployment it's difficult to reengineering the database Review collected by and hosted on G2.com.

Saifali N.

Talent Acquisition Specialist

Small-Business (50 or fewer emp.)

10/25/2023

"Good Field"

5/5

What do you like best about SQL Developer?

SQL Developer offers a wide range of feactures for managing databases,It is very User-friendly and in-build interface. Users can perform tasks likecreating, editing, and deleting database objects, generating reports, and managing data efficiently. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

SQL Developer itself is free but some oracle specific features such as advanced debugging and tuning capabilities may require seperate licensing or use of additional oracle products. Review collected by and hosted on G2.com.