# 070101 Prisma Database

> Prisma 7 setup with PostgreSQL driver adapters and Better Auth schema models (User, Session, Account, Verification).

- Skill: `natuleadan/070101-prisma-database` (Agent Skill, multi-file: 5 files)
- Install (CLI): `npx skillmds@latest add natuleadan/070101-prisma-database`
- Raw SKILL.md: https://api.skillmd.com/api/skills/natuleadan/070101-prisma-database/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- License: MIT
- Author: natuleadan (https://skillmd.com/u/natuleadan)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/natuleadan/070101-prisma-database

---


# Prisma + Database Setup

## Overview

Prisma 7 uses driver adapters instead of traditional database clients. This skill covers setup, configuration, and the required Better Auth schema models.

## Quick Start

```bash
# Install
npm install @prisma/client @prisma/adapter-pg pg dotenv
npm install -D prisma @types/pg

# Configure
# Create prisma.config.ts in project root

# Generate client
npx prisma generate
```

## Key Files

| File | Purpose |
|------|---------|
| `prisma.config.ts` | Prisma configuration with driver adapter |
| `prisma/schema.prisma` | Schema definition (User, Session, Account, Verification) |
| `src/infrastructure/database/prisma.ts` | Client instantiation with PrismaPg adapter |

## Quick Reference

```typescript
// prisma.config.ts
import "dotenv/config"
import { defineConfig, env } from "prisma/config"

export default defineConfig({
  schema: "prisma/schema.prisma",
  datasource: { url: env("DATABASE_URL") },
})
```

```prisma
// prisma/schema.prisma
generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
}

datasource db {
  provider = "postgresql"
}
```

```typescript
// src/infrastructure/database/prisma.ts
import { PrismaPg } from "@prisma/adapter-pg"
import { PrismaClient } from "../../../generated/prisma/client"

const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL })
const prisma = new PrismaClient({ adapter })

export default prisma
```

## References

- [Setup Guide](references/setup.md) — Full Prisma 7 installation and config
- [Schema Models](references/schema-models.md) — Better Auth User, Session, Account, Verification