Skip to content

Feature request: PSL support for Postgres scalar arrays (text[], uuid[]) #787

@olgen

Description

@olgen

Package and version

  • prisma-next: 0.12.0
  • @prisma-next/postgres: 0.12.0
  • Node: v22.x
  • Package manager: bun 1.3.x
  • OS: macOS (darwin)

Desired behaviour

Postgres scalar array columns should infer to a first-class PSL type (or documented extension), not:

tags            Unsupported("text[]")
applicationIds  Unsupported("uuid[]") @map("application_ids")

Where the gap surfaces

Brownfield contract infer on Supabase / Postgres schemas with array columns. We hit this while inferring a production-adjacent schema (~30 tables).

Current workaround

Manually replace Unsupported("text[]") / Unsupported("uuid[]") with Json, which loses type precision at the contract and TypeScript layers.

Example from infer output

model UserTasks {
  tags Unsupported("text[]")
  // ...
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions