BSON Schema Detection
Automatically detect field types across all collections — ObjectId, ISODate, NumberInt, nested objects, and arrays — and map them to SQL equivalents.
ObjectId → VARCHAR(24)MongoDB Oplog CDC
Tail the MongoDB oplog in real time. Every insert, update, and delete flows to the SQL target with sub-second latency. Zero data loss guaranteed.
< 50ms latencyType Coercion Engine
Flexible MongoDB types don't break your schema. ISODate → TIMESTAMPTZ, NumberInt → INTEGER, Double → DOUBLE PRECISION. Custom overrides available.
Auto type mappingZero Downtime Cutover
Oplog CDC keeps the SQL target current while MongoDB stays authoritative. Cut over when you're ready — NoSQLSync never writes to your source.
Live CDC syncIncremental Sync
Migrate historical data in bulk, then keep new writes in sync via CDC. No need to pause your application. Works with collections of any size.
Bulk + streamingSchema Validation
Before migrating, validate that every document conforms to the inferred schema. Catch type mismatches early. Drill down to individual offending documents.
Pre-flight checksThree steps to PlanetScale
Type mapping: MongoDB → PlanetScale
PlanetScale speaks the MySQL wire protocol. Connect it as a MySQL target using your PlanetScale connection string — every MySQL type mapping below applies unchanged.
Frequently asked questions
Embedded documents become JSONB columns by default, with full PostgreSQL indexing support. You can optionally flatten specific fields into their own columns using the visual schema mapper.
An ObjectId is stored as its 24-character hex string — VARCHAR(24) on PostgreSQL, MySQL, Snowflake, Redshift and MariaDB, NVARCHAR(24) on SQL Server, STRING on BigQuery and ClickHouse. The _id field becomes the table's primary key. Values are preserved exactly, so an ObjectId reference stored in another collection still matches after migration.
Yes. Choose which MongoDB collections to migrate. Each collection becomes a separate SQL table. Filter documents with queries to migrate only a subset.
A typical 100 GB dataset migrates in under 2 hours with bulk mode. With CDC enabled, ongoing writes sync in real time. Total time depends on data volume and network throughput.
Yes. All data is encrypted in transit (TLS 1.3) and at rest (AES-256). Database credentials use short-lived tokens. Migration workers run in an isolated environment and never store data after the job completes.
Yes. NoSQLSync only reads from your source — it is never modified, and CDC keeps running until you stop it. If you hit a problem after cutover, point your application's connection string back at the source.
Ready to migrate to PlanetScale?
Connect your MongoDB and PlanetScale instances. No credit card required.