Hello, I am running to an issue in my

schema.prisma

file. So I configured my app to using data proxy provided, and used the the provided

prisma://....

as DATABASE_URL connection string in my

schema.prisma

file. However, When I tried migrating the models

npx prisma migrate dev

- I got this error:

Error: Get config: Schema Parsing P1012
error: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`.
--> schema.prisma:8
|
7 | provider = "postgresql"
8 | url = env("DATABASE_URL")
|
Validation Error Count: 1

How do I fix this?

Hey Chris 👋, Currently, you can’t use the Data Proxy connection string for running database migrations. You will need to use your original database connection string when running

prisma migrate

commands. You can read more here.

Hello @Austin, thanks for your response. I very much appreciate it. So are you saying that I’d have to switch back and forth between using my Data Proxy connection and my database connection string every time I run

prisma migrate

? I plugged in my database connection string and started my app, but got this error:

error - InvalidDatasourceError: Datasource URL should use prisma:// protocol

Yes, we recommend setting up npm scripts to handle this switching for you:

// package.json
{
  ...,
  "scripts": {
    "generate-client": "PRISMA_CLIENT_ENGINE_TYPE='dataproxy' prisma generate",
    "migrate": "DATABASE_URL=\"$MIGRATE_DATABASE_URL\" prisma migrate deploy",
    ...
  }
}

thank you @Austin, your response is very much appreciated

Hey Chris, you need to swap the environment variables around, the

MIGRATE_DATABASE_URL

needs to be your actual Postgres connection string, and the

DATABASE_URL

will be the Data Proxy connection string.

Thanks @Austin 🙏