TiloBox
Back to directory
pgloader project preview

pgloader

Migrate to PostgreSQL in a single command from MySQL, SQLite, MS SQL, and CSV files.

LicensePostgreSQL
GitHub stars6.5k
Last commit1 weeks ago
Tags5 topics
Mysql To PostgresPgloader CliSqlite To PostgresDevopsDatabase Migration Tool
Overview

Why consider pgloader?

pgloader is an open-source data loading and database migration tool written in Common Lisp by Dimitri Fontaine. pgloader converts database schemas and streams data from MySQL, SQLite, MS SQL Server, and large CSV files directly into PostgreSQL with automatic type casting and indexes.

Guided learning

Learn pgloader by building

Practical setup notes, real use cases, and copy-ready examples in one focused guide.

1 min read 2 sections
In this guide2 sections

Overview of pgloader

pgloader migrates relational database schemas and data tables to PostgreSQL with one terminal command.

Quickstart

bash
1pgloader mysql://root@localhost/source_db postgresql://user@localhost/dest_db

pgloader is licensed under the PostgreSQL License.

Related tools

More options with a similar category or technology profile.

pgloader FAQs

pgloader is listed as a Developer Tools tool on TiloBox. Review the overview, features, and official documentation on this page to decide whether it solves your specific workflow.

Start with the project's GitHub repository and official website for supported installation and deployment instructions. Test the setup with representative data or a small project before rolling it out more widely.

pgloader is listed under the PostgreSQL license. Read the complete license text and the project's notices before using, modifying, or distributing the software.

Production readiness depends on your requirements. Review maintenance activity, security practices, documentation, backup and upgrade procedures, and compatibility with your stack; then validate it in a non-production environment.

pgloader is listed as an alternative to Stitch. Compare the core workflow, deployment model, integrations, and licensing against your must-have requirements before switching.