070101 prisma database

Skill natuleadan/skills/skills/070101-prisma-database

Multi-domain agent skills collection for AI coding agents (Claude, Cursor, Copilot, OpenCode, and more). Covers programming, biology, cooking, and future domains. Installable via npx skills add.

Install

npx -y skills add natuleadan/skills --skill 070101-prisma-database

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

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

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

1.8 KB, 398 tokens by cl100k_base, as published. Nobody here has run it

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

# 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

// 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/schema.prisma
generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
}

datasource db {
  provider = "postgresql"
}

// 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 — Full Prisma 7 installation and config
Schema Models — Better Auth User, Session, Account, Verification

What ships with it: 4 files

7.1 KB alongside SKILL.md, 1 of them executable

references/

schema-models.md1.9 KB
setup.md1.6 KB

scripts/

validate.pyruns3.1 KB

metadata.json538 B