Database Sync & Anonymization
Connect your production database and automatically generate privacy-safe synthetic copies for staging, development, and testing environments.
How It Works
┌─────────────────────────────────────────────────────────────────┐
│ SYNC & ANONYMIZATION │
├─────────────────────────────────────────────────────────────────┤
│ │
│ Production Database Destination │
│ ┌─────────────────┐ ┌─────────────────┐ │
│ │ │ Phony │ │ │
│ │ users: │ Cloud │ users: │ │
│ │ • Real names │ ──────────▶ │ • Fake names │ │
│ │ • Real emails │ Anonymize │ • Fake emails │ │
│ │ • Real phones │ & Sync │ • Fake phones │ │
│ │ │ │ │ │
│ │ 100GB / PII │ │ 100GB / No PII│ │
│ └─────────────────┘ └─────────────────┘ │
│ │
└─────────────────────────────────────────────────────────────────┘Key Features:
- Full sync / Incremental sync
- Smart subset (1% with FK integrity)
- Scheduled jobs (nightly refresh)
- Auto PII detection
- Referential integrity preserved
Supported Databases
| Phase | Databases | Trigger |
|---|---|---|
| Phase 1 (Launch) | MySQL, MariaDB, PostgreSQL, SQLite | Laravel ecosystem |
| Phase 2 (Enterprise) | SQL Server, Oracle, AWS RDS/Aurora | Customer demand |
| Phase 3 (Modern Stack) | MongoDB, Snowflake, BigQuery, S3/GCS, Kafka | Market trend |
Transformation Types
| Type | Description | Example |
|---|---|---|
| ANONYMIZE | Replace with Phony-generated data | john@email.com → mehmet@example.com |
| MASK | Partial hide | john@email.com → j***@e***.com |
| HASH | One-way hash (preserves FK consistency) | john@email.com → a7f3b2c1... |
| NULL | Set to null | john@email.com → null |
| KEEP | Leave unchanged (for non-PII) | status → status |
| CUSTOM | User-defined function | Custom logic |
Masking Strategies
Email Masking
- Standard:
john.doe@company.com→j***.d**@c******.com - Domain-keep:
john.doe@company.com→j***@company.com - Hash-local:
john.doe@company.com→a7f3b@company.com
Phone Masking (Locale-aware)
- TR:
+90 532 123 4567→+90 532 *** **67 - US:
(555) 123-4567→(555) ***-**67 - EU:
+49 30 12345678→+49 30 *****678
Credit Card Masking
- Standard:
4111 1111 1111 1111→**** **** **** 1111 - BIN-keep:
4111 1111 1111 1111→4111 **** **** ****
Name & Address
- Initial:
John Doe→J*** D** - Geo-preserve: Keep city/country, mask street
Custom Patterns
- SSN (US):
123-45-6789→***-**-6789 - TC Kimlik:
12345678901→*******8901 - IBAN:
TR12 0001 ...→TR12 **** ...
Tier Limits
| Feature | FREE | STARTER | TEAM | BUSINESS |
|---|---|---|---|---|
| Sync Jobs | 1 | 5 | 15 | Unlimited |
| Incremental Sync | ✗ | ✓ | ✓ | ✓ |
| Parallel Sync | ✗ | ✗ | 3 | 10 |
| Subset Sync | ✗ | ✓ | ✓ | ✓ |