pgloader

pgloader is an open-source tool, written and maintained by Dimitri Fontaine, that loads data into PostgreSQL from MySQL and MariaDB, SQLite, Microsoft SQL Server, DBF files and CSV or fixed-format files. Its site describes the project as independent of the PostgreSQL trademark holders, and it sells paid support and maintenance plans alongside the free software. Fontaine writes and maintains it, and the paid plans are the commercial option.

From one command it translates schemas, applies casting rules and loads in parallel. The documentation says it streams data with the PostgreSQL COPY protocol and sends rows it cannot load to reject.dat and reject.log files, so one bad row does not stop the run. The documented sources also include COPY text, IXF and Redshift, and the targets include Citus and Redshift as well as PostgreSQL.

Which version to run

The project site says version 3, written in Common Lisp, remains the stable packaged release. Its repository shows 3.6.9, tagged on 24 October 2022, as the latest non-prerelease, although the last push to the repository was on 14 September 2026. Version 4 is a full rewrite in Clojure, shipped as a single JAR that needs Java 21 or later and that keeps v3's .load syntax and flags; the site calls it pre-release. The site says Oracle support was never built and offers it as a funding campaign, and the documentation's source list has no Oracle entry.

The repository's LICENSE file holds the PostgreSQL license text, with a 2005 to 2017 copyright held by the PostgreSQL Global Development Group.

pgloader suits a team moving a MySQL, SQLite or SQL Server database into PostgreSQL that is comfortable running a command-line tool. Oracle sources are not covered. A buyer who wants a support commitment should look at the paid plans, which the site says cover priority fixes, roadmap input and reserved capacity.

Sources checked

  • The project site lists MySQL, MariaDB, SQLite, SQL Server, DBF and file sources, says v4 is a pre-release Clojure rewrite needing Java 21 while v3 stays stable, and describes paid support plans.

    pgloader.io · Checked

  • The documentation says pgloader streams data with the PostgreSQL COPY protocol, writes rejected rows to reject files, and supports a list of file and database sources.

    pgloader.readthedocs.io · Checked

  • The GitHub repository was created in April 2010, was last pushed on 14 September 2026, and lists v3.6.9 from October 2022 as the latest non-prerelease.

    github.com · Checked

  • The repository LICENSE file carries the PostgreSQL license text.

    raw.githubusercontent.com · Checked

Share:

Similar to pgloader