// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model User {
id Int @id @default(autoincrement())
name String?
email String @unique
emailVerified DateTime?
image String?
posts Post[]
accounts Account[]
sessions Session[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
model Account {
userId Int
type String
provider String
providerAccountId String
refresh_token String?
access_token String?
expires_at Int?
token_type String?
scope String?
id_token String?
session_state String?
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@id([provider, providerAccountId])
}
model Session {
id Int @id @default(autoincrement())
sessionToken String @unique
userId Int
expires DateTime
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
model Post {
id Int @id @default(autoincrement())
title String
content String?
published Boolean @default(false)
authorId Int
author User @relation(fields: [authorId], references: [id])
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
prisma\seed.ts
import { PrismaClient, Prisma } from '@prisma/client'
const prisma = new PrismaClient()
const userData: Prisma.UserCreateInput[] = [
{
name: 'Alice',
email: 'alice@prisma.io',
posts: {
create: [
{
title: 'Join the Prisma Discord',
content: 'https://pris.ly/discord',
published: true,
},
{
title: 'Prisma on YouTube',
content: 'https://pris.ly/youtube',
},
],
},
},
{
name: 'Bob',
email: 'bob@prisma.io',
posts: {
create: [
{
title: 'Follow Prisma on Twitter',
content: 'https://www.twitter.com/prisma',
published: true,
},
],
},
}
]
export async function main() {
for (const u of userData) {
await prisma.user.create({ data: u })
}
}
main()
npx prisma db seed
Next.js + Prisma Postgres Example
TL;DR: Prisma Postgres is a new kind of Postgres database that's optimized for developer productivity. It offers instant provisioning, built-in caching and real-time events, and seamless integration with Prisma ORM.
If you just want to run the app locally, rename .env.example to .env and fill in the values.
1.1 Create a Prisma Postgres instance
Go to the Console and create a new Prisma Postgres instance. Use the DATABASE_URL and PULSE_API_KEY values from the new instance to fill out the .env file.
Application name and homepage URL can be whatever you want.
Authorization callback URL should be http://localhost:3000/api/auth/callback/github After creating the app, you'll be redirected to the app's page. Copy the Client ID and Client Secret values and use them to fill out AUTH_GITHUB_ID and AUTH_GITHUB_SECRET in the .env file.
1.3 Fill out Auth.js secrets
Run npx auth secret --copy to generate a new AUTH_SECRET value. Fill out the .env file with the new value.
2. Install dependencies
Install npm dependencies:
npm install
3. Create and seed the database
Run the following command to create your database. This also creates the needed tables that are defined in prisma/schema.prisma:
npx prisma migrate dev --name init
When npx prisma migrate dev is executed against a newly created database, seeding is also triggered. The seed file in prisma/seed.ts will be executed and your database will be populated with the sample data. If you switched to Prisma Postgres in the previous step, you need to trigger seeding manually (because Prisma Postgres already created an empty database instance for you, so seeding isn't triggered):
npx prisma db seed
4. Start the Next.js server
npm run dev
The server is now running on http://localhost:3000.
📸 Expand for a tour of the app
### Homepage Logged out view:  Logged in view:  ### User Profile  ### Creating Posts  ### View your posts and drafts 
## Next Steps Here are some ways to learn more and expand upon this example: 1. 🚀 [Deploy your app to Vercel](https://vercel.com/docs/frameworks/nextjs) in just a few clicks 2. 📚 Learn more about [Prisma ORM](https://www.prisma.io/docs/orm/overview/introduction/what-is-prisma) and database workflows. 3. 🔍 Explore the [Prisma Client API](https://www.prisma.io/docs/orm/reference/prisma-client-reference) to add more database features. 4. ⭐ Check out more [Prisma examples](https://github.com/prisma/prisma-examples) for inspiration. ## Join our community! - [Discord](https://pris.ly/discord) - [Twitter](https://twitter.com/prisma) - [Bluesky](https://bsky.app/profile/prisma.dev)
