and here are the related models:

model User {
  id            Int              @id @default(autoincrement())
  createdAt     DateTime         @default(now())
  updatedAt     DateTime         @default(now()) @updatedAt
  ethWallets    EthereumWallet[]
  telegramUsers TelegramUser[]
}

model TelegramUser {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @default(now()) @updatedAt
  chatId    Int
  memberId  Int
  user      User     @relation(fields: [userId], references: [id])
  userId    Int

  @@unique([chatId, memberId])
}

model EthereumWallet {
  address   String   @id
  createdAt DateTime @default(now())
  updatedAt DateTime @default(now()) @updatedAt
  user      User     @relation(fields: [userId], references: [id])
  userId    Int
}

hey! was wondering about a good reference for defining edges, nodes, and cursors with prisma

Hello!

I would love to be able to set the theme for the prisma studio via URL. Is this possible?

hi everyone! is it possible to use multiline text fields in prisma studio? I'm able to set it with \n symbol, but then it disappears on the page

Is there a way to view my prod db with prisma studio? It's a postgres db on heroku

when adding items in prisma studio that have a field decorated with

@updatedAt

they are added with

1970-01-01T00:00:00.000Z

. is this expected behavior? I would expect the current dateTime to be used

I'd like to ping about the prisma studio UI again. We are providing convenient access to the studio within our application via an iFrame. However, we are unable to set the default theme since we only have access via the URL. Is there a way we can control the theme displayed via a query parameter such as

?theme=dark

, etc? I would love to submit a PR for this but Studio isn't OSS I believe.

Hey, I don’t seem to able to neither search or scroll in the initial schema list in Prisma studio. Is the team aware of this? It’s not blocking, because I can still open up the schema through the file browser, but it’s pretty annoying to have to do that every time.

I recently updated to the latest version of Studio and it will no longer start up. It just hangs on this screen. Wondering if anyone has encountered this before?

if I run it via

pnpx prisma studio

command, then it works 🤔

can you embed Prisma Studio inside a web app?

Just encountered an issue when trying to start Prisma Studio in Prisma version

2.30.0

on Windows 11. This is the output I get:

Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Prisma Studio is up on <http://localhost:5555>
Error: spawn undefined\System32\WindowsPowerShell\v1.0\powershell ENOENT
    at Process.ChildProcess._handle.onexit (node:internal/child_process:282:19)
    at onErrorNT (node:internal/child_process:480:16)
    at processTicksAndRejections (node:internal/process/task_queues:83:21)

Any clue why this might be happening? Both the

prisma

and the

@prisma/client

package are updated to version

2.30.0

so it's not a version mismatch.

I am not seeing the enum field I just added to my model in prisma studio. Is this intentional or a bug?

I suspect it is a bug since I cannot create a new record now without being able to set the enum

ah, restarting prisma studio fixed the issue!

Does anyone know if there is a way to create a "hosted" Prisma Data Studio? I would love to have a presentation/editing (spreadsheet like) over our SQL database. Is the roadmap for Studio to evolve into such a solution (almost like an Airtable competitor but for Prisma managed SQL databases?)

Hello there prisma land! Maybe I’ve discovered a bug… or I’m doing something wrong. Currently I’m playing around with schemas and relations. Therefore I created the following schema:

model User {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  email            String    @unique
  firstname        String
  lastname         String
  sentMessages     Message[] @relation("Sender")
  receivedMessages Message[] @relation("Recipient")
}

model Message {
  id          String   @id @default(cuid())
  sender      User     @relation(name: "Sender", fields: [senderId], references: [id])
  senderId    String
  recipient   User     @relation(name: "Recipient", fields: [recipientId], references: [id])
  recipientId String
  subject     String
  body        String
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}

In Prisma Studio it looks well but the relation recipient/recipientId isn’t established well. I’m able to relate a

User

to the

sender

field, but not

User

to the

recipient

field (see screenshot attached). Am I missing something?

Doing my first project with prisma and planetscale and I keep getting this error inn the prisma studio. Can someone help me with this, please?

Is it normal that I'm not able to see

string[]

variables within studio in the filter-selection box?

does prisma studio only with with prisma2? We are currently in the process of migrating from prisma1 and want to get an idea of what data manipulation will be available to us, so i tried to run it this morning to no avail. Up until now we have relied heavily on the playground for any needed data massaging / manipulation.

Trying to containerize our prisma studio for local development and from what I’ve found it seems that prisma studio only needs the

schema.prisma

file in order to work (and not generated types), but prisma studio needs to be restarted any time there’s a change to the

schema.prisma

file in order to see changes take effect. Is this the correct constraint? Or has anyone tried something similar?

Hello, we are planning to stop support for the Electron version of the Studio app in 4 weeks. This means that after March 1st we will stop releasing new versions of the Electron app that will be compatible with the latest Prisma ORM versions. You will still be able to use: • The CLI version of Studio (by running 

npx prisma studio

) • The Data Browser in the Prisma Data Platform for your online database instances The reasons for this move have to do with the low adoption of Electron Studio (as opposed to the CLI version) compared with the maintenance needs. Let us know if you hove any questions in this issue. Thank you.

Hi @Spiros - Product at Prisma forgive the forthrightness of this ... but ARE YOU CRAZY? discontinuing this tool is probably the most crazy thing possible! it may be a small percentage of users that use it, but for me it's essential, as is keeping up with latest versions. disadvantages of using CLI, it is in my experience more resource heavy, and not by a tiny amount. For the CLI you need an extra

Terminal

tab, and then an extra browser tab too. If you are absolutely dead set to discontinue the app, can you please make it open source so that the community can continue it.

the adoption rate for pgAdmin and phpMySQL is probably equally low compared to the number of people that use Postgres and MariaDB or MySQL but they havn't decided to remove their tools. Keeping Studio available and updated as an app, rather than a (stupidly resource expensive) PWA is so short sighted, and thinking with my "New User" hat on (and I still class myself as a new user) it presents a barrier to starting to use Prisma. Just my 2p / 2c worth, and I fully expect to be ignored, but It has to be said

Hey all, Where can I find the repo for Prisma Studio?

Hi! Is there a way to use CLI version of prisma studio with a remote database? Say that I want to connect to my AWS Database using

npx prisma studio

, it did not work when I set the

DATABASE_URL

accordingly. And if it doesnt work, how would you recommend setting up Prisma studio so it works with remote production DB? Thanks!

The GH issue in question - https://github.com/prisma/studio/issues/470

Hey Martin, Does this view persist even after you refresh the tab?

👋 Hello everyone! To streamline support for our Community, all questions about the Prisma ORM (Client, Studio, Migrate) will now be answered in #orm-help channel, and this channel will be archived next week is now archived. We hope that this will allow us to help you more quickly and share the knowledge among all our community members. 😊 If you have any pending questions / issues, feel free to resolve them in the current threads or move the conversation into #orm-help! 🧑‍💻 Happy coding!