Funded upstream maintenance

pgloader Maintenance and Priority Support

Migrating MySQL, SQLite or MS SQL Server to PostgreSQL, on a schedule you can commit to

pgloader connects to the source database, converts the schema to PostgreSQL conventions, and loads the data in parallel from a single command. It has been maintained since 2005 and is the tool named in nearly every MySQL-to-PostgreSQL migration guide written since. This page is about funding that maintenance — the tool itself is free, and stays that way.

6,471GitHub stars 2005maintained since 4live source databases

What pgloader Does in a Migration

Automated schema conversion and high-performance loading

pgloader connects directly to the source database, converts the schema to PostgreSQL conventions, and loads all data in a single command. It handles real-world edge cases — encoding issues, type mismatches, constraint ordering — so you don't have to.

Why it matters

Manual migrations are error-prone and slow

  • Schema differences between databases require careful translation
  • Data type mismatches cause silent corruption if not handled correctly
  • Large datasets need parallel loading to be practical
  • pgloader automates the tedious parts and reports exactly what it changed

Supported sources

Migrate from wherever your data lives

  • MySQL and MariaDB
  • SQLite
  • MS SQL Server
  • CSV, Fixed-width, and dBase files
  • PostgreSQL (for restructuring or copying)
  • Oracle is open for funding, not yet built — a threshold campaign, nothing charged below it

Key capabilities

Production-grade data loading

  • Automatic schema and type conversion
  • Parallel loading with concurrent workers
  • Error reporting with per-row rejection logs
  • Scriptable with a dedicated command language
  • Docker image available

What’s Being Worked On Right Now

Active maintenance areas

Current work focuses on compatibility with recent MySQL and PostgreSQL versions, edge cases in schema conversion, and packaging for current distributions.

The full backlog for this project — last release, what has merged since, and the big features queued behind it — is on the roadmap page, kept current rather than summarised here.

Install pgloader

Open source and available now

pgloader is open source and available as a binary, Debian/Ubuntu package, or Docker image. A single command is often all it takes to start a migration.

pgloader.io carries the full documentation, the source list, and the Continuous Migration method the tool was built for.

Fund pgloader Maintenance

Keep MySQL and MS SQL Server migrations working

If a migration on your roadmap depends on pgloader, funding its maintenance is what turns "someone will get to it" into a date. Sponsored work here has a track record: MS SQL Server support exists because Redpill Linpro paid for it, and it shipped free for everyone.

Work is prioritized through one queue across all four projects, triaged against your tier’s SLA, and shipped in quarterly releases — upstream, open source, for everyone.

Not looking to fund maintenance, but to run the migration yourself? Migrating to PostgreSQL is the course for that — 16 modules, six on the method and five per source engine, with pgloader doing the data step.

Get More Out of the PostgreSQL You Already Run

One learning path, four ways in — from The Art of PostgreSQL

Funded maintenance keeps the tools working. How much you get out of PostgreSQL itself is a different problem — query design, data modelling, and knowing which of its features you are not using. That is what the rest of The Art of PostgreSQL is for.

These aren’t four separate products. They’re one path: start with the book for the foundations, take the course to structure and deepen them, join a masterclass when you want to go further on a specific topic with the author in the room — and license it for the team when it should be everyone’s baseline, not one person’s.