Prisma Optimize Prisma Client extension

This is the package for the Prisma Client extension, which enables the use of Prisma Optimize.

Prisma Optimize enables developers to profile and get performance-related recommendations while developing applications with Prisma ORM.

It is part of the Prisma ecosystem, alongside other tools such as:

• Prisma Accelerate: Global database cache with scalable connection pooling.
• Prisma Pulse: Real-time database events with type-safe subscriptions.

Prisma is leading Data DX, a philosophy that promotes simplicity in data-driven application development. Learn more on the Data DX manifesto.

You can explore Optimize with the following resources:

• Get started
• Documentation
• Prisma Data Platform

1. Log in to your Prisma Data Platform account.
2. Access and launch the Optimize dashboard by following the instructions here.

If you're using Prisma version 5 or earlier, run the following command in your terminal to install compatible packages, else use version 6:

Version 5:

npm install @prisma/client@^5 @prisma/instrumentation@^5
@prisma/extension-optimize
npm install --save-dev prisma@^5

Version 6:

npm install @prisma/client@^6
@prisma/extension-optimize @prisma/instrumentation@^6
npm install --save-dev prisma@^6

Skip this step if you're using prisma client v.6

Prisma Optimize uses Prisma ORM's OpenTelemetry tracing functionality. In the generator block of your Prisma schema, add the tracing preview feature:

 generator client {
   provider        = "prisma-client-js"
+  previewFeatures = ["tracing"]
 }

Then, generate the Prisma Client:

npx prisma generate

Install the latest versions of Prisma Client and the Optimize extension:

npm install @prisma/client@latest @prisma/extension-optimize

Generate an Optimize API key by following the instructions here and add it to your .env file:

OPTIMIZE_API_KEY="YOUR_OPTIMIZE_API_KEY"

Extend your existing Prisma Client instance with the Optimize extension:

import { PrismaClient } from "@prisma/client";
import { withOptimize } from "@prisma/extension-optimize";

const prisma = new PrismaClient().$extends(withOptimize({ apiKey: process.env.OPTIMIZE_API_KEY }));

Follow these steps to start generating query insights with Prisma Optimize:

1. In the Optimize dashboard, click the Start recording button, then run your app.

2. After your app runs and insights are generated for the desired queries, click the Stop recording button.

3. Explore individual query details by clicking on them, and check the Recommendations tab for any suggested improvements to enhance query performance.

NOTE: Use the AI Explainer feature to understand recommendations and apply them within your Prisma model context.

For a hands-on learning experience, try out the step-by-step example.

If you need assistance, reach out in the #help-and-questions channel on our Discord, or connect with our community to see how others are using Optimize.