Vercel database Prisma setup

 

PrismaClientKnownRequestError:
16:53:10.179	Invalid `prisma.workspace.findMany()` invocation:
16:53:10.179
16:53:10.180
16:53:10.180	The table `public.workspaces` does not exist in the current database.
16:53:10.180	at pn.handleRequestError (/vercel/path0/node_modules/@prisma/client/runtime/library.js:176:6477)
16:53:10.180	at pn.handleAndLogRequestError

npx prisma migrate dev

% npx prisma migrate dev

Environment variables loaded from .env

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "verceldb", schema "public" at "ep-delicate-dust-021378.us-east-1.postgres.vercel-storage.com:5432"

Error: P3014

% npx prisma migrate resolve --applied 20220223015914_init_database

Environment variables loaded from .env

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "verceldb", schema "public" at "ep-delicate-dust-021378.us-east-1.postgres.vercel-storage.com:5432"

Migration 20220223015914_init_database marked as applied.

% npx prisma migrate resolve --applied 20220508151141_add_domain_verification_columns

Environment variables loaded from .env

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "verceldb", schema "public" at "ep-delicate-dust-021378.us-east-1.postgres.vercel-storage.com:5432"

Migration 20220508151141_add_domain_verification_columns marked as applied.

Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more about the shadow database (and workarounds) at https://pris.ly/d/migrate-shadow

Original error:

db error: ERROR: permission denied to create database

   0: schema_core::state::DevDiagnostic

             at schema-engine/core/src/state.rs:266

Put env vars to vercel except VERCEL_ prefixed env vars

The value is not a valid System Environment name