---
title: "Next.js & Prisma Postgres Auth Starter"
description: "Get started with Next.js, Prisma Postgres, and Auth.js"
url: "https://vercel.com/templates/next.js/prisma-postgres"
links:
repository: "https://github.com/prisma/nextjs-auth-starter"
demo: "https://nextjs-auth-starter-mu.vercel.app/"
deploy: "https://vercel.com/new/clone?demo-title=Next.js+%26+Prisma+Postgres+Auth+Starter&demo-description=Get+started+with+Next.js%2C+Prisma+Postgres%2C+and+Auth.js&demo-url=https%3A%2F%2Fnextjs-auth-starter-mu.vercel.app%2F&demo-image=%2F%2Fimages.ctfassets.net%2Fe5382hct74si%2F2gqUOlJGGNzevIE0TQ1RpU%2F40edbfa3fbbea2d37f0d7f8f1f64098d%2Fnextjs-auth-starter.png&project-name=Next.js+%26+Prisma+Postgres+Auth+Starter&repository-name=prisma-postgres&repository-url=https%3A%2F%2Fgithub.com%2Fprisma%2Fnextjs-auth-starter&from=templates&skippable-integrations=1&products=%5B%7B%22type%22%3A%22integration%22%2C%22protocol%22%3A%22storage%22%2C%22productSlug%22%3A%22prisma-postgres%22%2C%22integrationSlug%22%3A%22prisma%22%7D%5D"
---
# Next.js & Prisma Postgres Auth Starter
Get started with Next.js, Prisma Postgres, and Auth.js
# Next.js & Prisma Postgres Auth Starter
This repository provides a boilerplate to quickly set up a Next.js demo application with authentication using [NextAuth.js v4](https://next-auth.js.org/), [Prisma Postgres](https://www.prisma.io/postgres) and [Prisma ORM](https://www.prisma.io/orm), and deploy it to Vercel. It includes an easy setup process and example routes that demonstrate basic CRUD operations against the database.
## Features
- Next.js 15 app with App Router, Server Actions & API Routes
- Data modeling, database migrations, seeding & querying
- Log in and sign up authentication flows
- CRUD operations to create, view and delete blog posts
- Pagination, filtering & relations queries
## Getting started
### 1. Install dependencies
After cloning the repo and navigating into it, install dependencies:
```
npm install
```
### 1. Create a Prisma Postgres instance
Create a Prisma Postgres instance by running the following command:
```
npx prisma init --db
```
This command is interactive and will prompt you to:
1. Log in to the [Prisma Console](https://console.prisma.io)
1. Select a **region** for your Prisma Postgres instance
1. Give a **name** to your Prisma project
Once the command has terminated, copy the **Database URL** from the terminal output. You'll need it in the next step when you configure your `.env` file.
### 2. Set up your `.env` file
You now need to configure your database connection via an environment variable.
First, create an `.env` file:
```bash
touch .env
```
Then update the `.env` file by replacing the existing `DATABASE_URL` value with the one you previously copied. It will look similar to this:
```bash
DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=PRISMA_POSTGRES_API_KEY"
```
To ensure your authentication works properly, you'll also need to set [env vars for NextAuth.js](https://next-auth.js.org/configuration/options):
```bash
AUTH_SECRET="RANDOM_32_CHARACTER_STRING"
```
You can generate a random 32 character string for the `AUTH_SECRET` secret with this command:
```
npx auth secret
```
In the end, your entire `.env` file should look similar to this (but using _your own values_ for the env vars):
```bash
DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhcGlfa2V5IjoiMWEzMjBiYTEtYjg2Yy00ZTA5LThmZTktZDBhODA3YjQwZjBkIiwidGVuYW50X2lkIjoiY2RhYmM3ZTU1NzdmMmIxMmM0ZTI1Y2IwNWJhZmZhZmU4NjAxNzkxZThlMzhlYjI1NDgwNmIzZjI5NmU1NTkzNiIsImludGVybmFsX3NlY3JldCI6ImI3YmQzMjFhLTY2ODQtNGRiMC05ZWRiLWIyMGE2ZTQ0ZDMwMSJ9.JgKXQBatjjh7GIG3_fRHDnia6bDv8BdwvaX5F-XdBfw"
AUTH_SECRET="gTwLSXFeNWFRpUTmxlRniOfegXYw445pd0k6JqXd7Ag="
```
### 3. Migrate the database
Run the following commands to set up your database and Prisma schema:
```bash
npx prisma migrate dev --name init
```
### 4. Seed the database
Add initial data to your database:
```bash
npx prisma db seed
```
Expand for yarn, pnpm or bun
```bash
# Using yarn
yarn prisma db seed
# Using pnpm
pnpm prisma db seed
# Using bun
bun prisma db seed
```
### 5. Run the app
Start the development server:
```bash
npm run dev
```
Expand for yarn, pnpm or bun
```bash
# Using yarn
yarn dev
# Using pnpm
pnpm run dev
# Using bun
bun run dev
```
Once the server is running, visit `http://localhost:3000` to start using the app.
## Next steps
- [Prisma ORM documentation](https://www.prisma.io/docs/orm)
- [Prisma Client API reference](https://www.prisma.io/docs/orm/prisma-client)
- [Join our Discord community](https://discord.com/invite/prisma)
- [Follow us on Twitter](https://twitter.com/prisma)
## Related Templates
### [Fullstack Blog with Next.js + Prisma](https://vercel.com/templates/next.js/fullstack-prisma-nextjs-blog)
Fullstack Blog with Next.js, Typescript and Prisma
### [CockroachDB + Prisma + Next.js Starter](https://vercel.com/templates/next.js/cockroachdb-prisma-nextjs-starter)
A starter for full-stack serverless apps using CockroachDB, Prisma, and Next.js.
## Related Integrations
### [Prisma](https://vercel.com/marketplace/prisma)
Instant Serverless Postgres
---
## Additional documentation
The [Vercel Knowledge Base](https://vercel.com/kb) contains guides and answers to common questions about Vercel, including deployment, framework configuration, domains, caching, and troubleshooting.