Oracle Client

The Oracle GUI Client for Mac.

A fast, native Oracle GUI client for Mac. Connect to Oracle 12c, 19c, 21c, 23ai, and Autonomous Database. Browse schemas, edit rows, run PL/SQL with autocomplete. Pure Swift driver, no JDBC, no instant client. Free and open source.

Download for Mac Read the docs

TablePro connected to a Oracle database showing the data grid and SQL editor

Features

Built for Oracle.

Wallet and TNS Support

Drop in your wallet zip or tnsnames.ora. TablePro reads alias names and DSN strings.

Inline Cell Editing

Edit any cell. Type widgets for NUMBER, TIMESTAMP WITH TIME ZONE, INTERVAL, CLOB, BLOB.

PL/SQL Editor

Run anonymous blocks, packages, and functions. Compile errors point to the exact line.

Autonomous Database Native

Connect to ADW, ATP, and ADW Free with the wallet. mTLS handled automatically.

Streaming Result Sets

Million-row queries open in a streaming grid. Cancel runs cleanly.

AI SQL Assistant

Ask in English, get PL/SQL or Oracle SQL. Explain query plans, optimize hints.

Data Grid

Browse and edit data.

Sort, filter, and edit Oracle data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.

TablePro data grid showing Oracle table rows with inline editing

SQL Editor

Write queries faster.

Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.

TablePro SQL editor with Oracle query and autocomplete

Capabilities

What you can do.

Browse schemas, tables, views, packages, and procedures
Run PL/SQL blocks and packages
Connect via wallet, TNS, or direct host
Edit table structure and storage parameters
View execution plans with hints
Stream-export huge datasets
Full-text search across query history
Safe mode for production databases

Connect

Get connected in seconds.

# Connect with TablePro
Host: 127.0.0.1
Port: 1521
Service Name: XEPDB1
User: system

# Oracle Cloud
Host: adb.region.oraclecloud.com
Wallet: /path/to/wallet.zip

Supported versions

Oracle 12c+, Oracle 19c, Oracle 21c, Oracle 23c, Oracle Cloud (Autonomous)

Connection types

TCP/IP
SSH Tunnel
TLS/SSL
Oracle Wallet (for Cloud)

Default port

1521

How to

Connect to Oracle in four steps.

1
Install TablePro and the Oracle plugin
brew install --cask tablepro. Open Settings > Plugins, install the Oracle driver from the registry.
2
Open New Connection
Click New Connection. Pick Oracle.
3
Pick auth method
Wallet zip, TNS alias, or direct host. Fill credentials.
4
Connect
Click Connect. Schemas appear in the sidebar.

FAQ

Common Oracle questions.

Do I need Oracle Instant Client?

No. TablePro uses a pure Swift Oracle driver. Nothing to install on the Mac.

Does it work with Autonomous Database?

Yes. Drop in the wallet zip. TablePro handles mTLS automatically.

Can I run PL/SQL packages?

Yes. Compile, run, and step through. Errors point to the exact line.

Is TablePro free for Oracle?

Yes. AGPLv3 open source. The Oracle driver is a separate plugin from the registry.

Does it support Kerberos auth?

Kerberos via OS native ticket cache works. SSO and AAD federated auth on the roadmap.

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.

Download for Mac Setup guide