How do I query a database using Prisma in a Next.js application?

How do I query a database using Prisma in a Next.js application?

To query a database with Prisma in Next.js, you first need to set up Prisma in your project. Have you done that?

Yes, I've set up Prisma. What's the next step?

Great! You can create a Prisma client instance and use it to perform queries. For example, to fetch all users, you can use await prisma.user.findMany().

Can you show me how to implement that in a Next.js API route?

Sure! In your pages/api/users.js, you can import Prisma and create an API route like this:

import { PrismaClient } from '@prisma/client';
const prisma = new PrismaClient();

export default async function handler(req, res) {
  const users = await prisma.user.findMany();
  res.status(200).json(users);
}