Prisma Studio with Accelerate URL Fails to Load in 7.0.1

[Tzadiko]

Bug description

I run Prisma Studio after migrating to Prisma 7 from Prisma 6. When the studio loads, it never reveals the contents of the database.

Instead I get the error below.

select "ns"."nspname" as "schema", "cls"."relname" as "name", (select coalesce(json_agg(agg), '[]') from (select "att"."attname" as "name", "typ"."typname" as "datatype", "tns"."nspname" as "datatype_schema", "fk_ns"."nspname" as "fk_schema", "fk_cls"."relname" as "fk_table", "fk_att"."attname" as "fk_column", "pk_con"."conkey" is not null as "pk", "att"."attgenerated" != $1 as "computed", "att"."attnotnull" != $2 as "nullable", coalesce((select json_agg("enm"."enumlabel") as "o" from "pg_catalog"."pg_enum" as "enm" where "enm"."enumtypid" = "typ"."oid"), '[]') as "options" from "pg_catalog"."pg_attribute" as "att" inner join "pg_catalog"."pg_type" as "typ" on "typ"."oid" = "att"."atttypid" inner join "pg_catalog"."pg_namespace" as "tns" on "tns"."oid" = "typ"."typnamespace" left join "pg_catalog"."pg_constraint" as "pk_con" on "pk_con"."contype" = $3 and "pk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("pk_con"."conkey") left join "pg_catalog"."pg_constraint" as "fk_con" on "fk_con"."contype" = $4 and "fk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("fk_con"."conkey") left join "pg_catalog"."pg_class" as "fk_cls" on "fk_cls"."oid" = "fk_con"."confrelid" left join "pg_catalog"."pg_namespace" as "fk_ns" on "fk_ns"."oid" = "fk_cls"."relnamespace" left join "pg_catalog"."pg_attribute" as "fk_att" on "fk_att"."attrelid" = "fk_cls"."oid" and "fk_att"."attnum" = any("fk_con"."confkey") where "att"."attrelid" = "cls"."oid" and "att"."attnum" >= $5 and "att"."attisdropped" != $6) as agg) as "columns" from "pg_catalog"."pg_class" as "cls" inner join "pg_catalog"."pg_namespace" as "ns" on "cls"."relnamespace" = "ns"."oid" where "ns"."nspname" !~ $7 and "ns"."nspname" != $8 and "cls"."relkind" in ($9, $10)

This is similar to what has been observed here. #1363

The solution provided there is strange to me, because my connection string is in the format of prisma+postgres://accelerate.prisma-data.net/?api_key and doesn't contain a --url parameter.

How to reproduce

Observe the files I have for Prisma 7 integration.

prisma.config.ts

import "dotenv/config";
import { defineConfig, env } from "prisma/config";

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

schema.prisma

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

datasource db {
  provider = "postgresql"
}

// My data models

1. Use a Prisma Accelerate Database URL, place it in .env.local
2. Run prisma studio in terminal

Expected behavior

I'd like to see my tables, and rows in those tables, allowing me to search, filter, and sort.

Instead I get this.

Prisma information

Loaded Prisma config from prisma.config.ts.

Prisma schema loaded from prisma\schema.prisma
prisma : 7.0.1
@prisma/client : 7.0.1
Operating System : win32
Architecture : x64
Node.js : v22.14.0
TypeScript : 5.8.3
Query Compiler : enabled
PSL : @prisma/prisma-schema-wasm 7.1.0-2.f09f2815f091dbba658cdcd2264306d88bb5bda6
Schema Engine : schema-engine-cli f09f2815f091dbba658cdcd2264306d88bb5bda6 (at ......\AppData\Roaming\npm\node_modules\prisma\node_modules@prisma\engines\schema-engine-windows.exe)
Default Engines Hash : f09f2815f091dbba658cdcd2264306d88bb5bda6
Studio : 0.8.2

Environment & setup

• OS: Windows 10
• Browser: Chrome
• Database: PostgreSQL

Prisma logs

See the original description.

[igalklebanov]

Hey 👋

This is already tracked in #1409.