Oracle

An Oracle client that belongs on a Mac.

Connect to Oracle Database by service name or SID. Oracle's Instant Client is downloaded on first use and checked file by file, so there is nothing to install by hand.

Download for macOS See every feature

Free for the databases on your Mac. Pricing

Oracle

What Oracle gets.

The kinds of object that exist on an engine are the kinds the app shows. This is Oracle's row of the features table, and what stands behind it.

EngineEditable gridDesignersUsers & RolesDiagram
Oracle✓✓tables, sequences, types, synonyms, triggers, tablespaces✓✓

The client, fetched and checked for you

The download comes from Oracle, under Oracle's own terms. It, the licence text inside it and then every extracted file are checked against SHA-256 digests built into the app; nothing is kept unless all of them match.

Guide: Oracle and IBM Db2 clients

Designers for what Oracle has

Tables, sequences, types, synonyms, triggers and tablespaces each have a designer that opens as a tab and previews its SQL.

Guide: kinds of object

Grants at system and table level

Open an account under Users & Roles, set what Oracle offers, and read the SQL preview before you save. Edit as SQL hands you the script in a query tab instead.

Guide: users and roles

SQL*Plus or SQLcl in a tab

A console tab is a real terminal running SQL*Plus or SQLcl with the connection's host, port, user and password, through its SSH tunnel or proxy if it has one. The password is never put on the command line.

Guide: console tabs
Connect

Connect to Oracle.

Click Add Connection under the sidebar and pick the Oracle tile. The first time, click Oracle Client Setup… and then Download. Paste a connection string — the field reads oracle:// addresses — or type the host, port, user and password, and choose Service Name or SID. Click Test Connection, then Add.

Default port
1521, by Service Name or SID
SSL
Disabled, or Verify Certificate with a Wallet Folder
Servers
Oracle Database 19c and newer, as Oracle documents for its 23 client.
Console
SQL*Plus — brew install InstantClientTap/instantclient/instantclient-arm64-sqlplus — or SQLcl — brew install --cask sqlcl and brew install openjdk
Notes
Needs Oracle's Instant Client, which the app downloads on first use. See Oracle and IBM Db2 clients.

Guide: Oracle in the docs Guide: your first connection

Every engine

One app for the rest of your databases, too.

Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.

PostgreSQL MySQL MariaDB SQLite SQL Server Oracle IBM Db2 MongoDB Redis DuckDBand CSV files ClickHouse Databricks

Try it on your own database.

Free for the databases on your Mac, and never asking you to sign in.

Download DBClient

$brew install --cask az-code-lab/taps/dbclient