product logo Oracle SQL Developer - Extensions Exchange

SQL Developer is developed in Java leveraging the Oracle Fusion Client Platform. As such, users can write their own extensions to add functionality specific to their requirements. This page comprises a list of the extensions created by SQL Developer users, both outside Oracle and written by other development teams within Oracle. SQL Developer extensions range from basic XML extensions through the range to complex Java extensions.

Special Note Regarding Extensions Developed Prior to SQL Developer v4.0:
With the new release of SQL Developer 4.0, an extension that was written for a previous version of SQL Developer will no longer work. SQL Developer is built on the JDeveloper Framework. We have updated the framework to be current with the JDeveloper 12c release. With JDeveloper 11gR2, they switched to an OSGI framework. The JDeveloper team has published instructions for updating your extensions to be compatible with the new framework and SQL Developer v4.0.

The Check for Updates interface has been updated to hide any 3rd party extensions to avoid confusion with extensions not loading. Once you have updated your extension for version 4 and beyond, let us know, and we'll update the system to make it available again. For questions regarding the process of going from the old to new framework, we have started a dedicated thread on the Forums. You can also email the Product Manager, Jeff Smith, to setup a call with one of our developers for additional assistance.

 

Available Extensions

For each extension, go to the URL given for details on how to install it. Some extensions are also available through the Check for Updates facility in SQL Developer. Report extension related problems to the extension provider. Questions regarding exchange development and including your extension in this list or in the SQL Developer Check for Updates interface can be sent via email to jeff.d.smith@oracle.com.

 

Available Extensions for Oracle SQL Developer 3.2.x


Name Details Logo/Image
Fourth Elephant (Insider for SQL Developer)
  • Description: With Insider for SQL Developer you can execute a SQL and see its impact on your database. You can perform load testing and fine performance tuning of your code right from your development environment.
    Latest release (Dec 2010) is compatible with the latest SQL Developer and LOTS of new info (Sessions, Lock, Memory, Storage, Undo, Statistics, etc.)
  • Pricing: Free
  • Author: Fourth Elephant
  • Installation: Download and use Check for Updates to install
Fourth Elephant  Insider
(Click for larger view)
DBmaestro TeamWork – Enforce Database Change Management for Oracle
  • Description: DBmaestro TeamWork – Enforce Database Change Management for Oracle facilitating:
    • Database Version Control – Schema structure, code and content
    • Manage database objects directly - Check Out/In, Undo, Labels, Baselines etc.
    • Deployment Automation – Perform impact analysis and 3-way comparisons with a merge and deployment engine

    DBmaestro TeamWork enables development collaboration while eliminating out-of-process updates and empowering development best practices
  • Pricing: 30 day free trial license
  • Author: DBmaestro Ltd.
  • Installation: Download and use Check for Updates to install
DBmaestro Teamwork
(Click for larger view)
Georaptor (on Sourceforge)
  • Description: GIS extension for Oracle SQL Developer: GeoRaptor project extends Oracle SQL Developer with additional functionality that is needed by database administrators of Oracle Spatial data, ESRI ArcSDE administrators or advanced GIS user.
  • Pricing: Free
  • Author: Open source
  • Installation: Download and use Check for Updates to install
