Author expression and partial indexes in Prisma 8 and import any GitHub repository to Prisma Compute

You can now author expression, partial, and unique indexes directly in Prisma 8, in Prisma Schema Language or TypeScript. Prisma 8 also reads an existing database's indexes and row-level security policies into a contract. The legacy @db.* attributes are removed; see breaking changes below.

You can now import any GitHub repository to Prisma Compute from any workspace, including apps that live in a subdirectory of a monorepo.

Prisma ORM updateMany and createMany now work on driver adapters without transaction support. New guides cover agent safety, searchable encryption, Object Store buckets, and moving a local database to Prisma Postgres.

Highlights

NewAuthor expression, partial, and unique indexes in Prisma 8

You can now define expression, partial (where), and unique indexes in your Prisma 8 schema. Until now these indexes lived in raw SQL outside the schema, where migrations could not create, rename, or verify them.

Declare the index in Prisma Schema Language or TypeScript. Prisma 8 generates the exact DDL, applies it, and verifies it. Renaming an index plans a single ALTER INDEX statement; editing its expression plans the rebuild.

model User {
  id    Int    @id
  email String

  @@index(expression: "lower(email)", name: "users_email_lower", type: "btree")
}

The same index in TypeScript is constraints.index({ expression: "lower(email)", name: "users_email_lower", type: "btree" }).

Note: Prisma 8 (previously announced as Prisma Next) is in Early Access. Scope and behavior may still change. This release also removes the @db.* attributes, listed under breaking changes below.

Shipped in prisma/prisma-next#1048.

NewImport any GitHub repository to Prisma Compute

You can now import any GitHub repository to Prisma Compute (Public Beta) from any workspace. Until now the import flow was limited to selected workspaces.

Connect a repository in the Prisma Console. Prisma opens a setup pull request that adds the app configuration. Merge it, and your app deploys.

Apps in a subdirectory of a monorepo build correctly: the configuration names the directory to build.

{ "app": { "name": "orders-api", "root": "backend", "framework": "bun" } }

DocsFollow one getting-started path through the Prisma stack

The Prisma docs now recommend a single getting-started path: scaffold with Prisma 8, store data in Prisma Postgres, deploy on Prisma Compute. Each flow has a quick path, a guided path, and a copyable agent prompt. Prisma 7, the current GA release, stays one click away.

Start at the Prisma docs. Shipped in prisma/web#8106.

Prisma 8

Prisma 8 pairs the new index authoring with full-fidelity inference from existing databases.

Prisma Compute

Prisma Compute makes the repository import flow visible while setup is in progress.

Breaking changes

Breaking: Prisma 8 removes the @db.* native-type attributes. Write storage types in type position instead: String @db.Uuid becomes Uuid, and String @db.VarChar(191) becomes VarChar(191). Each removed attribute produces a diagnostic naming its replacement. (prisma/prisma-next#1054)

Fixes and improvements

Prisma Compute

Prisma Console

Prisma Postgres

Management API

Prisma ORM

Guides and articles

• Don't Let Your AI Agent Delete Your Production Database: how coding agents end up dropping production data, and the safeguards to put between an agent and your database.
• Search encrypted data with Prisma 8 and CipherStash: query encrypted columns through expression indexes with CipherStash's Prisma support.
• Give Your Agent File Storage: Object Store Buckets: the Object Store buckets launch post, walking the full lifecycle from POST /v1/buckets to serving objects with an S3 client.
• From Local Development to Production with Prisma Postgres: a five-step checklist for moving an app from local Postgres to hosted Prisma Postgres.
• Migrate a MongoDB project from Prisma ORM v6 to Prisma 8: schema conversion, client API changes, and a production cutover checklist.

Need help applying these changes in production? Prisma Enterprise Support can help with schema design, performance, security, and compliance.