pgloader

Input—per 1M tokens

Output—per 1M tokens

Context—tokens

WeightsClosed

About

pgloader is ranked #5 of 23 in cloud migration tools on Inferse. It runs on Linux, Self-hosted. There is a free plan. Paid plans start at €100/mo.

Compared on cloud migration tools

Free plan: Yespgloader.io
Discovery & assessment: Yespgloader.io
Dependency mapping: Yespgloader.io
Continuous replication: Nopgloader.io
Database migration: Yespgloader.io
Deployment model: self-hostedpgloader.io

Facts

Purpose: pgloader migrates data into PostgreSQL from databases and flat files using schema translation, casting rules, and parallel loading.pgloader.io · 2 Oct 2026
Migration sources: The site lists MySQL, MariaDB, MS SQL Server, SQLite, CSV, fixed-width, and DBF sources; Oracle support is not built yet.pgloader.io · 2 Oct 2026
Pipeline: Its five stages are catalog fetch, target preparation, parallel COPY, parallel index creation, and schema completion.pgloader.io · 2 Oct 2026
MySQL features: The MySQL path includes enum-to-type translation, TINYINT(1)-to-boolean conversion, zero-date handling, and .my.cnf credential lookup.pgloader.io · 2 Oct 2026
SQL Server features: The MS SQL Server path includes Azure AD authentication, sequence migration, and multi-column foreign key support.pgloader.io · 2 Oct 2026
File imports: For file sources, failed COPY transactions are retried by separating rejected rows while allowing accepted rows to load.pgloader.io · 2 Oct 2026
Custom rules: Custom casting rules can be specified in a .load file.pgloader.io · 2 Oct 2026
Runtime: Version 4 is distributed as a self-contained JAR and requires Java 21 or later.pgloader.io · 2 Oct 2026
Version status: The site describes v4 as a pre-release and v3 in Common Lisp as the stable, packaged release.pgloader.io · 2 Oct 2026
Limits: The roadmap says pgloader works from catalog representations and does not currently parse SQL object definitions; view definitions and stored procedures would require SQL translation support.pgloader.io · 2 Oct 2026
Support: The free Community tier receives best-effort help through GitHub, while paid tiers offer priority handling and related support benefits.pgloader.io · 2 Oct 2026
Security: The site mentions Azure AD authentication for MS SQL Server but does not state security certifications or compliance attestations.pgloader.io · 2 Oct 2026
Maker: The maker identifies Dimitri Fontaine as pgloader’s author and maintainer since 2005.pgloader.io · 2 Oct 2026