Skip to main content

Copy data from MySQL to PostgreSQL

Project description

MySQL to PostgreSQL

PyPI Publish

Copy rows from MySQL to PostgreSQL quickly.


export PGHOST=localhost
export PGUSER=postgres
export MYSQL_DATABASE=example
export MYSQL_HOST=
export MYSQL_USER=root

docker run -d -e MYSQL_ALLOW_EMPTY_PASSWORD=true -e MYSQL_DATABASE -p 3306:3306 --name mysql --rm mysql
CREATE TABLE example (a int, b text);
INSERT INTO example (a, b) VALUES (1, 'a'), (2, 'b'), (3, 'c');

docker run -d -e POSTGRES_HOST_AUTH_METHOD=trust -p 5432:5432 --name postgres --rm postgres
psql <<EOF
CREATE TABLE example (a int, b text);


psql <<EOF
TABLE example;

docker stop mysql
docker stop postgres
INFO      Found 1 tables
INFO      Truncating 1 tables
INFO      Copying table example
INFO      Copied 3 rows to table example (0.00s)

 a | b
 1 | a
 2 | b
 3 | c
(3 rows)


pip3 install mysql2pg


Mysql2pg copies records from MySQL tables to existing PostgreSQL tables.

Mysql2pg also resets sequences, based on the maximum column value.

Performance is limited by network bandwidth, database resources, record size, and parallelism. In anecdotal usage, performance is 1m+ records/min serially.


usage: mysql2pg [-h] [--log-level {critical,error,warning,info,debug}] [--parallelism PARALLELISM]
                [--pg-search-path PG_SEARCH_PATH]
                [tables ...]

Copy records from MySQL to PostgreSQL

positional arguments:

  -h, --help            show this help message and exit
  --log-level {critical,error,warning,info,debug}
  --parallelism PARALLELISM
                        Number of tables to process in parallel (default: 10)
  --pg-search-path PG_SEARCH_PATH
                        PostgreSQL search path (default: None)


  • Parallelism
  • Foreign keys
  • PostgreSQL schema

Not supported

  • Creating PostgreSQL tables. If you need to convert schema, look at other tools like mysql2postgres.


  1. MySQL tables are discovered.

  2. PostgreSQL tables are truncated.

  3. PostgreSQL triggers (including foreign keys) are disabled.

  4. Records are streamed from MySQL and uploaded to PostgreSQL via the COPY command.

  5. Sequences are discovered and reset based on the maximum value in the column.

Tables are processed in parallel.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mysql2pg-1.4.1.tar.gz (4.1 kB view hashes)

Uploaded source

Built Distribution

mysql2pg-1.4.1-py3-none-any.whl (3.5 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page