Georaptor
(Click for larger view)
Hotsos Profiler Extension
  • Description: Hotsos Profiler Extension allows you to trace the SQL or PL/SQL commands you execute in Oracle SQL Developer and immediately view a profile of the resulting server generated trace file.
  • Pricing: Free(requires licensed copy of Hotsos Profiler
  • Author: Hotsos
  • Installation: Use Check for Updates to install
Hotsos
(Click for larger view)
Method R Trace (MR Trace)
  • Description: Method R Trace is a zero-click Oracle trace file collector. Every time you execute SQL or PL/SQL from your SQL Developer worksheet, MR Trace (we call it "Mister Trace") generates a trace file that corresponds carefully to the response time of your execution, and then it automatically copies that file to your SQL Developer workstation, where you can tag it for easy lookup later. The main panel lets you manipulate all the trace files you've collected. With just one click, you can open a trace file with any application you choose, including the Method R Profiler, a MR Tools utility, or even your favorite text editor.
  • Pricing: 14-day trial license
  • Author: Method R Corporation
  • Installation: Use Check for Updates to install
Method R Trace
(Click for larger view)
Oracle2Excel
  • Description: Oracle2Excel provides Business Analysts and SQL developers a simple means of exporting Oracle data to Microsoft Excel. It supports exporting data (using 1 select statement) to multiple Excel worksheets, and exports as much data (using many select statements) as you would like in one go. A standalone version is also provided and it supports command line for Scheduled Tasks (Windows) / Cron Jobs (*nix). Using an Excel template makes Oracle2Excel Cost Effective Reporting.
  • Pricing: 30-day trial license
  • Author:duke@database.asia
  • Installation: Use Check for Updates
Oracle 2 Excel
(Click for larger view)
Oracle Rdb Software
  • Description: Using the Oracle Rdb Extension for SQL Developer, you can connect to any target Oracle Rdb database using standard Oracle Rdb database authentication.
  • Pricing: Free
  • Author: Oracle
  • Installation: Available through Check for Updates or download from OTN and follow installation instructions on the web site
 
Red Gate Deployment Suite for Oracle
  • Description: The Deployment Suite for Oracle offers Oracle Developers and DBAs a powerful and intuitive GUI-based solution in which to compare differences between databases and schemas and deploy changes. Deployment scripts are automatically generated and can be exported for review, executed through your IDE or viewed and run within the software.
  • Pricing: 14-day free trial license
  • Author: Red Gate Software Ltd.
  • Installation: Use Check for Updates to install
Redgate
(Click for larger view)
SchemaSelect (on JavaForge)
  • Description: The SchemaSelect extension provides a convenient drop-down list which lets you choose the current schema in a sql worksheet. It also allows you to specify a default schema for newly opened worksheets.
  • Pricing: Free
  • Author: Bauke Gehem
  • Installation: Installation instructions on the web site
SchemaSelect
(Click for larger view)
SUMsoft Solutions SVCO
  • Description: Schema Version Control for Oracle (SVCO) is the integrated version control solution for Oracle Database server schema objects. It will track all schema objects changes direct within Oracle database fully automatically. No extra version control tool is required. This extension gives the possibility to use the complete SVCO functionality right inside the Oracle SQL Developer environment.
  • Pricing: 30-day trial license available
  • Author: SUMsoft Solutions
  • Installation: Follow the instructions on the web site. System Requirements: Oracle SQL Developer 1.5 (1.5.0.53.38) or later
SUMsoft Solutions SVCO
(Click for larger view)
SUMsoft Schema Visualizer
  • Description: Schema Visualizer allows you to create fully featured Entity Relationship Diagrams (ERD) based on any database which could be accessed with help of Oracle SQL Developer. Tables can be added to an existing diagram by dragging and dropping them from the SQL Developer DB Objects Navigator.
  • Pricing:30-day trial license available
  • Author: SUMsoft Solutions
  • Installation: Use Check for Updates
SUMsoft Schema Visualizer
(Click for larger view)
Fourth Elephant (Digger)
  • Description: An Oracle extended trace analyzer. The key features of Digger that set it apart from any other Oracle extended trace analysis application are its intuitive user interface, high performance and advanced extended trace analysis capabilities.
  • Pricing: For Cost
  • Author: Fourth Elephant
  • Installation: Download and use Check for Updates to install
Fourth Elephant  Digger
(Click for larger view)
Fourth Elephant (Error lookup for SQL Developer)
  • Description: Error lookup extension allows you to quickly look up oracle error codes (ORA-xxxx) without leaving your development environment.
  • Pricing: Free
  • Author: Fourth Elephant
  • Installation: Download and use Check for Updates to install
Fourth Elephant  Error Lookup
(Click for larger view)
GOYELLO Database Jobs
  • Description: Managing Database Jobs with SQL Developer
  • Pricing: Free
  • Author: GOYELLO
  • Installation: Installation instructions on the web site
Oracle Data Miner
  • Description: Oracle Data Miner is the graphical user interface for Oracle Data Mining (Release 10.1 and above) that helps data analysts mine their Oracle data to find valuable hidden information, patterns, and new insights. The Oracle Data Miner Code Generator generates PL/SQL code for mining activities. You can generate PL/SQL code from one or more activities using either a new wizard in Oracle Data Miner or an Extension to Oracle SQL Developer.
  • Pricing: Free
  • Author: Oracle
  • Installation: Download the PL/SQL Code Generator SQL Developer 1.5.5 zip file from OTN
Data Miner
(Click for larger view)
OrindaSoft
  • Description: OrindaBuild generates Java source code to run your PL/SQL procedures and functions or any SQL statement you give it.
  • Pricing: Trial Version available
  • Author: Orinda Software
  • Installation: Use Check for Updates
Orindasoft
(Click for larger view)

Create Your Own Extensions

We invite you to contribute to this exchange by sharing your own SQL Developer extensions. Please contact jeff.d.smith@oracle.com, if you'd like to upload your extension on this page. We now also include extensions in the SQL Developer Check For Updates facility. Let us know if you want your extension added there.

Oracle disclaims all express and implied warranties, including, the implied warranties of merchantability or fitness for a particular use. Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third party in connection with the use of these materials.

Updated: July 2013