MySQL Connector

1Connect

2Select Tables

3Process

4Download

<\!-- Step 1: Connect -->

Connect to MySQL

Enter your MySQL server details. Supports standalone MySQL 5.7+, MySQL 8.x, and Amazon RDS MySQL.

Hostname / IP address

For RDS: your endpoint URL without port

Database name

Port

Username

Minimum: SELECT privilege on target tables

Password

SSL mode

Setup checklist

Create a read-only user:
CREATE USER 'adam'@'%' IDENTIFIED BY 'password';

Grant SELECT access:
GRANT SELECT ON your_db.* TO 'adam'@'%';

Allow remote connections in my.cnf:
bind-address = 0.0.0.0

Open firewall port 3306 to Adam's IP range

<\!-- Step 2: Select Tables -->

Select tables to process

Connected to mysql.example.com / production_db — 6 tables found

Select the tables you want to anonymise and download.

customers41,280 rows · 12 colsInnoDB orders284,100 rows · 9 colsInnoDB order_items891,400 rows · 7 colsInnoDB products8,200 rows · 14 colsMyISAM staff320 rows · 11 colsInnoDB audit_log2,100,000 rows · 6 colsInnoDB

Schema preview — customers

customers · InnoDB · utf8mb4_unicode_ci

Column	Type	Nullable	Key
customer_id	INT	NO	PRI
email	VARCHAR(255)	NO	UNI
full_name	VARCHAR(120)	YES
date_of_birth	DATE	YES
postcode	VARCHAR(10)	YES
created_at	DATETIME	NO

<\!-- Step 3: Process -->

Processing tables

Pulling data from MySQL, running PII detection, and applying anonymisation.

[08:12:01] Connected to mysql.example.com:3306

[08:12:01] Starting processing run for 2 tables

<\!-- Step 4: Download -->

Download anonymised data

Processing complete. Your anonymised tables are ready for download.

customers_anon

41,280 rows · CSV · 3.2 MB

orders_anon

284,100 rows · CSV · 18.4 MB

Provenance Report

Full PII detection + anonymisation audit

Explore Data →