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.

• 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. Extensions are version specific, this page lists extensions for SQL Developer 2.1.x and SQL Developer 1.5.5. Use the SQL Developer Forum on OTN to report extension related issues.

Available Extensions for Oracle SQL Developer 2.1.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)
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)
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	(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)

Available Extensions for Oracle SQL Developer 1.5.5

Name	Description	Logo/Image
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
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	(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	(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: January 2011