Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.

SQL Developer application interfaces

The World's

1 Tool for Managing your Oracle Database, Oracle SQL Developer provides users with three interfaces: Desktop, Browser, and Command Line.

Oracle SQL Developer

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database. Java powered application for Windows, OS X, and Linux with + 5 Million users.

• Full featured PL/SQL IDE
• Database administration
• Complete Data Modeling Solution
• 3rd party DBMS migrations to Oracle
• Migrate Oracle On-Premises to Oracle Cloud

Oracle Database Actions

Formerly known as SQL Developer Web, Database Actions brings all of your favorite Oracle Database desktop tool’s features and experience to your browser!

• Included in Oracle Autonomous Cloud Database
• Available with Oracle REST Data Services for your on-premises instances
• Run scripts, manage users, create/edit objects, import data, diagnose performance issues, visualize schemas, etc.

Oracle SQLcl

Oracle SQL Developer Command Line (SQLcl) is a free and modern command line interface for the Oracle Database.

• Very small (25mb), download, unzip, and go!
• Automatic formatting (csv, xml, json, INSERTs, HTML, and more)
• SQL History
• Tab completion
• Build your own commands
• Liquibase integration for schema versioning

Discover More

Oracle SQL Developer can be as simple as running queries against your Oracle Database, or it can be a complete development, management, and modeling solution. This demonstration takes you on a tour of the entire product.

In less than 10 minutes, see how to get up and running from your cmd prompt or bash shell with our modern command line interface for Oracle. New commands like LOAD and DDL save you tons of time, and the easy to read SQL results in the format you need make this a must-have utility. Also available for any of your OCI environments!

Introducing Database Actions

This playlist gives a quick introduction to the newest member of the SQL Developer family and then deep dives on the Data Modeler, creating and editing objects, and importing data from CSV or Excel.

Oracle Database 23c Free is the same, powerful Oracle Database that businesses throughout the world rely on. It offers a full-featured experience and is packaged for ease of use and simple download—for free.

Oracle Database Free benefits (1:27)

Whether you are a developer, a data scientist, a DBA, an educator, or just interested in databases, Oracle Database 23c Free is the ideal way to get started. It provides native support for all modern data types, analytics, and the latest development paradigms—all built into one product.

"The Micronaut team has already adopted Oracle Database 23c and is excited about the possibilities the new JSON Relational Duality views feature opens up. The ability to selectively treat data as JSON or relational while maintaining the power of SQL is fantastic. We are working on exciting innovations coming to Micronaut Data JDBC that simplify application development further with Oracle Database 23c."

See what top industry analysts are saying about Oracle Database 23c Free

See all analyst quotes

"Oracle Database 23c Free is designed to remove obstacles to developer access, allowings devs to define the ecosystem without requiring permission. This is a radical departure for Oracle."

"Oracle’s JSON Relational Duality, is perhaps one of the most important innovations in information science in 20 years."

"Under the “App Simple” motto, Oracle not only gives developers the opportunity to experiment and be more productive but helps boost the “shift left” initiatives."

"Oracle Database 23c simplifies the development process with the ability to unify relational data and JSON documents."

What’s included in Oracle Database 23c Free?

• More information about Oracle Database Free

The complete developer functionality of Oracle’s converged database, plus the following:

JSON Relational Duality

Build apps in either relational or JSON paradigms with a single source of truth and benefit from the strengths of both—relational and document models. Data is stored once but can be accessed, written, and modified with either approach.

JavaScript stored procedures

Create high performance, data-driven apps by writing JavaScript stored procedures (powered by GraalVM) and importing existing JavaScript libraries into the database. Minimize round trips to the database by executing business logic directly in the data tier.

JSON Schemas

Use industry-standard JSON Schemas to ensure only valid data is inserted into a JSON column.

Property Graphs

Find and analyze relationships, predict trends, and discover lightning-fast insights using database-native property graphs views. Use new SQL-standard property graph queries to run graph analytics on top of relational and JSON data.

SQL Domains

Bring domain knowledge closer to the data by describing the intended use of data centrally and ensuring data is handled consistently across applications.

Annotations

Annotate common data model attributes for tables, columns, views, indexes, and more, providing a central, lightweight, declarative facility to register and exchange usage properties across apps.

Resources

• Up to 12 GB of user data
• Up to 2 GB of database RAM
• Up to 2 CPU threads

Why use Oracle Database Free?

Looking for the right database for your next development project? Learn more about Oracle Database using the Oracle Database Free.

• Connect Oracle Database to your favorite programming languages and dev environments, including Java, Python, Node.js, Go, .NET, PHP, C/C++, and more.
• Learn SQL on the world's leading relational database and get to know Oracle's native support for JSON documents, Graph, and Spatial data.
• Reduce complex analysis to declarative SQL statements with Oracle’s industry-leading advanced analytics capabilities.
• Install free Oracle REST Data Services (ORDS) to REST-enable your database.
• Run Oracle APEX for low-code app development at no extra cost to rapidly build data-centric web apps that look beautiful in mobile and desktop browsers.

APRIL 3, 2023

Introducing Oracle Database 23c Free

Gerald Venzl, Senior Director of Product Manager, Oracle

Oracle Database 23c Free is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every day. It can be downloaded straight from the Internet with no oracle.com user account or license click-through requirements, enabling simple and fast access to the world’s only converged database that supports all data models and workload types.