Migrate to PostgreSQL from any source
pgloader handles heterogeneous database migrations — from MySQL, SQLite, MS SQL Server, and more — with automatic schema conversion, type mapping, and high-performance parallel loading. Maintained and used in production since 2005.
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.
Manual migrations are error-prone and slow
Migrate from wherever your data lives
Production-grade data loading
Active maintenance areas
Current work focuses on compatibility with recent MySQL and PostgreSQL versions, edge cases in schema conversion, and packaging for current distributions.
Queue, SLA, quarterly releases
Work is prioritized through a queue. Supported users receive priority handling, with defined response times. Fixes and improvements are grouped and shipped in quarterly releases.
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.
Keep migrations reliable
If pgloader is part of your migration or data pipeline workflow, supporting its maintenance ensures faster fixes, continued compatibility with source and target databases, and long-term reliability.
Sharpen your skills, improve reliability, move faster
If you run PostgreSQL in production, the difference is not just tooling—it's how well you use it. Query design, data modeling, migrations, and performance tuning directly impact reliability and delivery speed.
The Art of PostgreSQL offers a complete, structured program to help you level up: from fundamentals to advanced production patterns, with practical, hands-on material you can apply immediately.