pgloader - Database Migration Tool

Database Migration Made Simple

pgloader loads data from various sources into PostgreSQL with automatic schema conversion and high-performance parallel loading.

GitHub Documentation

Overview

pgloader is a tool for loading data into PostgreSQL. It supports multiple source databases including MySQL, SQLite, MS SQL Server, and Oracle. pgloader can either COPY from files or connect to a database directly.

Key Features

Multi-source support: Migrate from MySQL, SQLite, MSSQL, Oracle, and more
Automatic schema conversion: pgloader automatically converts source schema to PostgreSQL
Type conversion: Automatic mapping of source data types to PostgreSQL types
Parallel loading: High-performance loading with concurrent workers
Data validation: Built-in data validation and error reporting

Supported Sources

MySQL / MariaDB
SQLite
MS SQL Server
Oracle Database
CSV files
FIXED format files

Installation

# From source
git clone https://github.com/dimitri/pgloader.git
cd pgloader
make

pgloader is also available as a Docker image:

docker pull dimitri/pgloader

Quick Example

pgloader mysql://user:password@host/dbname postgresql://user:password@localhost/dbname

Support Options

Get professional support and maintenance for pgloader in your production environment.

Subscribe to Maintenance