Prisma ORM v6.8.0: local Prisma Postgres with prisma dev

💻 Local development with Prisma Postgres via `prisma dev` (Early Access)

In 6.8.0, we released a way to develop against Prisma Postgres locally — no Docker required!

To get started, run the new prisma dev command:

npx prisma dev # starts a local Prisma Postgres server

This command spins up a local Prisma Postgres instance and prints the connection URL that you'll need to set as the url of your datasource block to point to a local Prisma Postgres instance. It looks similar to this:

datasource db {
  provider = "postgresql"  
  url      = "prisma+postgres://localhost:51213/?api_key=ey..."
}

You can then run migrations and execute queries against this local Prisma Postgres instance as with any remote one.

🦕 Native Deno support in `prisma-client` generator (Preview)

We’ve removed the deno Preview feature from the prisma-client-js generator. If you want to use Prisma ORM with Deno, you can now do so with the new prisma-client generator:

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

🤖 New AI workflows in VS Code

🕵️ Agent mode: AI support with your database workflows

In the latest release of the Prisma VS Code extension, we’re bringing new capabilities for agent mode in VS Code. If you're using VS Code and have the Prisma VS Code extension installed, your agent now is able to help you with your database workflows, such as:

Checking the status of your migrations (e.g. telling you if migrations haven't been applied)
Creating and running schema migrations for you
Authenticating you with the Prisma Console
Provisioning new Prisma Postgres instances so you can start coding right away

All you need to do is make sure you're using the latest version of Prisma's VS Code extension and your agent is ready to go 🚀

📚 Chat with Prisma’s docs in GitHub Copilot Chat

Our new Prisma for GitHub Copilot extension enables you to ask questions and get immediate answers right from Prisma’s documentation:

Fast lookups: Get the right answer immediately.
Stay in your flow: No more jumping between documentation and the editor.
Boost productivity: Spend more time coding, less time searching.

🧑‍🚀 More from the Prismasphere

🌏 New Singapore region for Prisma Postgres

We recently ran a poll where we asked you which region you'd like to see next for Prisma Postgres. The majority vote went to Asia Pacific (Singapore), so as of today, you're able to spin up new Prisma Postgres instances in the ap-southeast-1 region.

We're not stopping here, so keep an eye out on X for another poll asking for your favorite regions that we should add!

🔨 How we built the Prisma MCP server

In this technical deep dive, we give an overview of the anatomy of MCP servers and explain how we built the one for Prisma. The article covers the tradeoffs between local and remote MCP servers, the @modelcontextprotocol/sdk package, and how we enabled LLMs to use the Prisma CLI. Read the article on our blog.

💡 Operations-based billing: A simpler pricing model for modern databases

Serverless pricing for databases is notoriously difficult to grok and predict accurately. When thinking of how to solve this pricing dilemma for Prisma Postgres, we wanted to make things easy. Our operations-based model simplifies pricing and removes the need to think about resource sizes or abstract compute time metrics. Read the article on our blog.