pgloader is an open-source data migration tool primarily used to load data into PostgreSQL from various sources with minimal manual effort.