Substitute
Replace text with a pattern. Use {n} for a stable number per distinct source value.
DATA MASKING / WORK ON A COPY
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
View full size ↗A RULE FOR EACH COLUMN
Open Data masking from Tools or Ctrl+K. Select tables, review suggestions for likely personal fields and save rules you want to reuse.
Replace text with a pattern. Use {n} for a stable number per distinct source value.
Adjust numbers within a chosen amount or dates within a chosen number of days.
Rearrange existing values within the selected column.
Generate keyed hashes using a fresh secret for each generation. The secret is not exported.
Set eligible nullable fields to NULL when the values are unnecessary.
LOOK BEFORE YOU SHARE
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.
Free for everyday SQL. 40 days of Pro included automatically for new Windows users. Optional Pro is £7.50/month.
Check download availability ↗