pgloader
Migrate to PostgreSQL in a single command from MySQL, SQLite, MS SQL, and CSV files.
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.
Learn pgloader by building
Practical setup notes, real use cases, and copy-ready examples in one focused guide.
In this guide2 sections
Overview of pgloader
pgloader migrates relational database schemas and data tables to PostgreSQL with one terminal command.
Quickstart
pgloader mysql://root@localhost/source_db postgresql://user@localhost/dest_dbpgloader is licensed under the PostgreSQL License.
Related tools
More options with a similar category or technology profile.
diskus
Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.
peco
Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.
Dapr CLI
Command-line tool for managing Dapr distributed application runtime environments and sidecars.
Freeze
Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.