--- title: SQL Developer Reviews meta_title: 'SQL Developer Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 260 reviews by the users' company size, role or industry to find out how SQL Developer works for a business like yours. aggregate_rating: rating_value: 4.3 review_count: 260 scale: '5' date_modified: '2026-07-13' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # SQL Developer Reviews **Vendor:** Oracle **Category:** [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms) **Average Rating:** 4.3/5.0 **Total Reviews:** 260 ## About SQL Developer Oracle SQL Developer is a free, integrated development environment (IDE) designed to simplify the development and management of Oracle Databases across both traditional and cloud deployments. It provides a comprehensive suite of tools for PL/SQL application development, database administration, data modeling, and migration from third-party databases to Oracle. With over 5 million users, SQL Developer enhances productivity by offering a user-friendly interface for tasks ranging from running queries and scripts to debugging and testing PL/SQL code. Key Features and Functionality: - PL/SQL IDE: A full-featured environment for writing, compiling, debugging, and testing PL/SQL applications. - Database Administration: Tools for managing database performance, security, storage, and configurations. - Data Modeling: Capabilities to create Entity Relationship Diagrams (ERDs), generate reports, and perform SQL and DDL scripting. - Migration Platform: Facilitates the migration of databases from platforms like Microsoft SQL Server, Sybase Adaptive Server, IBM DB2, MySQL, Microsoft Access, and Teradata to Oracle. - Multiple Interfaces: Offers desktop, browser-based (Database Actions), and command-line (SQLcl) interfaces to cater to diverse user preferences. Primary Value and User Solutions: Oracle SQL Developer addresses the complexities associated with database development and management by providing an all-encompassing toolset that streamlines workflows. It eliminates the need for multiple disparate tools by integrating essential functionalities into a single platform, thereby reducing development time and operational costs. Its support for various interfaces ensures flexibility, allowing users to choose the environment that best fits their needs. Additionally, the migration capabilities simplify the transition from other database systems to Oracle, facilitating a smoother integration process. ## SQL Developer Pros & Cons **What users like:** - Users value the **efficient handling of database tasks** in SQL Developer, enabling quick query writing and debugging. (3 reviews) - Users appreciate the **intuitive navigation** of SQL Developer, making complex tasks feel simple and manageable. (2 reviews) - Users commend the **advanced analytics capabilities** of SQL Developer for detecting risks and producing audit-ready insights. (1 reviews) - Users value the **big data handling capabilities** of SQL Developer for analyzing large transaction datasets effectively. (1 reviews) - Users praise the **well-documented error codes** and tutorials of SQL Developer, making issue resolution straightforward. (1 reviews) - Users appreciate the **easy integrations** in SQL Developer, finding it simplifies complex database management tasks. (1 reviews) - Learning (1 reviews) - Navigation Ease (1 reviews) - Speed (1 reviews) - Time Saving (1 reviews) **What users dislike:** - Users often experience **slow performance** with SQL Developer, especially when handling large queries or databases. (2 reviews) - Users often face **connection issues** with SQL Developer, leading to frustrating delays before executing queries. (1 reviews) - Users find **difficult learning** for SQL Developer, especially with complex queries and limited testing capabilities. (1 reviews) - Users find **function limitations** in SQL Developer, especially in debugging complex queries and advanced feature capabilities. (1 reviews) - Users often find SQL Developer **slow with large databases** , which can impact overall system performance. (1 reviews) - Users find the **poor interface design** of SQL Developer to be laggy and less polished than modern tools. (1 reviews) - Small Business Limitations (1 reviews) ## SQL Developer Reviews ### 1. Good for a standalone database tool. **Rating:** 3.5/5.0 stars **Reviewed by:** Scott M. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 06, 2018 **What do you like best about SQL Developer?** I like the tool as a standalone database tool for modifying tables and cells. **What do you dislike about SQL Developer?** It doesn't have as many features as other database tools I've used in the past, but good overall. **What problems is SQL Developer solving and how is that benefiting you?** Modifying database tables, cells, running queries, etc. ### 2. The right tool for the right job **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Warehousing | Enterprise (> 1000 emp.) **Reviewed Date:** September 22, 2018 **What do you like best about SQL Developer?** Simplistic, guiding and efficient it gets the job done. **What do you dislike about SQL Developer?** A database source wizard would have been helpful when I first started out. **What problems is SQL Developer solving and how is that benefiting you?** SQL developer has been my go to when developing queries to use in a dashboard environment. ### 3. Great environment to manage and query multiple databases **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** June 01, 2018 **What do you like best about SQL Developer?** Easy management of multiple connections to different databases. The learning curve is not steep and is really ideal for developers that just need to do simple actions like queries.. **What do you dislike about SQL Developer?** For more complex actions, it might not be the best. The intuitiveness of where certain actions should be isn't too great, and sometimes takes multiple clicks just to get there. Also, the autocomplete does not function properly pretty often. **What problems is SQL Developer solving and how is that benefiting you?** With a low learning curve, it is easy to train new people on how to access our data. ### 4. Good experience with some fallbacks **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** April 19, 2018 **What do you like best about SQL Developer?** I like the integracion that it have (full) with Oracle product. I has plenty of functionalities for beginners and pros, if you like to go a little more further i recommend other tool like Toad. **What do you dislike about SQL Developer?** I dislike the incompatibilities between SQL Developer and (Java Version + Windows Version) that causes glitches on the gui. If you have some luck its a problem that will never reach you, but sometimes you need to change JDK used o touch some configuration to have it working properly (mainly on the gui) **What problems is SQL Developer solving and how is that benefiting you?** We heavily use Oracle database, with SQL Developers our Software Engineers connect to DBRMS. ### 5. Comparison of Oracle SQL Developer with some other same products in the market **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** October 26, 2017 **What do you like best about SQL Developer?** Saved Credential for users, Imp/Exp, GUI **What do you dislike about SQL Developer?** Its Slow, it Don't Remember my Condition **Recommendations to others considering SQL Developer:** It is a good tools to play with data, but it is not very good in speed, The most painful is not keeping your where conditions saved to apply on other tables, rather you will have to write where condition again even you want to use the same where condition for other tables. Imp and exp command are not available for database. Other features are as good as in the other such products, like SQL Server , etc. **What problems is SQL Developer solving and how is that benefiting you?** 1. As a developer I user it for Checking my data whether every column is updating correctly as per my code, 2. When users make mistakes I quickly fetch that data using it. 3. Create tables and Indexes for my projects. 4. Write Procedures. 5. Copy my sql command that I use in my programs and run in here to check for the syntax or other errors. 6. Show my clients users the data from here to proof many things like whether the data is updating correctly and that they have made mistakes in entries. etc. 7. In Short I must keep my SQL Developer window opened while writing database applications so that I can quickly check the reflections. ### 6. Easiest language for developers **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 05, 2018 **What do you like best about SQL Developer?** Much easier than python. Can streamline and do more things better than R or Python. It’s comprinke with many other tools like excel. **What do you dislike about SQL Developer?** I hate that if a syntax is incorrect it doesn’t tell you exactly what’s wrong **What problems is SQL Developer solving and how is that benefiting you?** Moving government data into another tool ### 7. Sub optimal DB management tool for a sub optimal DB(in most caese) **Rating:** 1.0/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Mid-Market (51-1000 emp.) **Reviewed Date:** April 24, 2018 **What do you like best about SQL Developer?** The product is free, relatively easy to use. **What do you dislike about SQL Developer?** This product is extremely unstable, the default shortcuts are counter intuitive (based on many other popular management tools ) some of which cause the software to crash. It is extremely unresponsive, with no visual indicator as to why. **Recommendations to others considering SQL Developer:** If you have to, its a fine solution. Buy toad if you can. **What problems is SQL Developer solving and how is that benefiting you?** Remote db access / management of oracle based DBs ### 8. one stop solution for all the database needs **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 13, 2017 **What do you like best about SQL Developer?** The user Interface is quite easy to interact with and very fascinating when it comes to manipulate with the data from the database **What do you dislike about SQL Developer?** When we have to remotely access database through a VPN (virtual private connection) connection and somehow if we forget to turn on the VPN(virtual private connection) and connect to database through SQL Developer, it takes time to respond and crashes in a rare scenario like this. **Recommendations to others considering SQL Developer:** I highly recommend this software as it helps you to manipulate data and manage database connections with ease. **What problems is SQL Developer solving and how is that benefiting you?** As a software engineer, while fixing a bug we need query data to understand if the query is returning correct data or not. hence this helps us rectifying the problem. ### 9. SQL Developer **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** April 30, 2018 **What do you like best about SQL Developer?** I love the ease of use. I can query data in an extremely easy fashion using my organization's metadata **What do you dislike about SQL Developer?** With not many Query tools to compare it too, it is difficult to say. I really enjoy the overall interface of this tool **What problems is SQL Developer solving and how is that benefiting you?** Organizational initiatives is the primary use ### 10. Reviewing sql developer **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Education Management | Mid-Market (51-1000 emp.) **Reviewed Date:** June 10, 2018 **What do you like best about SQL Developer?** Excellent developer tool for connecting to oracle data sources **What do you dislike about SQL Developer?** Nothing to dislike, very user friendly.. **What problems is SQL Developer solving and how is that benefiting you?** Generating sql queries and stored procedures ### 11. Great SQL tool! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Music | Small-Business (50 or fewer emp.) **Reviewed Date:** January 25, 2018 **What do you like best about SQL Developer?** The graphical tree on the left showing all the schema objects is great. There are also many useful toolbar buttons, right-click menus and drag & drop features. You can also now create connections to cloud databases. **What do you dislike about SQL Developer?** SQL developer occasionally freezes and crashes. Also there is no way to terminate an executing PL/SQL program once it has started. **What problems is SQL Developer solving and how is that benefiting you?** It has helped me write code faster and therefore be more productive. ### 12. Useful tool for connecting to Databases **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Education Management | Mid-Market (51-1000 emp.) **Reviewed Date:** January 18, 2018 **What do you like best about SQL Developer?** Easy to install, queries run fast, and let you know when there is an error **What do you dislike about SQL Developer?** It is slow to grab fields for you, ie: typing a table or alias and loading a list of available fields to choose from. **Recommendations to others considering SQL Developer:** Quick and easy to install, works with most SQL Database connections. **What problems is SQL Developer solving and how is that benefiting you?** Finding data issues in the database and generating data dumps for reports. ### 13. Sql Developer is very good free tool available for pl/sql development **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 30, 2017 **What do you like best about SQL Developer?** GUI is very good and it is helpful for developers to analyze the data and create a Entity Relationship Diagram. We can compare sql reports here. **What do you dislike about SQL Developer?** this should be more compatible for schema comparison. **Recommendations to others considering SQL Developer:** Its very good tool and free available on oracle website. Any one can take this and use it directly. **What problems is SQL Developer solving and how is that benefiting you?** Creating pl/sql program, sql scripts, er diagrams and code debug ### 14. Perfect light weight dB access tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 20, 2018 **What do you like best about SQL Developer?** Lightweight and not resource intensive like other dB access tools **What do you dislike about SQL Developer?** The level of explain plan representation is not comparable with toad **What problems is SQL Developer solving and how is that benefiting you?** It provides easier access to reports with a ui ### 15. Great tool **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 24, 2017 **What do you like best about SQL Developer?** Easy to use and very effective features to use for a database. The GUI is very good and it offers best competition to other database clients such as Toad. **What do you dislike about SQL Developer?** Nothing much to dislike but adding other new features is greatly appreciated. **What problems is SQL Developer solving and how is that benefiting you?** Logiing in to the database, running queries, exporting and importing data, graphical interface of the relational database etc. ### 16. Ease of work with SQL Developer **Rating:** 4.5/5.0 stars **Reviewed by:** Apeksha G. | UAT Analyst, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** September 20, 2017 **What do you like best about SQL Developer?** The easy to use interface makes your tasks easier. I also like the intellisense technology that gives you recommendations for auto-complete. It helps you save time **What do you dislike about SQL Developer?** It can use some advanced features as present int the tool TOAD **Recommendations to others considering SQL Developer:** I would highly recommend using SQL developer as the complete DB solution. **What problems is SQL Developer solving and how is that benefiting you?** I am working on RDBMS DML. It provides me with a much cleaner UI and makes it easier to interpret the results ### 17. Useful for using Oracle, make sure your JAVA is in order. **Rating:** 3.5/5.0 stars **Reviewed by:** John T. | Client Support, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 25, 2017 **What do you like best about SQL Developer?** It connects up to all of our Oracle databases, and it has a native client for every platform. **What do you dislike about SQL Developer?** I hate that by default it only loads 50 rows at a time. Also some bits are not very intuitive, or force the query to run a second time, for example trying to export data that was already displayed on your screen. This can be an extra pain for long queries. **Recommendations to others considering SQL Developer:** Make sure you have the latest JRE and JDK installed prior to installing it. If you only want to run one database tool, it does support plugins to allow you to connect to other data sources. I don't find it as intuitive as some other clients, but its common usage means there is a lot of documentation out on the web. **What problems is SQL Developer solving and how is that benefiting you?** Troubleshooting database information within technical support. It works well and helps us find and analyze things. ### 18. Good SQL client **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 16, 2018 **What do you like best about SQL Developer?** Best tool for connecting Oracle database server **What do you dislike about SQL Developer?** Nothing much to dislike, but preferred to have inbuilt support for other database like mysql and db2 **Recommendations to others considering SQL Developer:** Suggest to anyone looking for good reliable sql client **What problems is SQL Developer solving and how is that benefiting you?** helps in connecting the db server to perform CRUD operation ### 19. Free tool for sql development **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** January 03, 2018 **What do you like best about SQL Developer?** This is free available and support all oracle new feature for development and testing. **What do you dislike about SQL Developer?** data modeling is not advance and ER diagram is not good. **Recommendations to others considering SQL Developer:** definately. Yes. **What problems is SQL Developer solving and how is that benefiting you?** development. This is very good in terms of use and features. PL/SQL development is very easy with this tool. ### 20. SQL to create reports **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 24, 2017 **What do you like best about SQL Developer?** reliability and consistency are two great attributes **What do you dislike about SQL Developer?** sometimes it seems like the error messages are not accurately informing me of my mistake in my syntax **What problems is SQL Developer solving and how is that benefiting you?** we use SQL to run reports and pull data also to update or change data in production ### 21. Sql **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** December 27, 2017 **What do you like best about SQL Developer?** I like the warehouse and how easily Oracle could be integrated across applications. **What do you dislike about SQL Developer?** I think the language is quite limited. It is a bit different than Microsoft which was a change for me when I transitioned. **What problems is SQL Developer solving and how is that benefiting you?** Helping clients optimize their business. Improvement in top and bottom lines. ### 22. SQL Developer Reporting **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** December 06, 2017 **What do you like best about SQL Developer?** SQL Developer is a great beginner product for someone who is trying to learning SQL writing. **What do you dislike about SQL Developer?** Very basic. Could add more functionality for those who are trying to do more advance SQL writing. **What problems is SQL Developer solving and how is that benefiting you?** SQL Developer is used to write basic SQL statements for pulling information from our student database. ### 23. Great Data Extraction for Non-Profit Database **Rating:** 4.5/5.0 stars **Reviewed by:** Robby T. | Prospect Development Analyst, Senior, Higher Education, Enterprise (> 1000 emp.) **Reviewed Date:** January 24, 2017 **What do you like best about SQL Developer?** This software enables me to easily connect to my database and extract the specific information I need. I am able to join many different table and query based on many different criteria. The software program allows me to use long lists of criteria entries as well. It is intuitive, well organized and and fast. **What do you dislike about SQL Developer?** The password interface to connect to different database instances could use some work to be more intuitive and easier to change or lookup forgotten passwords. **What problems is SQL Developer solving and how is that benefiting you?** I am tasked with extracting specific data to be analyzed. The benefits of SQL developer include fast extraction of data, helpful troubleshooting, searchable queries and scripts, script key work highlighting and fast query building. ### 24. Does the job, but not too well **Rating:** 1.5/5.0 stars **Reviewed by:** Jared K. | Sr. Software Developer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2016 **What do you like best about SQL Developer?** Somewhat intuitive layout and the ability to store and easily access multiple different connections that have been previously setup easily and fast. **What do you dislike about SQL Developer?** Overall it's a clunky and often slow interface. There's no way to really get into the tables to edit data without right clicking on the table name IF it's in a select statement and going to "Open Declaration". It also handles unexpected disconnects poorly. The "Reconnect" menu item does not always work when the database has been unexpectedly disconnected and when it does work it sits for several seconds (maybe closer to 10) before it seems to realize the connection was already dropped and then it finally reconnects. Also, I believe it's when you disconnect then reconnect that it opens a new SQL window instead of allowing you to automatically start executing SQLs in the one you previously had open. You can use that window that was previously open, but you need to point it at the connection again. The execution plan is also not very intuitive. SQL Server Management Studio was designed much better. Toad, I hear, is a good replacement for SQL Developer. **Recommendations to others considering SQL Developer:** Use Toad instead. I have not used Toad myself, but many I work with use it and when I am working with them they seem to navigate it easily and they also all prefer it to SQL Developer. I really need to jump on the Toad bandwagon in my office. **What problems is SQL Developer solving and how is that benefiting you?** Maintaining a database for a CIS application. ### 25. Restart the product again **Rating:** 3.0/5.0 stars **Reviewed by:** Víctor B. | Presales Manager / Service Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** September 12, 2017 **What do you like best about SQL Developer?** Access to any number of Oracle databases **What do you dislike about SQL Developer?** It is always necessary to restart the application since it uses to lose the active connection **What problems is SQL Developer solving and how is that benefiting you?** Database modeling and mainteinance ### 26. Good basic program **Rating:** 3.0/5.0 stars **Reviewed by:** Isa D. | Web Administrator / Registrar, Primary/Secondary Education, Mid-Market (51-1000 emp.) **Reviewed Date:** October 31, 2016 **What do you like best about SQL Developer?** Easy to use. With this program you are up and running in no time. I love the feature that lets you store queries so you can pull them up later and run again. **What do you dislike about SQL Developer?** It seems inconvenient that you need to use another program to connect to the database before you can run SQL Developer. If I lose connection and the other program has to be reconnected, then SQL Developer will sometimes freeze. Then I'll have to restart and lose whatever query I am in the middle of building. **Recommendations to others considering SQL Developer:** SQL Developer will get you up and running fairly quickly. Good interface for writing queries that can be stored for later use. Works well with Oracle. **What problems is SQL Developer solving and how is that benefiting you?** I mainly use SQL Developer to query data from PowerSchool. When multiple tables are involved, pulling data is often easier and/or quicker with SQL Developer than with PowerSchool's build-in features. ### 27. Not as user friendly as MS SQL **Rating:** 1.5/5.0 stars **Reviewed by:** Verified User in Education Management | Small-Business (50 or fewer emp.) **Reviewed Date:** January 17, 2017 **What do you like best about SQL Developer?** This SQL interface is used in many different companies so it has coverage. The syntax is clear and similar to other SQL interfaces. **What do you dislike about SQL Developer?** This UI is not user friendly and seems to be bulky. It is hard to find tables easily. Poking around takes a lot of time to find what you need. **Recommendations to others considering SQL Developer:** SQL Developer is a bit clunky and not intuitive. There are many how-to's online that can help a user with this software. There are other SQL interfaces that are more intuitive for non-dev and non-dbas that might be more appropriate. **What problems is SQL Developer solving and how is that benefiting you?** Needed a quick way to pull data out of the DB. ### 28. Using SQL DEVELOPER **Rating:** 4.5/5.0 stars **Reviewed by:** SHAILESH P. | Software Developer, Telecommunications, Mid-Market (51-1000 emp.) **Reviewed Date:** January 24, 2017 **What do you like best about SQL Developer?** The easiness of using SQL developer is awesome. Its really comfortable to use. **What do you dislike about SQL Developer?** managing with mulitple connections sometimes founds a bit of problem with opening multiple tables and viewing data is from different connections is bit slow. **Recommendations to others considering SQL Developer:** Its really a good software to work on in terms of performance checking of queries. **What problems is SQL Developer solving and how is that benefiting you?** I write queries and PL SQL blocks on SQL developer to debug the issue and also for performance checking how costly the query is. ### 29. Not good enough but... free **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in International Affairs | Enterprise (> 1000 emp.) **Reviewed Date:** April 20, 2017 **What do you like best about SQL Developer?** The best thing is that SQL Developer is free (comes with Oracle installation), and also uses native libraries. Obviously, if you are using Oracle DBS, you will not have any connection problems. It's very easy to install, and it has a very good support **What do you dislike about SQL Developer?** There are much much better options in the market, specially TOAD and PLSQL Developer, but, they are not free. SQL developer is slow, very slow, and believe it or not, it has a lot of bugs. Also the interface is not very friendly. **What problems is SQL Developer solving and how is that benefiting you?** At least, provides all the necessary to a developer to work with Oracle DBs ### 30. Perfect Database product **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2017 **What do you like best about SQL Developer?** I am currently using PL/SQL developer at my place of employment. Its a very easy tool to analyze data and perform arithmetic operations on data. The UI is simple and makes it easy to type large codes. Querying data is really fast. **What do you dislike about SQL Developer?** The PL/SQL developer lacks certain features like data import. If you need to import data from an external object you would need additional tools like access. Also moving around schema can get sometimes get tough. Timestamp fields are also difficult to view. You either need to see empty timestamp like 00:00 if the original column did not have time element or if you alter the NLS you cannot see the time element even if the column had time data. **Recommendations to others considering SQL Developer:** Going good. **What problems is SQL Developer solving and how is that benefiting you?** Data analysis. ### 31. Simple and Easy Tool for Oracle DB **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Enterprise (> 1000 emp.) **Reviewed Date:** November 03, 2016 **What do you like best about SQL Developer?** I use sql developer to go look up oracle information directly from the backend tables rather than going through oracle forms. Save so much time once you learn the table structures. The tool can also help you build some simple scripts/reports. Ability to view the code behind custom oracle views they have behind the forms. **What do you dislike about SQL Developer?** In my experience, browsing through the objects/fields by expanding/collapsing is very slow. Also exporting large result sets in excel format sometimes crashed. **Recommendations to others considering SQL Developer:** You can save so much time by learning the table structures and using this tool to directly lookup information without having to go through oracle forms. Also a great took to do some data analytics. **What problems is SQL Developer solving and how is that benefiting you?** Build simple reports, check on Oracle setting across multiple organizations from a single place using a simple script. ### 32. The standard GUI for databases **Rating:** 5.0/5.0 stars **Reviewed by:** Joseph H. | Software Engineer, Defense & Space, Enterprise (> 1000 emp.) **Reviewed Date:** September 08, 2016 **What do you like best about SQL Developer?** Written in Java (I think), it can interface pretty much with any database that has a JDBC connector. You might have to tell it where the appropriate jar is, but that's not too difficult. Navigating tables, views, etc is pretty easy, much like navigating a file system. **What do you dislike about SQL Developer?** If a query is taking a long time, SQL developer will freeze. **Recommendations to others considering SQL Developer:** Another case of "everyone uses it, so you might as well use it." Any SQL queries you develop using it will work outside of SQL developer anyway. **What problems is SQL Developer solving and how is that benefiting you?** Designing and developing database schemas to solve various problems, both in the classroom and in the real world. So much easier than a command line interface. ### 33. Useful but needs improvements **Rating:** 3.0/5.0 stars **Reviewed by:** Rubén S. | Senior software engineer, Enterprise (> 1000 emp.) **Reviewed Date:** October 19, 2016 **What do you like best about SQL Developer?** This application is very easy to use. You can add many connections and browse different schemas easily. The SQL completion works very well and it has additional features like database comparison or database copying. **What do you dislike about SQL Developer?** The application has some performance issues, if you keep the application open but idle for some time it becomes unresponsive (at least the linux version). **What problems is SQL Developer solving and how is that benefiting you?** I'm web application developer and I use it for DB schema creation and manipulation, as well as data checking. ### 34. SQL Developer Product Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Investment Banking | Enterprise (> 1000 emp.) **Reviewed Date:** August 05, 2016 **What do you like best about SQL Developer?** It is easy to use and provides plugin to major vendors like Sybase , Oracle , MySQL and SQLServer. One can easliy view the table and its DDL structure.One can amend the data in bulk through the GUI provided.One can create and run stored procedures , triggers through SQL Developer also. **What do you dislike about SQL Developer?** It works well with oracle but for Sybase tables i doesn't show the constraints and indexes of a particular table. **Recommendations to others considering SQL Developer:** Please use this tool.The basic version is free and does most of the job needed for a SQL Programmer.It can run SQL Queries , enable you to view the table structure , amend the data in bulk and allow one to run queries on Sybase and MySQL tables as well.One can write stored procedures , triggers and views as well. using SQL Developer.It also allows one to import or export data in tables. **What problems is SQL Developer solving and how is that benefiting you?** I am currently working on an MIS Application for which I use SQL Developer for viewing tables and running queries and stored procedures. ### 35. Does what it needs to do **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** September 08, 2016 **What do you like best about SQL Developer?** The little limitation that SQL has on file size versus Excel, obviously! The interface is pretty simple but kind of archaic at the same time. It doesn't necessarily have to have a beautiful interface to be trustworthy but it might be less scary to novices/beginners. **What do you dislike about SQL Developer?** As somewhat of SQL novice, I don't like when there are errors, SQL doesn't show you how to fix them as it does in Excel. Perhaps that is part of the understanding with SQL, that you are expert enough to know where you code is broken. **What problems is SQL Developer solving and how is that benefiting you?** We get multiple sources of data in different file formats and SQL is great at combining files, especially large ones. It is nice to have a repository for these files and be able to link different data points into one table. ### 36. A decent basic SQL editor **Rating:** 2.5/5.0 stars **Reviewed by:** Sean S. | Oracle Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** May 04, 2016 **What do you like best about SQL Developer?** SQL Developer is a simple interface for basic coding and it has a robust set of customizations available, as well as integration with version control tools like git and SVN. **What do you dislike about SQL Developer?** As a OS X user, I find that there are a fair number of features that just don't work, or only work with extensive manual modifications to the code base. I'd prefer a tool that worked reliably out of the box. For example, if you want to use the "Reset password" feature you have to install the separate Instant Client, then go in and edit the launcher tool to set paths correctly for Darwin. Simply put, if the tool is available for a popular OS, features should be tested and working or made unavailable until they are. **Recommendations to others considering SQL Developer:** It may be worthwhile to evaluate alternative tools if you're looking for something to do more than basic database queries. **What problems is SQL Developer solving and how is that benefiting you?** Sometimes a GUI is nice. We have a lot of non-database developers that use SQL*Developer as a means of connecting easily with the database, which simplifies their lives. ### 37. SQL Developer - integrated development environment **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** August 26, 2016 **What do you like best about SQL Developer?** 1. Easy to install by simply unzipping the downloaded file and running the executable 2.Beneficial to users of alternative platforms 3.Client server network traffic can be avoided by using Oracle SQL Developer because users of Oracle SQL Developer can install this software on the Database server and the users can be remotely connected from their desktops 4.Oracle Home is not required while using Oracle SQL Developer as the connectivity to the database is via JDBC thin driver 5.It is free **What do you dislike about SQL Developer?** 1. Absence of the schema browser in SQL Developer 2.Absence of a Modeler and Data Modeling features **What problems is SQL Developer solving and how is that benefiting you?** 1.Run analytical queries to test the performance of the different reports used in the day to day business. 2. Data maintenance and monitoring for the business applications ### 38. SQL Developer tools **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Enterprise (> 1000 emp.) **Reviewed Date:** January 15, 2017 **What do you like best about SQL Developer?** The tool has many UI icons and interfaces to build and execute queries. Also, the export/import features are nice. The prompts with the table/database/view name for accurate object names. **What do you dislike about SQL Developer?** The connection hangs very often and needs to be reconnected. many times the application needs to be restarted and you might loose all your open data. this is very irritating. **Recommendations to others considering SQL Developer:** To avoid connection timeouts disconnect and reconnect your connections according to use. **What problems is SQL Developer solving and how is that benefiting you?** I manage my application database through it. for testing new queries and for data modelling. ### 39. Convenient SQL Editor **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** February 03, 2017 **What do you like best about SQL Developer?** SQL Developer is a free sql programmer for oracle DBA. It is very convenient and easy to use. **What do you dislike about SQL Developer?** Data exporting in Microsoft Excel format does not work for huge data. **Recommendations to others considering SQL Developer:** I recommend to others to use the native sql developer implemented by Oracle company. **What problems is SQL Developer solving and how is that benefiting you?** Daily usage for Oracle database management. Nothing special. ### 40. A great companion to Oracle Database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 30, 2016 **What do you like best about SQL Developer?** Native support to Oracle Database, has all the features that are needed for Oracle DB, free and powerful SQL IDE. **What do you dislike about SQL Developer?** Support Oracle DB only. If you need to work across different DB engines, you have to use other tools such as Navicat. **Recommendations to others considering SQL Developer:** If you are using Oracle DB, that is the number one tool you should consider first. **What problems is SQL Developer solving and how is that benefiting you?** We are using SQL developer to manage database tables, triggers, procedures. We also use it to debug and test SQL statements. ### 41. Oracle SQL Developer **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** August 12, 2016 **What do you like best about SQL Developer?** Love Oracle SQL Developer. It is my tool of choice as a DBA and Programmer. There are so many different tools in this software package. I am a Mac user and I was very happy to see this. So easy to set up and use. Can't beat the cost too. **What do you dislike about SQL Developer?** The one thing I would say is a disadvantage of Oracle SQL Developer is that it is memory intensive. I have a problem with memory hogs like this. **What problems is SQL Developer solving and how is that benefiting you?** Yes absolutely. We all use this tool to write adhoc queries and some reporting. ### 42. SQL Developer as everyday tool **Rating:** 2.0/5.0 stars **Reviewed by:** Jan P. | Senior Software Developer, Internet, Mid-Market (51-1000 emp.) **Reviewed Date:** March 30, 2016 **What do you like best about SQL Developer?** It is one of the few IDE for PL/SQL development which can be run on OSX and Windows and it is trying to be real IDE not just notepad with syntax highlight (but still so much to achieve). **What do you dislike about SQL Developer?** Instability and plenty of annoying bugs, which leads to restarting SQL developer at least twice a day (and I'm not counting that it at least twice a day dies spontaneously) **Recommendations to others considering SQL Developer:** On OSX there is not so many choices, on windows you can choose better. **What problems is SQL Developer solving and how is that benefiting you?** fulltime PL/SQL development of financial application ### 43. Handy tool but only have core functionality **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 20, 2016 **What do you like best about SQL Developer?** Core functionality. Simple and light and it is free **What do you dislike about SQL Developer?** No additional functionalities such as Table relation diagram. **What problems is SQL Developer solving and how is that benefiting you?** Its free so easy test script, modify DB ### 44. Intuitive and Free SQL Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2016 **What do you like best about SQL Developer?** While the license of SQL Developer is a proprietary license by Oracle, it is a free product. It is very easy to pick up and get started with intuitive tools and user interface. **What do you dislike about SQL Developer?** Like some of the other tools from Oracle, the software can be a bit buggy and crash often. I've noticed this using the SQL Developer software on Mac OSX. **Recommendations to others considering SQL Developer:** Since it's free, it's definitely recommended to give it a download. Take a look at the various plugins that are available since it can expand the functionality of the software. **What problems is SQL Developer solving and how is that benefiting you?** I've been using this tool with various clients to manage some simple relational databases. Since it's a completely free product, I can throw it on all of my machines when I need to manage the database side of the projects. ### 45. SQL Developer Review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Import and Export | Enterprise (> 1000 emp.) **Reviewed Date:** May 31, 2016 **What do you like best about SQL Developer?** Easy to use, rarely ever have problems with it crashing etc **What do you dislike about SQL Developer?** Only wish that there was an easier way of organizing the various scripts that I have. I usually jjust comment them out. **What problems is SQL Developer solving and how is that benefiting you?** I am running different scripts for programs daily. I update files daily. It helps us push out files and keep organized with invoices. ### 46. Powerful Database Tool that grows with you **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.) **Reviewed Date:** January 11, 2016 **What do you like best about SQL Developer?** I've been able to connect to several variants of databases with a single installation of Oracle SQL Developer. By utilizing the External Plugins DLL extension, I've successfully used this tool to interface with IBM DB2, PostgreSQL, Oracle DBs, MySQL, Sybase, SQLServer, and Access. Whatever you throw at this thing, you can find a way to connect to your database. The UI is easy to walk through and once you learn how to pin tables, it is an easy tool to compare tables side by side. **What do you dislike about SQL Developer?** Installation was not as straight forward or out-of-the-box. Plugins can be a little tricky at first and may take a few tries to get configured correctly. It would be great if there was an easier way of sharing connections with colleagues to allow for quicker team set up. **What problems is SQL Developer solving and how is that benefiting you?** Internal business applications for support. ### 47. more than five years to take use of this tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2015 **What do you like best about SQL Developer?** manipulate many multiple databases at the same time, that's great for us to work on different environments. **What do you dislike about SQL Developer?** It took too much memories even if only open one tab. **Recommendations to others considering SQL Developer:** I'd like to take use of this tool to manipulate the oracle DB **What problems is SQL Developer solving and how is that benefiting you?** manipulate many multiple databases ### 48. User friendly **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2016 **What do you like best about SQL Developer?** The Interface is very user friendly, its pretty easy to figure out for a first time user. I use the built-in filter feature a lot and the fact that I can connect to and query multiple instances of databases on the same interface is nice. **What do you dislike about SQL Developer?** It can get too slow some times. Throws weird errors when connected for too long **What problems is SQL Developer solving and how is that benefiting you?** used to manage oracle databases ### 49. Easy and Quick from installation to learning and using!! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 08, 2016 **What do you like best about SQL Developer?** This is peobably the first and the oldest tool i have worked upon. I really had no learning curve. It easy and free to install. It allows you to connect to your database with any complications. **What do you dislike about SQL Developer?** The only thing that i did not like was that there have been absolutely no major improvements. Its been the same for a few years now. **Recommendations to others considering SQL Developer:** Its way better than many other free or cheap softwares available in the market. This is worth giving a try.. **What problems is SQL Developer solving and how is that benefiting you?** We used it for campaign management. It helped in developing, executing, prioritizing and reporting multi-channel based campaigns to successfully acquire/retain and enhance revenue. ### 50. Great product for multiple database technologies. **Rating:** 5.0/5.0 stars **Reviewed by:** Brad K. | Software Developer and Consultant, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** July 15, 2015 **What do you like best about SQL Developer?** Despite being developed by SQL Developer allows users to easily manage connections Oracle databases as well as to a multitude of database technologies such as SQL Server, Mysql, and Teradata through third party plugins. The tool is very intuitive, and you can't beat the free price. **What do you dislike about SQL Developer?** After idling for a long time, the application will occasionally stop responding and the user may be forced to quit. A similar problem exists when refreshing connections to a database after the connection times out. It can be a hassle to restart the application. **Recommendations to others considering SQL Developer:** You can't beat this level of a product for free! SQL Developer beats many other non-free database front-ends. **What problems is SQL Developer solving and how is that benefiting you?** Data integration tasks using Oracle FDMEE and ARM. ## SQL Developer Discussions - [Do you plan to develop multi-filter features (ie creating multiple filters, and using them when it is needed)?](https://www.g2.com/discussions/47152-do-you-plan-to-develop-multi-filter-features-ie-creating-multiple-filters-and-using-them-when-it-is-needed) - 1 comment, 1 upvote - [What is SQL Developer used for?](https://www.g2.com/discussions/what-is-sql-developer-used-for) - 1 comment - [What is the use of SQL Developer?](https://www.g2.com/discussions/what-is-the-use-of-sql-developer) - 1 comment - [View SQL Developer pricing details and edition comparison](https://www.g2.com/products/sql-developer/reviews?page=5&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-07-14+21%3A18%3A31+-0500&secure%5Bsession_id%5D=d0aa9569-5e73-462b-9cd8-eabb0f2fe560&secure%5Btoken%5D=f9fabfd0d1e837ea7e6614746df92b998023d6a22e7d9fb119b185b3e3b3bb91&format=llm_user) ## SQL Developer Integrations - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/reviews) ## SQL Developer Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Security** - Data Encryption - User Access Control ## Top SQL Developer Alternatives - [Toad For Oracle](https://www.g2.com/products/quest-software-toad-for-oracle/reviews) - 4.4/5.0 (281 reviews) - [DbVisualizer](https://www.g2.com/products/dbvisualizer/reviews) - 4.7/5.0 (263 reviews) - [phpMyAdmin](https://www.g2.com/products/phpmyadmin/reviews) - 4.3/5.0 (167 reviews)