MySQL vs pgloader
MySQL
mysql.com
pgloader
pgloader.ioSide by side
| Figure | MySQL | pgloader |
|---|---|---|
| Price from | Free | €100/mo |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 18 | 6 |
| Spec score · Data Migration Tools | 8.9 (#1) | 7.8 (#8) |
| Support | MySQL Enterprise technical support provides 24x7 direct access to MySQL support engineers. | The free Community tier receives best-effort help through GitHub, while paid tiers offer priority handling and related support benefits. |
Plans
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
pgloader
- CommunityFree
- Supporter€100 a month
- Professional€800 a month
- Sponsor€2,000 a month
- Fast-Lane€3,000, paid once
- Per-Release Sponsor€10,000, paid once
In their own words
pgloader
pgloader migrates database and flat-file data into PostgreSQL using schema translation, casting rules, and parallel loading. Listed sources are MySQL, MariaDB, MS SQL Server, SQLite, CSV, fixed-width files, and DBF; Oracle support is not built yet. Its pipeline fetches the source catalog, prepares the PostgreSQL target, runs parallel COPY, creates indexes in parallel, and completes the schema. MySQL handling includes enum translation, converting TINYINT(1) to boolean, zero-date handling, and looking up credentials in .my.cnf. The MS SQL Server path includes Azure AD authentication, sequence migration, and multi-column foreign keys. For file imports, rejected rows can be separated after a failed COPY transaction while accepted rows continue loading. Custom casting rules go in a .load file. Version 3 in Common Lisp is the stable packaged release; version 4 is a pre-release JAR requiring Java 21 or later. The free Community tier has best-effort GitHub support. Paid support starts at €100/mo, with higher tiers offering priority handling, SLA-triaged patches, roadmap input, or issue-based support. It is self-hosted on Linux.