# dimitri/pgloader

Migrate to PostgreSQL in a single command!

Repository: https://github.com/dimitri/pgloader
Canonical: https://ross.abutalabs.com/products/pgloader
Homepage: http://pgloader.io
Language: Common Lisp
License: NOASSERTION
License Family: other
Topics: postgresql, migration, mysql, mssql, sqlite, common-lisp, pgloader, sbcl, clozure-cl, database, csv, ixf, dbase
Last push: 2026-07-24T14:35:08+00:00

## Health v2 (maintenance only)
Score: 82/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 94, release rhythm 57, longevity 100
- inputs: {"age_days": 5995, "days_push": 40, "days_rel": 74, "gap_med": null, "n_releases_24m": 1}
- flags: prerelease_only, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 6504, forks 610 (observed 2026-08-28T04:09:43.914388+00:00)

## What it is
pgloader is a data loading and migration tool for PostgreSQL built on the COPY command. It migrates entire databases from MySQL, SQLite, MS SQL Server, DBF, and IXF sources, or loads CSV and fixed-format files, in a single command.

## Use cases
- migrate a mysql database to postgresql
- load large csv files into postgres
- convert sqlite database to postgresql
- migrate sql server schema and data to postgres
- bulk load data without failing on bad rows
- continuous migration from mysql to postgres

## When to choose
- you need one-command full database migration to PostgreSQL including schema creation
- your CSV loads must tolerate and isolate bad rows instead of aborting the whole transaction
- you need automatic data reformatting like MySQL zero dates to NULL

## When to avoid
- you only need simple one-off COPY loads with no error tolerance
- you are migrating between two PostgreSQL instances (use native dump/restore instead)
- you cannot run Java 21+ for the v4 JAR distribution

## Facets
- artifact type: cli-tool
- maturity: active
- function: etl, database, cli, csv
- domain: databases, developer-tools
- platform: cli, jvm, cross-platform, windows
- tags: postgresql, database-migration, mysql, sqlite, mssql, bulk-loading, copy-command, common-lisp, clojure, data-engineering, linux, macos

## Member repositories
- dimitri/pgloader (main) score 82

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:43.914388+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:44:28.966203+00:00, confidence not recorded.
  - readme: https://github.com/dimitri/pgloader (fetched 2026-08-28T04:09:43.914388+00:00, sha 259ddcd60515)
  - homepage: http://pgloader.io (fetched 2026-08-29T08:40:53.697226+00:00, sha 99106549895b)
  - site_page: https://pgloader.io/about (fetched 2026-08-29T08:40:53.706280+00:00, sha 78c5a716efee)
- Data as of 2026-08-30T08:39:29.467469+00:00.