dimitri/pgloader

Health v2 · maintenance only

Flags: prerelease_only no_license

Adoption not part of the score

6504 stars · 610 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pgloader is a data loading and migration tool for PostgreSQL built on the COPY command. It migrates entire databases from MySQL, SQLite, MS SQL Server, DBF, and IXF sources, or loads CSV and fixed-format files, in a single command.

Use cases

• migrate a mysql database to postgresql
• load large csv files into postgres
• convert sqlite database to postgresql
• migrate sql server schema and data to postgres
• bulk load data without failing on bad rows
• continuous migration from mysql to postgres

When to choose

• you need one-command full database migration to PostgreSQL including schema creation
• your CSV loads must tolerate and isolate bad rows instead of aborting the whole transaction
• you need automatic data reformatting like MySQL zero dates to NULL

When to avoid

• you only need simple one-off COPY loads with no error tolerance
• you are migrating between two PostgreSQL instances (use native dump/restore instead)
• you cannot run Java 21+ for the v4 JAR distribution

Facets

cli-tool · maturity active

etl database cli csv databases developer-tools cli jvm cross-platform windows postgresql database-migration mysql sqlite mssql bulk-loading copy-command common-lisp clojure data-engineering linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="dimitri/pgloader")