How can I view prisma relation data in dbeaver?

Question

I would like to view the rich relation data which is available in prisma studio in dbeaver.

For example, in prisma studio if a Post entity has a userId field and user relation defined:

model Post {
  id                      String                    @id @default(cuid())
  user                    User                      @relation(fields: [userId], references: [id])
  userId                  String                    @relation("user")
}

the corresponding User for that userId will appear as the user column when viewing the Post table in prisma studio.

My understanding is that in dbeaver, related tables should be connected in the "References" section (which is empty for every table).

I wonder if, since I'm using relationMode = "prisma", and not relationMode = "foreignKeys" in my prisma datasource, dbeaver does not recognize the relations between tables. (Checking the "DDL" of each table shows that the REFERENCES SQL keyword is not invoked, and there aren't FOREIGN KEY's)

Is there a way to include this data in the table view of dbeaver without changing the relationMode?

How can I view prisma relation data in dbeaver?

0 Answers0