A local copy of your Oracle schema, real data included

dbplex is a Mac app that copies an Oracle schema, 12c or newer, to Oracle Database Free running in Docker on your Mac, with every table and row up to 12 GB. You get a local connection string for your app, your tests and your AI agent. Production is only read.

Download for Mac Try it in your browser

For Apple Silicon Macs. 7 days free with every feature. No card and no account.

Runs on: Oracle Database Free, in Docker
Download: A 13.1 GB image from Oracle
Needs: Docker Desktop and an Apple Silicon Mac
Production: Only read, never written to

What comes with a Oracle copy

Copied to your Mac

Tables and rowsEvery table and row of one schema, up to 12 GB, masked where you choose.
The schemaWith its keys, drawn as a graph.

Left behind, and why

More than 12 GBOracle Database Free holds 12 GB of data at most, so a larger schema cannot be copied.
External tablesTheir data lives outside the database.

After each pull the Connect tab lists what was left out.

What you paste

One connection string, with the schema to copy.

Connection StringRequired

oracle://user:password@host:1521/service?schema=APPOracle 12c or newer. Add ?schema=NAME to pick the schema.

Read only. Nothing is ever written to production.

A new copy takes a few minutes to start, as does each refresh. Starting it accepts Oracle's Free Use Terms.

Then point your app at the copy

oracle://app:••••@127.0.0.1:15000/FREEPDB1

The Connect tab gives a JDBC and an Easy Connect string too. The port is the first free one from 15000, so yours may differ. The Connect tab shows the exact values.

Why not an Oracle Free container of your own?

dbplex runs the same image. It also fills it and keeps track of it.

	Your own container	dbplex
Data	Export with Data Pump, copy, import, fix the grants.	One Pull.
Personal data	Every email and name lands on your laptop.	Masked on the way in, where you choose.
Going back	Import again.	Save a state and restore it.
Fresh data	Export and import again.	One Refresh button.

What you can do with a Oracle copy

Browse tables and run SQLOn real rows, in the app or with any Oracle client.
See the schema graphEvery table and the keys between them, drawn from the copy.
Mask personal columnsEmails, names and other personal columns are masked as the copy is pulled. You confirm each one.
Save and restore statesSave before a risky change and go back to it.
Branch the copyWork on a second copy, from now or from the last pull, and keep the first as it is.
Back up productionDaily or weekly, read-only, to a folder you choose. Each backup opens as a new copy.
Refresh from productionOne button replaces the copy with today's data.
Read the logsThe server log of the copy, in the Logs tab.

Comparing a copy with production is not available for Oracle yet, so there is no migration script; refresh to bring the copy up to date. A branch runs a second container that wants 2 GB of Docker's memory.

A Oracle sandbox for your AI agent

Give Claude Code, Cursor, Codex or Windsurf a copy of production to test on, and let it break things. dbplex's built-in MCP server hands the agent your local Oracle copy, never production: it never sees your production credentials, and every tool it gets acts on local copies only.

Add it from the app's Settings. Anything in the copy that reaches another server can still run. dbplex lists each one it finds after a pull.

Run SQL on real rowsReads, writes and schema changes, on the copy only.
Save a state before it tries somethingAnd restore it when the attempt goes wrong.
A branch for each agentEach agent clones the copy and works alone. A clone holds no credentials and can never reach production.
Personal columns maskedMasked as the copy is pulled, where you choose, before the agent reads a row.
Start over with today's dataIt can refresh the copy from production, and never sees the credentials.
Read the logsThe newest lines of the server log.

When agents had production instead

Questions about Oracle in dbplex

Can dbplex change my Oracle production database?

No. It only reads production to make your copy, and it has no push, sync or way to write anything back. The credentials stay in your Mac's Keychain.

Which Oracle versions can dbplex copy?

Oracle 12c or newer, one schema at a time, up to the 12 GB that Oracle Database Free holds.

Do I need Docker for Oracle?

Yes. The copy runs in Docker Desktop, which downloads a 13.1 GB image from Oracle the first time. A new copy takes a few minutes to start.

Which licence does the Oracle copy run under?

Oracle's Free Use Terms for Oracle Database Free. Starting the copy accepts them, and you are responsible for following them.

Can I start from a backup?

From a dbplex backup, yes. It opens as a new copy.

Can my AI agent use the Oracle copy?

Yes. Add dbplex's MCP server to Claude Code, Cursor, Codex or Windsurf from the app's Settings. It can run SQL, save and restore states and branch the copy, which runs a second container. Every tool acts on local copies only, and the agent never sees your production credentials.