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
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
Dbx
Database Tools
25 MB lightweight cross-platform database client for 100+ databases, including MySQL, Post
Apache-2.0vs DataGrip★ 30k
Chat2DB
Database Tools
Chat2DB is a free, cross-platform, local-first database client and SQL workspace for devel
OSSvs DataGrip★ 28kAdminer
Database Tools
Database management in a single PHP file
OSSvs DataGrip★ 8k
CloudBeaver
Database Tools
Cloud Database Manager
Apache-2.0vs DataGrip★ 5.2k
DBeaver
Database Tools
Free universal database tool and SQL client
Apache-2.0vs DataGrip★ 52k
Beekeeper Studio
Database Tools
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux
OSSvs DataGrip★ 24k
SaaS alternatives to Oracle SQL Developer
See all
Toad
Database Tools
Quest tools for database development and administration across Oracle and SQL Server
SaaS
DataGrip
Database Tools
JetBrains IDE for SQL with code completion and multi-database support
SaaS
dbForge Studio
Database Tools
Devart IDE suite for developing and managing MySQL, SQL Server, Oracle and PostgreSQL
SaaS
Navicat
Database Tools
Database administration and development client for many SQL and NoSQL systems
SaaS
DbVisualizer
Database Tools
Universal database client with a free edition and a paid Pro tier
SaaS
SQL Server Management Studio
Database Tools
Free Microsoft tool for managing SQL Server and Azure SQL databases
SaaS

Oracle GoldenGate
TablePlus