If you’re hosting your NextJs project on Vercel and want to utilize Prisma, here is the simple setup for production. It’s in the docs (kinda), but I figured I would pull it out and make it easy to identify.
Create Your Prisma File
The following file is lib/prisma.js
import { PrismaClient } from '@prisma/client';
if (process.env.CURRENT_ENV == 'production') {
constprisma = newPrismaClient();
} else {
if (!global.prisma) {
global.prisma = newPrismaClient();
}
prisma = global.prisma;
}
export default prisma;
Anywhere you are using PrismaClient, import the following. This will alleviate the numerous connections on dev and allow you to go to production.
import prisma from '../../../lib/prisma';
Set Your Production Environment Variables
Be sure you have your .env file set up. If you have a pretty vanilla setup you will only need the following:
DATABASE_URL='url here'
Update Vercel Your Build Step
In package.json, update the build line to have the following:
"build": "prisma generate && prisma migrate deploy && next build",
The scripts section can potentially look like the following. Only line 7 was updated:
Deploy!
If all goes right when deploying to Vercel, you should be good to go.
Prisma Generate will build the Prisma Client, Prisma Migrate will update the database structure and move data, and then next build will get your app built.