Migrate a whole database
Every collection becomes a table in one run.
- Database and collection names map to schema and table names
- Start here when the MySQL schema does not exist yet
One-click data migration tool for MongoDB to PostgreSQL. GUI & CLI supported, cross-platform, 100% local & secure.
A MongoDB database has no schema, so the work is deciding what each collection becomes: one table, many tables, or one table fed by many collections. Eight operations, one dialog.
MySQL carries one advantage here: a JSON column. A nested document or an array can be written as JSON and still be queried with JSON_EXTRACT, so the shape survives the migration instead of being flattened into text.
Every collection becomes a table in one run.
One collection in, one MySQL table out.
nvarchar(max) columnFilter on the MongoDB side, then insert.
find() filter β or an aggregation β defines the rowsCollections that share a shape add up to one table.
Many collections, one pass.
Field by field, decided once.
ObjectId → text, Date → timestamptzjsonb; Decimal128 → numericRe-run the session instead of re-importing.
_id is the usual one)Run it on a timer.
.bat or .sh| MongoDB (BSON) | MySQL |
|---|---|
String | VARCHAR(255) / LONGTEXT |
ObjectId | CHAR(24) or VARCHAR(36) |
Int32 / Int64 | INT / BIGINT |
Double | DOUBLE |
Decimal128 | DECIMAL(38,10) |
Boolean | TINYINT(1) |
Date | DATETIME(3) |
Nested document | JSON (MySQL 5.7+) |
Array | JSON |
BinData | LONGBLOB |
ObjectId is 12 bytes of BSON; as CHAR(24) it keeps lexicographic order, as VARCHAR(36) it does not β pick per what the app joins on.LONGTEXT/LONGBLOB comfort (16 MB in practice for MySQL's max_allowed_packet), so check the largest document first._id uniqueness are not carried over as constraints: the rows arrive, the rules do not.Save your migration session in GUI first (config auto-generated).
Run via Command LineSupports MongoDB 4.2 ~ 8.0+.
Supports PostgreSQL 9.x, 10, 11, 12, 13, 14, 15, 16, 17, 18.
Free trial supports up to 1000 rows. All features are fully unlocked.
Check network, port, URI, account and whitelist settings.
Yes. Use CLI + scheduled tasks to achieve real-time sync.
Auto-adapt most types. ObjectId can be mapped to VARCHAR manually.
Fast, secure, easy-to-use, cross-platform. No technical skills required.
Free Download Now