npx @better-auth/cli generate logs weird stuff on the console when run and fails

I just upgrade to

1.3.3

1.3.3

1.3.3

1.3.3 and for good measure I wanted to execute the cli comman

generate

generate

and noticed that is logging some code in the terminal (added a screenshot, because it's too much text) and throws a prisma error at me.

The error makes no sense to me. It says the URL must start with "file:", but the url actually does start with file: and the error logs are even showing the line where file: is set

Has anyone else encountered this issue?

PrismaClientInitializationError: error: Error validating datasource `db`: the URL must start with the protocol `file:`.
  -->  schema.prisma:14
   | 
13 |   provider = "sqlite"
14 |   url      = "file:./data.db"
   | 

Validation Error Count: 1
    at r (/Users/duki/IdeaProjects/simple-recipe-app/node_modules/@prisma-app/client/runtime/library.js:115:2770) {
  clientVersion: '6.12.0',
  errorCode: 'P1012',
  retryable: undefined
}

PrismaClientInitializationError: error: Error validating datasource `db`: the URL must start with the protocol `file:`.
  -->  schema.prisma:14
   | 
13 |   provider = "sqlite"
14 |   url      = "file:./data.db"
   | 

Validation Error Count: 1
    at r (/Users/duki/IdeaProjects/simple-recipe-app/node_modules/@prisma-app/client/runtime/library.js:115:2770) {
  clientVersion: '6.12.0',
  errorCode: 'P1012',
  retryable: undefined
}

PrismaClientInitializationError: error: Error validating datasource `db`: the URL must start with the protocol `file:`.
  -->  schema.prisma:14
   | 
13 |   provider = "sqlite"
14 |   url      = "file:./data.db"
   | 

Validation Error Count: 1
    at r (/Users/duki/IdeaProjects/simple-recipe-app/node_modules/@prisma-app/client/runtime/library.js:115:2770) {
  clientVersion: '6.12.0',
  errorCode: 'P1012',
  retryable: undefined
}

PrismaClientInitializationError: error: Error validating datasource `db`: the URL must start with the protocol `file:`.
  -->  schema.prisma:14
   | 
13 |   provider = "sqlite"
14 |   url      = "file:./data.db"
   | 

Validation Error Count: 1
    at r (/Users/duki/IdeaProjects/simple-recipe-app/node_modules/@prisma-app/client/runtime/library.js:115:2770) {
  clientVersion: '6.12.0',
  errorCode: 'P1012',
  retryable: undefined
}

Solution

AH! Found the issue! I had to add

dotenvx run -f .env --

dotenvx run -f .env --

dotenvx run -f .env --

dotenvx run -f .env -- in front of the generate command.

Jump to solution

Ping•7/24/25, 1:22 PM

@Duki try using file://

Ping•7/24/25, 1:23 PM

Also i dont know if using the file protocol supports relative paths, but I guess we will find out lol

PPing @Duki try using file://

DukiOP•7/24/25, 1:39 PM

I'm still getting the same error. When I run

prisma generate

prisma generate

myself it runs through without any error. It only happens when using BA's generate. It has worked before tho

DukiOP•7/24/25, 1:42 PM

Also doesnt work without a relative path "file://dev.db""file://dev.db"

Solution

Duki•7/24/25, 1:53 PM

AH! Found the issue! I had to add

dotenvx run -f .env --

dotenvx run -f .env --

in front of the generate command.

DukiOP•7/24/25, 1:55 PM

because initially I had this in my

schema.prisma

schema.prisma

file:

datasource db {
  provider = "sqlite"
  url      = env("DATABASE_URL")
}

datasource db {
  provider = "sqlite"
  url      = env("DATABASE_URL")
}

I changed it to a hardcoded value, because I thought it would be easier that way, but apparently BA doesn't use the same prisma client as the one generated via