pgloader ☆

« Back to VersTracker

Description:
Data loading tool for PostgreSQL

Type: Formula | Tracked Since: Dec 28, 2025

Links: Homepage | formulae.brew.sh

Category: Databases

Tags: postgresql migration etl database cli

Install: brew install pgloader

About:
Pgloader is a powerful data loading tool that automates the process of migrating data from various sources into PostgreSQL. It handles data extraction, transformation, and loading (ETL) with a single command, ensuring data integrity and optimal performance. The tool supports complex migrations, including schema creation, index rebuilding, and handling of foreign key constraints.

Key Features:

Supports migration from MySQL, SQLite, MS SQL, and CSV files
Automatic schema creation and data type conversion
Parallel loading for high performance
Resumable operations and detailed logging

Use Cases:

Migrating an existing MySQL database to PostgreSQL
Loading large CSV datasets into a structured PostgreSQL table
Automating periodic data imports from external sources

Alternatives:

pg_dump / pg_restore – Native PostgreSQL tools for backup/restore, but not designed for cross-database migration.
Apache NiFi – A more complex, enterprise-grade data flow automation tool, whereas Pgloader is a focused CLI utility.

Version History

Detected	Version	Rev	Change	Commit
Sep 21, 2025 11:16pm		1	VERSION_BUMP	1bd7181f