Prisma ORM setup in NextJS - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Prisma ORM used for in a Next.js project?

Prisma ORM helps manage database access by providing an easy and safe way to read and write data using JavaScript or TypeScript instead of raw SQL queries.

beginner

Which command initializes Prisma in a Next.js project?

The command npx prisma init sets up Prisma by creating a prisma folder with a schema file and a .env file for database connection.

intermediate

What is the purpose of the schema.prisma file?

It defines your database models (tables) and their fields, plus the database connection details. Prisma uses it to generate code for database operations.

intermediate

How do you generate Prisma Client after updating the schema?

Run npx prisma generate to create the Prisma Client, which is the code you use in your app to interact with the database.

beginner

Why should you add Prisma Client to your Next.js API routes?

Adding Prisma Client lets your API routes read and write data safely and efficiently, making your app dynamic and connected to your database.

What file does npx prisma init create to store your database connection URL?

A .env

B package.json

C next.config.js

D prisma/schema.prisma

The .env file stores environment variables like the database connection URL securely.

Which command updates your database schema after changing schema.prisma?

A npx prisma migrate dev

B npm run dev

C npx prisma generate

D next build

npx prisma migrate dev applies schema changes to your database.

Where do you import Prisma Client in a Next.js project?

A In static HTML files

B In CSS files

C In API route files

D In the public folder

Prisma Client is used in API routes to interact with the database.

What language is Prisma Client generated in for Next.js projects?

A Java

B JavaScript/TypeScript

C Ruby

D Python

Prisma Client is generated in JavaScript or TypeScript to work with Next.js.

Which folder does Prisma create to hold its schema file?

A components

B src

C pages

D prisma

The prisma folder contains the schema.prisma file.

Explain the steps to set up Prisma ORM in a new Next.js project.

Think about installation, initialization, configuration, migration, and usage.

Describe how Prisma Client helps in managing database operations in Next.js.

Focus on how Prisma Client makes database work easier and safer.