DATA MASKING / WORK ON A COPY

Change the values.
Keep the source.

Prepare a dataset for a demonstration or test. Choose the rules, inspect the generated copy and export it as JSON.

Current development features · Public download coming soon

Masking rules and before-and-after preview over a substantial fictional customer datasetView full size ↗
Current development build · Harbour & Field Supply · Fictional demo records

A RULE FOR EACH COLUMN

Start with a suggestion.
Make the rules yours.

Open Data masking from Tools or Ctrl+K. Select tables, review suggestions for likely personal fields and save rules you want to reuse.

Substitute

Replace text with a pattern. Use {n} for a stable number per distinct source value.

Vary

Adjust numbers within a chosen amount or dates within a chosen number of days.

Shuffle

Rearrange existing values within the selected column.

Hash

Generate keyed hashes using a fresh secret for each generation. The secret is not exported.

Clear

Set eligible nullable fields to NULL when the values are unnecessary.

LOOK BEFORE YOU SHARE

Inspect the copy.
Then take it with you.

Generate a preview, review every included table and explicitly export the reviewed dataset.

Masking is a Pro feature and does not require AI. Hashing and shuffling alone do not guarantee anonymity. Supported databases are PostgreSQL, MySQL, SQL Server and SQLite; MySQL requires InnoDB for snapshot guarantees. Limits include 12 tables and 50,000 rows total, 12 MiB input and 16 MiB compact output. Previews show the first 25 generated rows.

Prepare a copy you can inspect.

Free for everyday SQL. 40 days of Pro included automatically for new Windows users. Optional Pro is £7.50/month.

Check download availability ↗
Download SQL OceanAlways free