# Prisma Migration

> >

- **Type:** Skill
- **Install:** `agentstack add skill-nexadevapp-nexa-claude-skills-marketplace-prisma-migration`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [nexadevapp](https://agentstack.voostack.com/s/nexadevapp)
- **Installs:** 0
- **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills)
- **Latest version:** 0.1.0
- **License:** Apache-2.0
- **Upstream author:** [nexadevapp](https://github.com/nexadevapp)
- **Source:** https://github.com/nexadevapp/nexa-claude-skills-marketplace/tree/main/nexa-claude-nextjs/skills/prisma-migration

## Install

```sh
agentstack add skill-nexadevapp-nexa-claude-skills-marketplace-prisma-migration
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Prisma Migration

## Instructions

Create or update the Prisma schema and generate migrations based on `docs/entity_model.md`.

## DO NOT

- Manually write SQL migration files (use `npx prisma migrate dev` to generate them)
- Drop existing tables or models without explicit user confirmation
- Skip relations defined in the entity model
- Use `autoincrement()` unless the entity model explicitly requires it (prefer `uuid()` or `cuid()` for IDs)

## Nexa Rules Gate

Read and follow `${CLAUDE_PLUGIN_ROOT}/shared/readiness/NEXA_RULES_GATE.md`.

## Sprint Branch Gate

Read and follow `${CLAUDE_PLUGIN_ROOT}/shared/readiness/SPRINT_BRANCH_GATE.md`.

## Schema Location

```
prisma/schema.prisma
```

## Example Schema

```prisma
model RoomType {
  id          String  @id @default(cuid())
  name        String  @unique @db.VarChar(50)
  description String? @db.VarChar(500)
  capacity    Int
  price       Decimal @db.Decimal(10, 2)
  rooms       Room[]

  @@map("room_type")
}

model Room {
  id           String       @id @default(cuid())
  number       String       @unique @db.VarChar(10)
  roomType     RoomType     @relation(fields: [roomTypeId], references: [id])
  roomTypeId   String       @map("room_type_id")
  reservations Reservation[]

  @@map("room")
}
```

## Workflow

1. Read `docs/entity_model.md`
2. Read the existing `prisma/schema.prisma` if it exists
3. Create or update Prisma models with fields, types, relations, and constraints
4. Map entity model validation rules to Prisma attributes (`@unique`, `@db.*`, `@default`, etc.)
5. Ensure relations match the entity model (one-to-many, many-to-many, etc.)
6. Run `npx prisma migrate dev --name ` to generate the migration
7. Validate the migration:
    - Verify all entities from the entity model have corresponding models
    - Verify all relations are bidirectional where needed
    - Verify field types and constraints match the entity model
    - Verify the generated SQL migration is correct

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [nexadevapp](https://github.com/nexadevapp)
- **Source:** [nexadevapp/nexa-claude-skills-marketplace](https://github.com/nexadevapp/nexa-claude-skills-marketplace)
- **License:** Apache-2.0

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-nexadevapp-nexa-claude-skills-marketplace-prisma-migration
- Seller: https://agentstack.voostack.com/s/nexadevapp
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.