Oracle SQL Developer

What Oracle SQL Developer is

Oracle SQL Developer is a free desktop database application for Linux, macOS, and Windows. It supports Oracle Database, MySQL, Microsoft SQL Server, Microsoft Access, and selected third-party databases. Users can edit data, build queries visually, and review query history within the application. SSH tunneling is supported for database connections. Query results can be exported as XML, CSV, SQL Insert, or SQL*Loader formats, giving users several ways to move output into other workflows. The software is deployed on the desktop rather than as a web service. Oracle, its maker, was founded in 1977 and is headquartered in Austin, Texas, USA. A free plan is listed, and no paid tier or trial is specified. The combination of broad database support, visual query building, editing, history, tunneling, and export makes it a practical option for desktop database work where the supported systems match your environment.

Who it suits

It suits database users on Linux, macOS, or Windows who need editing, visual query building, query history, SSH tunneling, or result export. It is particularly relevant when working with one of the listed database systems.

Limits

The free plan is available, but the application is desktop-deployed and its database support is limited to the listed systems.

Getting started

1. Open the Oracle SQL Developer website
2. Download the desktop application for Linux, macOS, or Windows
3. Install it on the supported desktop platform
4. Use the free plan
5. Connect to a supported database system
6. Use SSH tunneling when required

Verdict

Oracle SQL Developer offers a free desktop toolkit with multiple database connections and practical query, editing, history, tunneling, and export features. Check that your specific database is among the supported systems.