Import from MySQL into Prisma Postgres for Prisma ORM

Import an existing MySQL database into Prisma Postgres, then use it with Prisma ORM.

Move an existing MySQL database into Prisma Postgres, then connect Prisma ORM to it.

Prerequisites

You need:

the connection URL for the MySQL database you are importing from
a Prisma Data Platform account
pgloader
Node.js 24 or newer

1. Create a Prisma Postgres database

Create a Prisma Postgres database from Console or with the CLI. Copy the direct connection string. You will use it for the import and for DATABASE_URL.

2. Create a pgloader config

Create config.load:

config.load

LOAD DATABASE
    FROM mysql://USER:PASSWORD@HOST:PORT/DATABASE
    INTO postgres://USER:PASSWORD@db.prisma.io:5432/?sslmode=require

WITH quote identifiers,
     include drop,
     create tables,
     create indexes,
     reset sequences

ALTER SCHEMA 'DATABASE' RENAME TO 'public';

3. Import into Prisma Postgres

Run pgloader:

pgloader config.load

4. Add Prisma ORM

From your app root, initialize Prisma ORM:

bunx prisma@latest orm init

Choose PostgreSQL, set DATABASE_URL to the Prisma Postgres connection string, then infer and emit the contract:

bunx prisma contract infer --output ./prisma/contract.prisma
bunx prisma contract emit
bunx prisma db sign

Next steps

Review table and column names in the inferred contract.
Use Add Prisma ORM to an existing PostgreSQL database for the first Prisma ORM query.
Use the full Prisma Postgres MySQL import guide for deeper migration details.

Import from MySQL