Claude GitHub Copilot Skill

nestjs-prisma

Use when building a NestJS application with Prisma — covers PrismaService setup as an injectable singleton, repository pattern integration, and testing with Prisma mocks.

LLM Mart · 0 points · 2 views 0 listing impressions 0 install-command copies
Download drvoss-everything-copilot-cli-skills_development_nestjs-prisma-1ca2355.zip · 1 KB

Install

skills CLI npx skills add https://github.com/drvoss/everything-copilot-cli/tree/main/skills/development/nestjs-prisma
Claude Code claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install drvoss-everything-copilot-cli@llmmart
Git git clone https://github.com/drvoss/everything-copilot-cli.git

The skills CLI installs just this skill, for any of its supported agents. Claude Code installs the whole drvoss/everything-copilot-cli collection as a plugin from our marketplace. Git is the plain clone.

Skill manifest

NestJS + Prisma Combo Skill

When to Use

  • Setting up Prisma in a NestJS project for the first time
  • Implementing a data access layer using Prisma as the ORM
  • Writing unit tests for services that depend on Prisma
  • Debugging connection pooling or client lifecycle issues

Workflow

1. PrismaService Setup

// src/prisma/prisma.service.ts
import { Injectable, OnModuleInit, OnModuleDestroy } from "@nestjs/common"
import { PrismaClient } from "@prisma/client"

@Injectable()
export class PrismaService
  extends PrismaClient
  implements OnModuleInit, OnModuleDestroy
{
  async onModuleInit() {
    await this.$connect()
  }
  async onModuleDestroy() {
    await this.$disconnect()
  }
}
// src/prisma/prisma.module.ts
import { Global, Module } from "@nestjs/common"
import { PrismaService } from "./prisma.service"

@Global()
@Module({
  providers: [PrismaService],
  exports: [PrismaService],
})
export class PrismaModule {}

Import PrismaModule in AppModule once — @Global() makes it available everywhere.

2. Using PrismaService in a Feature Service

// src/users/users.service.ts
import { Injectable } from "@nestjs/common"
import { PrismaService } from "../prisma/prisma.service"

@Injectable()
export class UsersService {
  constructor(private prisma: PrismaService) {}

  async findAll() {
    return this.prisma.user.findMany({
      select: { id: true, name: true, email: true },
    })
  }

  async create(data: { name: string; email: string }) {
    return this.prisma.user.create({ data })
  }
}

3. Unit Testing with Prisma Mock

// src/users/users.service.spec.ts
import { Test } from "@nestjs/testing"
import { UsersService } from "./users.service"
import { PrismaService } from "../prisma/prisma.service"

const mockPrismaService = {
  user: {
    findMany: jest.fn(),
    create: jest.fn(),
  },
}

describe("UsersService", () => {
  let service: UsersService

  beforeEach(async () => {
    const module = await Test.createTestingModule({
      providers: [
        UsersService,
        { provide: PrismaService, useValue: mockPrismaService },
      ],
    }).compile()

    service = module.get<UsersService>(UsersService)
  })

  it("returns all users", async () => {
    mockPrismaService.user.findMany.mockResolvedValue([{ id: 1, name: "Alice" }])
    const result = await service.findAll()
    expect(result).toHaveLength(1)
  })
})

4. Environment Setup Checklist

# 1. Install
pnpm add @prisma/client
pnpm add -D prisma

# 2. Initialize
pnpm prisma init

# 3. Add DATABASE_URL to .env
# 4. Define schema then migrate
pnpm prisma migrate dev --name init

# 5. Generate client
pnpm prisma generate

Rules Applied

  • rules/frameworks/nestjs.md — module structure, DI, controllers, security
  • rules/frameworks/prisma.md — schema design, client lifecycle, query safety
  • rules/common/security.md — secrets, input validation
Files (everything-copilot-cli)
  • SKILL.md 3.2 KB
    ---
    name: nestjs-prisma
    license: MIT
    description: Use when building a NestJS application with Prisma — covers PrismaService setup as an injectable singleton, repository pattern integration, and testing with Prisma mocks.
    metadata:
      category: development
      agent_type: general-purpose
      combo: "nestjs, prisma"
    ---
    
    # NestJS + Prisma Combo Skill
    
    ## When to Use
    
    - Setting up Prisma in a NestJS project for the first time
    - Implementing a data access layer using Prisma as the ORM
    - Writing unit tests for services that depend on Prisma
    - Debugging connection pooling or client lifecycle issues
    
    ## Workflow
    
    ### 1. PrismaService Setup
    
    ```typescript
    // src/prisma/prisma.service.ts
    import { Injectable, OnModuleInit, OnModuleDestroy } from "@nestjs/common"
    import { PrismaClient } from "@prisma/client"
    
    @Injectable()
    export class PrismaService
      extends PrismaClient
      implements OnModuleInit, OnModuleDestroy
    {
      async onModuleInit() {
        await this.$connect()
      }
      async onModuleDestroy() {
        await this.$disconnect()
      }
    }
    ```
    
    ```typescript
    // src/prisma/prisma.module.ts
    import { Global, Module } from "@nestjs/common"
    import { PrismaService } from "./prisma.service"
    
    @Global()
    @Module({
      providers: [PrismaService],
      exports: [PrismaService],
    })
    export class PrismaModule {}
    ```
    
    Import `PrismaModule` in `AppModule` once — `@Global()` makes it available everywhere.
    
    ### 2. Using PrismaService in a Feature Service
    
    ```typescript
    // src/users/users.service.ts
    import { Injectable } from "@nestjs/common"
    import { PrismaService } from "../prisma/prisma.service"
    
    @Injectable()
    export class UsersService {
      constructor(private prisma: PrismaService) {}
    
      async findAll() {
        return this.prisma.user.findMany({
          select: { id: true, name: true, email: true },
        })
      }
    
      async create(data: { name: string; email: string }) {
        return this.prisma.user.create({ data })
      }
    }
    ```
    
    ### 3. Unit Testing with Prisma Mock
    
    ```typescript
    // src/users/users.service.spec.ts
    import { Test } from "@nestjs/testing"
    import { UsersService } from "./users.service"
    import { PrismaService } from "../prisma/prisma.service"
    
    const mockPrismaService = {
      user: {
        findMany: jest.fn(),
        create: jest.fn(),
      },
    }
    
    describe("UsersService", () => {
      let service: UsersService
    
      beforeEach(async () => {
        const module = await Test.createTestingModule({
          providers: [
            UsersService,
            { provide: PrismaService, useValue: mockPrismaService },
          ],
        }).compile()
    
        service = module.get<UsersService>(UsersService)
      })
    
      it("returns all users", async () => {
        mockPrismaService.user.findMany.mockResolvedValue([{ id: 1, name: "Alice" }])
        const result = await service.findAll()
        expect(result).toHaveLength(1)
      })
    })
    ```
    
    ### 4. Environment Setup Checklist
    
    ```bash
    # 1. Install
    pnpm add @prisma/client
    pnpm add -D prisma
    
    # 2. Initialize
    pnpm prisma init
    
    # 3. Add DATABASE_URL to .env
    # 4. Define schema then migrate
    pnpm prisma migrate dev --name init
    
    # 5. Generate client
    pnpm prisma generate
    ```
    
    ## Rules Applied
    
    - `rules/frameworks/nestjs.md` — module structure, DI, controllers, security
    - `rules/frameworks/prisma.md` — schema design, client lifecycle, query safety
    - `rules/common/security.md` — secrets, input validation
    

Comments (0)

Sign in to join the conversation.

No comments yet.

Reviews (0)

No reviews yet.