PostgreSQL to MySQL Converter

Move PostgreSQL data into MySQL or MariaDB. Schema conversion, type mapping, and optional two-way sync between on-prem and cloud-hosted MySQL.

Version: 5.1.2
Release Date: Oct. 19, 2026
Size: 20.1 MB
Platform: Windows 10 or later

Download DBConvert Order from US$ 199

Rather not run it yourself?

Let us do the migration →

Most PostgreSQL to MySQL migrations are driven by application stack alignment.

The data copy is straightforward; the work is in deciding how to represent PostgreSQL-only features once MySQL becomes the target. DBConvert connects to both servers, proposes a MySQL type for every column, and creates the tables before it moves a row.

How it runs

A Windows application that talks to both servers

Windows desktop

A native Windows application, installed on your own machine. Your credentials and your data never pass through a third-party service.

Live connections, not files

Both ends are database connections. There is no SQL text box to paste into and no pg_dump file to upload - the tool reads the source server directly and writes to the target server.

Saved and repeatable

A job stores both connections, the table selection, and the options. Run it again from the interface, or start it by name from a batch file or Task Scheduler with --run-job.

Two modes, one download

Convert once, or keep PostgreSQL and MySQL connected

You choose the mode when you set up the job.

One-time conversion

Schema, indexes, foreign keys and rows in one pass, with the type mapping you reviewed.

A large table is split into ranges and copied by several threads at once.
The run reports rows received per table - compare them against the source before you switch the application over to MySQL.

Repeat synchronization

Keep both databases in use after the first transfer.

Run the job on a schedule, in one direction or in both, until the PostgreSQL server is retired.
Only the rows that changed since the last run move.
Each synchronized table needs a primary key or a unique non-composite index, so the two sides can be matched.

What needs attention

How DBConvert handles the PostgreSQL → MySQL differences

Type mapping

PostgreSQL type	MySQL default
`SERIAL` / `BIGSERIAL`	`INT` / `BIGINT AUTO_INCREMENT`
`TEXT`	`LONGTEXT`
`NUMERIC(p,s)`	`DECIMAL(p,s)`
`BYTEA`	`LONGBLOB`
`BOOLEAN`	`BOOL` - MySQL's own alias for `TINYINT(1)`
`TIMESTAMPTZ`	`DATETIME` (with the application enforcing TZ semantics)
User-defined `enum` type	`LONGTEXT` - the labels are kept as text, the type itself is not recreated
Array (`text[]` and friends)	`LONGBLOB` - MySQL has no array type, so plan how the application should read it
`tsvector`	`LONGTEXT` - full-text search is rebuilt with a MySQL `FULLTEXT` index

Sequences and identity

Collapses PostgreSQL standalone sequences into MySQL AUTO_INCREMENT columns and sets the high-water value above the loaded maximum key value before the application resumes inserts - standard MySQL has no separate sequence object to manage.

Indexes and constraints

Recreates PostgreSQL partial-index semantics on MySQL where possible (filtered storage logic, generated columns), and reports GIN / GiST / exclusion constraints that have no direct MySQL analogue in the migration log so the business rule can be rebuilt with MySQL full-text / spatial indexes or application logic.

Application SQL portability

PostgreSQL-specific query syntax (RETURNING, ON CONFLICT, DISTINCT ON, ILIKE, array and jsonb operators, double-quoted identifiers) does not run unchanged on MySQL. DBConvert moves the schema and data; the application SQL layer is its own task - usually a search-and-replace pass plus a test cycle.

Procedural code stays behind

The migration covers tables - their fields, types, defaults, and indexes - and the foreign keys between them. PL/pgSQL functions, triggers, rules, custom operators, and extension-backed behavior (PostGIS, hstore, pgvector) stay in the source and are rewritten by hand in MySQL's stored-procedure dialect, or moved into application code. On most schemas this is a small share of the work, and it is rewrite work on any route.

You see every column before a row moves

The review lists each source column and the MySQL type it is about to get. Two columns are flagged for a look: the time-zone timestamp loses its offset, and fulltext is a reserved word in MySQL. Change any of them before the run.

DBConvert type-mapping review for a PostgreSQL to MySQL conversion, showing an enum, an array and a tsvector column with the MySQL type each will get

Why move

Why teams move PostgreSQL workloads to MySQL

Application stack alignment

CMSs (WordPress, Joomla, Magento, Drupal), SaaS integrations, and LAMP-style application stacks expect MySQL or MariaDB. The migration is usually about matching what the application or hosting provider was built for.

Hosting and managed-tier ubiquity

Every major cloud and most shared-hosting tiers offer MySQL, MariaDB, or a MySQL-compatible managed database. Standardizing on MySQL simplifies hosting and team onboarding when the organization has more MySQL operators than PostgreSQL ones.

Operational simplicity

Smaller engineering teams often prefer the MySQL operational model: simpler replication, smaller default install, well-known tooling, and a large pool of MySQL expertise to hire from.

Replica and reporting alignment

When the rest of the data platform - replicas, reporting copies, analytics extracts - runs on MySQL, moving the primary to MySQL removes a heterogeneous link in the pipeline.

If you need continuous replication instead

Scheduled synchronization is enough for a staged cut-over that runs for days or weeks. When PostgreSQL has to stay live and every change must land within seconds, that is log-based change data capture, and it is a different product: DBConvert Streams replicates PostgreSQL and MySQL continuously and runs anywhere.

Want to browse and query both databases while you migrate? Streams includes a database explorer for MySQL and PostgreSQL →

Supported versions and services

PostgreSQL

PostgreSQL 8.x through 17.x
Amazon RDS / Aurora for PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL, Supabase
PostgreSQL schemas (public, custom schemas)

MySQL

MySQL 5.x, 8.x; MariaDB; Percona Server
Amazon RDS / Aurora MySQL, Azure Database for MySQL, Google Cloud SQL

DBConvert Studio

30+ databases · cloud · scheduled sync

Need more directions or unattended sync? One tool covers them all.

How to migrate PostgreSQL to MySQL

Setup: the PostgreSQL source

Specify the username/password and host/port parameters if your source database requires login credentials.

PostgreSQL source

Read from self-hosted PostgreSQL, Amazon RDS / Aurora for PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL.

Setup: the MySQL destination

Specify parameters for the destination database similar to the source, defining connection settings and username/password pairs.

MySQL target

Use the MySQL connection guide for local MySQL or MariaDB, or Amazon RDS / Aurora for MySQL, Azure Database for MySQL, or Google Cloud SQL for MySQL. Create the target schema as utf8mb4.

Steps 2-4: the same for every database pair

Open the full guide

See all features

Move PostgreSQL data into MySQL

Download the current build and run the first job against your own database.

Download DBConvert 5.1.2 Order from US$ 199

Windows 10 or later · 20.1 MB