Oracle SQL Developer

SaaS

Oracle SQL Developer is a free Java-based IDE for developing and managing Oracle Database, on-premises or in the cloud, on Windows, OS X and Linux.

oracle.com
Oracle SQL Developer homepage screenshot

About Oracle SQL Developer

Oracle SQL Developer is a free integrated development environment for building and managing Oracle Database, in traditional and cloud deployments. It covers PL/SQL application development, a worksheet for running queries and scripts, a DBA console, a reports interface, data modeling, and a migration platform for moving third-party databases to Oracle.

The desktop tool is a Java application for Windows, OS X and Linux, and the homepage says no Oracle Client is required. The family also includes SQLcl, a small command line interface with automatic output formatting, SQL history, tab completion and Liquibase integration, and Database Actions, a browser version formerly called SQL Developer Web that is included in Oracle Autonomous Cloud Database.

Key features

  • Full PL/SQL IDE with administration and data modeling
  • Worksheet, DBA console and reports interface
  • Migrates third-party databases to Oracle
  • SQLcl formats output as CSV, XML, JSON and more
  • SQLcl integrates with Liquibase for schema versioning
  • Database Actions brings the desktop tool to a browser
  • Supports Oracle Database 11gR2 through 23ai

Good fit for

  • Running queries and scripts
  • PL/SQL development
  • Database administration
  • Data modeling
  • Migrating other databases to Oracle
Tags
oracle
sql
ide
pl/sql
database administration
data modeling

Oracle SQL Developer: questions and answers

What is Oracle SQL Developer used for?
Oracle SQL Developer is a free Java-based IDE for developing and managing Oracle Database, on-premises or in the cloud, on Windows, OS X and Linux. It is a good fit for running queries and scripts, PL/SQL development, and database administration.
Is Oracle SQL Developer free?
Yes. Oracle SQL Developer is free to use.
Is Oracle SQL Developer open source?
No. Oracle SQL Developer is proprietary (closed-source) software. Open-source alternatives to Oracle SQL Developer include Dbx, Chat2DB and Adminer.
What are some alternatives to Oracle SQL Developer?
Oracle SQL Developer competes with Toad, DataGrip and dbForge Studio. For open-source options, see Enlisted's ranked list of open-source Oracle SQL Developer alternatives.

Open-source alternatives to Oracle SQL Developer

See all

SaaS alternatives to Oracle SQL Developer

See all