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
• Create Your Own Extensions
• Download SQL Developer from OTN

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	(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	(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	(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	(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	(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	(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	(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	(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	(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	(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	(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
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	(Click for larger view)

Create Your Own Extensions

• Review the Oracle SQL Developer SDK, with examples and suggestions on the Oracle wiki
• SQL Developer uses the JDeveloper Extension SDK. An extension development kit with samples and documentation are available to help you build your own extensions.
• To add XML extensions, please refer to this article or this tutorial on OTN for guidance

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