Setting the file. One moment.
Subchapter 7.4
references/v7-mysql.mdMarkdown3 KBView on GitHub
Configure Prisma ORM 7 with MySQL and MariaDB. For an existing Prisma 6 app, keep its configuration and use the Prisma 6 docs; the configuration and adapter examples below are for 7.
In prisma/schema.prisma:
datasource db {
provider = "mysql"
}
generator client {
provider = "prisma-client"
output = "../generated"
}In prisma.config.ts:
import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
schema: 'prisma/schema.prisma',
datasource: {
url: env('DATABASE_URL'),
},
})In .env:
DATABASE_URL="mysql://user:password@localhost:3306/mydb"mysql://USER:PASSWORD@HOST:PORT/DATABASEUse a driver adapter for the standard SQL workflow.
Install adapter and driver:
npm install @prisma/adapter-mariadb@7 mariadbSet MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in the application environment to match the CLI URL, and use the same host and port. Instantiate Prisma Client with the adapter:
import 'dotenv/config'
import { PrismaClient } from '../generated/client'
import { PrismaMariaDb } from '@prisma/adapter-mariadb'
const adapter = new PrismaMariaDb({
host: 'localhost',
port: 3306,
connectionLimit: 5,
user: process.env.MYSQL_USER,
password: process.env.MYSQL_PASSWORD,
database: process.env.MYSQL_DATABASE,
})
const prisma = new PrismaClient({ adapter })If you need the MariaDB driver’s text protocol instead of the default binary execute() path, enable useTextProtocol explicitly:
import { PrismaClient } from '../generated/client'
import { PrismaMariaDb } from '@prisma/adapter-mariadb'
const adapter = new PrismaMariaDb(process.env.DATABASE_URL!, {
useTextProtocol: true,
})
const prisma = new PrismaClient({ adapter })Use this only when you specifically need text-protocol compatibility for your MariaDB setup.
Check whether foreign key constraints are enabled on the PlanetScale database. When they are disabled, use relationMode = "prisma" and add indexes for relation fields. Do not override an existing database that has foreign keys enabled.
In prisma/schema.prisma:
datasource db {
provider = "mysql"
relationMode = "prisma" // Emulate foreign keys in Prisma
}Set connectionLimit on PrismaMariaDb, as in the example above. The Prisma 6 connection_limit URL parameter does not configure the Prisma 7 adapter pool.
MySQL 5.7+ supports JSON. MariaDB 10.2+ supports JSON (as an alias for LONGTEXT with check constraints). Prisma handles this, but verify your version.