Seeding not working after migration to v7
ORM✅SolvedI have upgraded my project to use Prisma v7 and since then I cannot seed anymore. My seed.ts creates a client like this, as it still stands in the docs:
But the compiler complains that the PrismaClient needs a parameter:
new PrismaClient({
...
})
constructor() {
super({ ... });
}
Which does make sense, since after the migration, I create my real client like this:
import { PrismaClient } from "../src/generated/prisma/client"
const prisma = new PrismaClient()import { PrismaClient } from "../src/generated/prisma/client"
const prisma = new PrismaClient()But the compiler complains that the PrismaClient needs a parameter:
npx prisma db seed
Loaded Prisma config from prisma.config.ts.
Running seed command `tsx prisma/seed.ts` ...
/(...)/node_modules/@prisma/client/src/runtime/getPrismaClient.ts:259
throw new PrismaClientInitializationError(
^
PrismaClientInitializationError: `PrismaClient` needs to be constructed with a non-empty, valid `PrismaClientOptions`:npx prisma db seed
Loaded Prisma config from prisma.config.ts.
Running seed command `tsx prisma/seed.ts` ...
/(...)/node_modules/@prisma/client/src/runtime/getPrismaClient.ts:259
throw new PrismaClientInitializationError(
^
PrismaClientInitializationError: `PrismaClient` needs to be constructed with a non-empty, valid `PrismaClientOptions`:new PrismaClient({
...
})
ororconstructor() {
super({ ... });
}
at new t (/(...)/node_modules/@prisma/client/src/runtime/getPrismaClient.ts:259:15)
at <anonymous> (/(...)/prisma/seed.ts:2:16)
at ModuleJob.run (node:internal/modules/esm/module_job:365:25)
at async onImport.tracePromise.__proto__ (node:internal/modules/esm/loader:665:26)
at async asyncRunEntryPointWithESMLoader (node:internal/modules/run_main:99:5) {
clientVersion: '7.4.0',
errorCode: undefined,
retryable: undefined
}
Node.js v24.3.0
An error occurred while running the seed command:
Error: Command failed with exit code 1: tsx prisma/seed.ts at new t (/(...)/node_modules/@prisma/client/src/runtime/getPrismaClient.ts:259:15)
at <anonymous> (/(...)/prisma/seed.ts:2:16)
at ModuleJob.run (node:internal/modules/esm/module_job:365:25)
at async onImport.tracePromise.__proto__ (node:internal/modules/esm/loader:665:26)
at async asyncRunEntryPointWithESMLoader (node:internal/modules/run_main:99:5) {
clientVersion: '7.4.0',
errorCode: undefined,
retryable: undefined
}
Node.js v24.3.0
An error occurred while running the seed command:
Error: Command failed with exit code 1: tsx prisma/seed.tsWhich does make sense, since after the migration, I create my real client like this:
import { PrismaPg } from "@prisma/adapter-pg"
import config from "@/config" // that class handles reading my .env
import { PrismaClient } from "@/generated/prisma/client"
const adapter = new PrismaPg( // marked as error typed by eslint for some reason
{ connectionString: config.databaseUrl },
{ schema: "public" },
)
const prisma = new PrismaClient({ adapter })
const globalForPrisma = global as unknown as { prisma: typeof prisma }
if (process.env.NODE_ENV !== "production") globalForPrisma.prisma = prisma
export default prismaimport { PrismaPg } from "@prisma/adapter-pg"
import config from "@/config" // that class handles reading my .env
import { PrismaClient } from "@/generated/prisma/client"
const adapter = new PrismaPg( // marked as error typed by eslint for some reason
{ connectionString: config.databaseUrl },
{ schema: "public" },
)
const prisma = new PrismaClient({ adapter })
const globalForPrisma = global as unknown as { prisma: typeof prisma }
if (process.env.NODE_ENV !== "production") globalForPrisma.prisma = prisma
export default prisma