I’m trying to seed my database using Prisma’s official CLI, but I’m encountering an unexpected error when running npx prisma db seed. My project was set up using the official Prisma CLI, and I’m following their documentation, yet I’m getting a file extension error that seems bizarre.
Error message
<code>TypeError: Unknown file extension ".ts" for /path/to/prisma/seed.ts
at Object.getFileProtocolModuleFormat [as file:] (node:internal/modules/esm/get_format:218:9)
...
</code>
<code>TypeError: Unknown file extension ".ts" for /path/to/prisma/seed.ts
at Object.getFileProtocolModuleFormat [as file:] (node:internal/modules/esm/get_format:218:9)
...
</code>
TypeError: Unknown file extension ".ts" for /path/to/prisma/seed.ts
at Object.getFileProtocolModuleFormat [as file:] (node:internal/modules/esm/get_format:218:9)
...
My package.json Seed Configuration:
<code>"prisma": {
"seed": "ts-node prisma/seed.ts"
}
</code>
<code>"prisma": {
"seed": "ts-node prisma/seed.ts"
}
</code>
"prisma": {
"seed": "ts-node prisma/seed.ts"
}
However, It does work with when installing tsx and modifying it to:
<code>"prisma": {
"seed": "tsx prisma/seed.ts"
}
</code>
<code>"prisma": {
"seed": "tsx prisma/seed.ts"
}
</code>
"prisma": {
"seed": "tsx prisma/seed.ts"
}
I’m frustrated because I’m using Prisma’s official CLI and documentation. Why do I have to tweak the setup to make it work? Shouldn’t it work out of the box?