Prisma•2mo ago

Studio is not working with multifile schemas

I have created a folder schema and added the following code to the schema.prisma file

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

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["prismaSchemaFolder"]
}

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

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["prismaSchemaFolder"]
}

I can read from and write to the database, but when I run Prisma Studio, I get the following error: The table main.User does not exist in the current database.

Solution:

https://github.com/prisma/prisma/issues/25084#issuecomment-2554761318

GitHub

bug: sqlite is not working correctly with prismaSchemaFolder · Is...

I encountered an issue when using the prismaSchemaFolder preview feature with a SQLite database. The problem occurs when running prisma db push. The database file is generated in the prisma/schema/...

Jump to solution

12 Replies

Nurul•2mo ago

Hello @sid 👋 What is your prisma version? I just tried using Prisma studio with prismaSchemaFolder in a sqlite database and it worked as expected for me. This was my schema file

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["prismaSchemaFolder"]
}

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["prismaSchemaFolder"]
}

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

And this was my user.prisma file

model User {
    id    Int    @id @default(autoincrement())
    name  String
    email String
}

model User {
    id    Int    @id @default(autoincrement())
    name  String
    email String
}

Nurul•2mo ago

When I ran npx prisma studio The user model opened as expected

sidOP•2mo ago

Hi! I have 6.0.1 prisma and client.

Nurul•2mo ago

I tried it on 6.0.1 and it still works Did you run npx prisma db push or npx prisma migrate dev?

sidOP•2mo ago

I tried setting:

DATABASE_URL="file:./dev.db"

DATABASE_URL="file:./dev.db"

and it works fine. Thanks! However, when I use DATABASE_URL="file:../dev.db" I get the following error. Is this a bug or intended behavior?

Nurul•2mo ago

No, it should work as expected. The change you did just changes the location of db file. I tried changing the location of db in schema file like this:

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["prismaSchemaFolder"]
}

datasource db {
  provider = "sqlite"
  url      = "file:../dev.db"
}

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["prismaSchemaFolder"]
}

datasource db {
  provider = "sqlite"
  url      = "file:../dev.db"
}

And it worked as expected (see the new dev.db created outside prisma folder)

sidOP•2mo ago

I am still getting this error with the parent directory. Is there anything I can provide to help figure out the cause? Or do I need to clear some Prisma cache or something like that?

Nurul•2mo ago

Could you try running npx prisma db push before running npx prisma studio and check if you still get the same error?

Aleksei•5w ago

hey, I had same problem, use this workaround to be able to work with prisma studio https://github.com/prisma/prisma/issues/25084#issuecomment-2553182814

GitHub

bug: sqlite is not working correctly with prismaSchemaFolder · Is...

sidOP•5w ago

Thank you! That’s exactly the same bug.

Nurul•5w ago

Thank you for sharing the link to the Issue and workaround I believe this issue will be resolved when prismaSchemaFolder will go from preview to GA.

Solution

sid•5w ago