Hello Prisma team :wave: was wondering if anyone k...
# prisma-migrate
a
Hello Prisma team 👋 was wondering if anyone knows what’s causing this error. I’m trying to run
yarn rw prisma migrate dev
, (which is basically just a wrapper around
prisma migrate dev
) with a Supabase database and I’m getting this error:
Copy code
Error: Database error
Error querying the database: db error: ERROR: unexpected response from login query
   0: sql_migration_connector::flavour::postgres::sql_schema_from_migration_history
             at migration-engine/connectors/sql-migration-connector/src/flavour/postgres.rs:375
   1: migration_core::api::DevDiagnostic
             at migration-engine/core/src/api.rs:89
My Prisma schema:
Copy code
datasource DS {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider      = "prisma-client-js"
  binaryTargets = "native"
}

model User {
  id        Int      @id @default(autoincrement())
  githubId  Int
  handle    String   @unique
  email     String   @unique
  createdAt DateTime @default(now())
}

model Repository {
  id        Int      @id @default(autoincrement())
  githubId  Int
  fullName  String
  createdAt DateTime @default(now())
}
Redacted
.env
file:
Copy code
DATABASE_URL=<postgres://postgres:password@db.xxxx.supabase.co:6543/postgres>
SUPABASE_URL=<https://xxxx.supabase.co>
SUPABASE_KEY=xxx
SUPABASE_JWT_SECRET=xxx
DT to the rescue like usual, sounds like I need to set the params for the prisma connection string. https://github.com/redwoodjs/redwoodjs.com/pull/785
💯 1