pgloader
A data loading tool for PostgreSQL that can migrate a full MySQL database, including schema and data, in a single command.
pgloader loads data into PostgreSQL with the COPY command, keeping rejected rows in a separate file instead of aborting the load. For MySQL it can perform a full migration, including table definitions, and handles MySQL-specific details such as 0000-00-00 datestamps.
It’s released under the PostgreSQL license. The latest tagged release is from 2022, though the repository received commits in 2026.
Community feedback
This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.