Prisma 6.10.0 — Release Notes & Engineering Impact

Today, we are excited to share the `6.10.0` stable release 🎉  🌟 **Help us spread the word about Prisma by starring the repo ☝️ or [posting on X](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@prisma%20release%20v6.10.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/6.10.0) about the release.** ## Highlights ### No Rust engines for MS SQL Server & PlanetScale (Preview) We are in the process of removing the Rust engines from Prisma ORM. If you want to try this, you can configure your `generator` like this: ```prisma generator client { provider = "prisma-client-js" // or `prisma-client` output = "../generated/prisma" previewFeatures = ["queryCompiler", "driverAdapters"] } ``` In this release, we are excited to move the `queryCompiler` (which enables using Prisma ORM without Rust engines) into Preview for MS SQL Server and PlanetScale (via the new `@prisma/adapter-mssql` and existing `@prisma/adapter-planetscale` driver adapters). 📚Learn more in the [docs](https://www.prisma.io/docs/orm/prisma-client/setup-and-configuration/no-rust-engine). ### Manage local Prisma Postgres instances in VS Code We recently released a [database management UI](https://www.prisma.io/docs/postgres/integrations/vscode-extension#database-management-ui) as part of the Prisma VS Code extension to enable visual database management workflows for [Prisma Postgres](https://www.prisma.io/postgres). In this release, we added new functionality to it: You can now manage multiple _local_ Prisma Postgres instances via the same UI. To try it, find the Prisma logo in VS Code’s sidebar and start managing your local Prisma Postgres instances (no Docker required). 📚 Learn more in the [docs](https://www.prisma.io/docs/postgres/integrations/vscode-extension#database-management-ui). ### Performance improvements for `prisma migrate dev` We improved the `prisma migrate dev` command by optimizing the interactions with the shadow database. Our measurements show a 2x improvement in speed for some databases! ### "Push to Cloud": Easily deploy a local Prisma Postgres instance in VS Code Local Prisma Postgres instances are perfect for development, but how do you go _from local to remote_ once you’re ready to deploy? The database management UI in VS Code now has a **Push to Cloud** button that makes it easy to deploy your local Prisma Postgres so that you can connect to it from your deployed applications. 📚 Learn more in the [docs](https://www.prisma.io/docs/postgres/integrations/vscode-extension#database-management-ui). ### Support for shard keys on PlanetScale (Preview) [Sharding](https://planetscale.com/docs/vitess/sharding) is a popular technique to scale up when database load grows. As of this release, Prisma ORM supports sharding on PlanetScale natively via the new `@shardKey` and `@@shardKey` attributes in the Prisma schema which you can apply to the fields in your models that should serve as shard keys in your database setup: ```prisma // Single-column shard key model User { id String @default(uuid()) region String @shardKey } // Multi-column shard key model User { id String @default(uuid()) country String customerId String @@shardKey([country, customerId]) } ``` Note that this requires you to set the `shardKeys` Preview feature flag on your generator definition: ```prisma generator client { provider = "prisma-client-js" // or `prisma-client` output = "../generated/prisma" previewFeatures = ["shardKeys"] } ``` 📚 Learn more in the [docs](https://www.prisma.io/docs/orm/overview/databases/planetscale#how-to-define-shard-keys-in-your-prisma-schema-preview). ### Other changes - We deprecated the [`pg-worker`](https://www.npmjs.com/package/@prisma/pg-worker) package. It's not needed any more, you can simply use `pg` when using Prisma ORM in Cloudflare Workers. - Entrypoint for new `prisma-client` generator changed. Learn how this affects imports in the [docs](https://www.prisma.io/docs/orm/prisma-schema/overview/generators#4-use-prisma-client-in-your-application). ## More news ### Local Prisma Postgres now works with any ORM & tool (Early Access) We recently released [direct connections](https://www.prisma.io/docs/postgres/database/direct-connections) for _remote_ Prisma Postgres so that you can now use it with your favorite ORM or database tool. As of this release, this is also possible for your _local_ Prisma Postgres instances. To try it, run the `prisma dev` command and use the direct connection string starting with `postgres://` in order to connect from any tool. 📚 Learn more in the [docs](https://www.prisma.io/docs/postgres/database/local-development). ### Let your favorite AI tool manage Prisma Postgres via remote MCP We just released a new [_remote_ MCP server](https://www.prisma.io/docs/postgres/integrations/mcp-server#remote-mcp-server) that helps you manage Prisma Postgres instances! It enables your AI tools to help with these workflows: - Managing databases and connection strings - Creating and re-instantiating backups - Querying databases via plain SQL - Introspecting database schemas You can start it using the `npx -y mcp-remote https://mcp.prisma.io/mcp` command. 📚 Learn more in the [docs](https://www.prisma.io/docs/postgres/integrations/mcp-server#remote-mcp-server).