Pgloader

Open source

pgloader is a command-line data loading and migration tool for PostgreSQL that imports from MySQL, SQLite, SQL Server, CSV and other sources.

pgloader.io
Pgloader homepage screenshot
GitHub stars
6.6k
Last 30 days
+14(+0%)
Last commit
2 mo ago
Repository age
16 years
Version
v3.6.9
Licence
Custom
Self-hosted
Yes

About Pgloader

pgloader loads data into PostgreSQL using the COPY protocol while handling bad rows gracefully. A plain COPY aborts the whole table load when a single line is invalid. pgloader instead writes rejected records to a separate file and keeps loading the good ones, which makes large imports from messy data far less painful.

Beyond loading, it reformats data on the way in, for example converting MySQL zero dates into proper NULL values. It can read flat files such as CSV, IXF and dBase files, and it can read directly from other databases including MySQL, SQL Server and SQLite, so migrating a whole schema along with its data can be done with a single command. The tool is written in Common Lisp.

pgloader is open source, though its license shows as 'Other' in the repository metadata. It runs on your own machine or server as a command-line program, and there is no hosted version. It suits database administrators and developers moving to PostgreSQL or regularly importing external data.

Key features

  • Bulk loading into PostgreSQL via COPY
  • Rejected rows saved to a separate file
  • Data reformatting during load
  • Direct migration from MySQL, SQL Server and SQLite
  • CSV, IXF and dBase file imports
  • Single-command database migrations

Good fit for

  • Migrating a MySQL database to PostgreSQL
  • Importing large CSV files with dirty rows
  • Moving SQLite data into Postgres
Tags
postgresql
migration
etl
mysql
sqlite
csv
cli

Pgloader: questions and answers

What is Pgloader used for?
pgloader is a command-line data loading and migration tool for PostgreSQL that imports from MySQL, SQLite, SQL Server, CSV and other sources. It is a good fit for migrating a MySQL database to PostgreSQL, importing large CSV files with dirty rows and moving SQLite data into Postgres.
Is Pgloader open source?
Yes. Pgloader is open source under a custom licence. Its source code is on GitHub at dimitri/pgloader and is written mainly in Common Lisp.
Is Pgloader free?
Yes. Pgloader is open source, so the software itself is free to use under the terms of its own licence.
What are some alternatives to Pgloader?
Similar open-source tools in the Database Tools category include Goose, Beekeeper Studio and Adminer. SaaS products in the same category include TablePlus, Valentina Studio and Base.
Is Pgloader actively maintained?
Yes. The most recent commit to Pgloader was on 14 September 2026, and the latest release is v3.6.9, published on 24 October 2022. The project has 6.6k stars on GitHub, with 14 added in the last 30 days.

Open-source alternatives to Pgloader

See all

SaaS alternatives to Pgloader

See all