prisma studio error: FUNCTION pomagamy.json_arrayagg does not exist

[dilotec-2015]

getting this error when starting prisma studio (npx prisma studio):

Could not load schema metadata

Studio could not load schema and table metadata. Retry after checking database permissions or connectivity.

FUNCTION pomagamy.json_arrayagg does not exist

Source: mysql
with cols as (select c.COLUMN_DEFAULT as default, c.COLUMN_NAME as name, c.COLUMN_TYPE as datatype, ...

Database is running and accessible.
npx prisma db push is working

ENVIROMENT:

DB: MariaDB: 10.4.32
prisma: 7.8.0

prisma config:

export default defineConfig({
schema: "prisma/schema.prisma",
migrations: {
path: "prisma/migrations",
},
datasource: {
url: process.env["DATABASE_URL"],
},
});

prisma-schema:

generator client {
provider = "prisma-client"
output = "../src/generated/prisma"
}

datasource db {
provider = "mysql"
}

model User {
userId BigInt @id @default(autoincrement())
firstName String?
lastName String?
email String
street String?
city String?
country String?
displayName String?

profileImageUrl String? @db.Text

inviteCode String?
invitedBy String?
invitedAt DateTime?

isAdmin Boolean @default(false)
isB2B Boolean @default(false)
isSignedIn Boolean @default(false)

createdAt DateTime @default(now())
updatedAt DateTime @updatedat
lastSignedIn DateTime?

@@index([email])
@@index([userId])
@@Map("users")
}

[ejirocodes]

@dilotec-2015, you probably another postgres in a separate project running and prisma is talking to the wrong database server

[sorenbs]

Hi @dilotec-2015 — thanks for the report. This is the MariaDB introspection incompatibility (your MariaDB 10.4 predates json_arrayagg, which only exists in 10.5+). Fix is up in #1547: Studio now detects MariaDB and uses an aggregation that works on all supported versions — verified against a real MariaDB 10.4 server. It should ship in the next release once reviewed.