prisma

Name: prisma
Author: FaizAhemad962

Use when editing the Prisma schema, creating migrations, or writing database queries for Gadgify.

by FaizAhemad962(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Instruction file imported from FaizAhemad962/gadgify (.github/instructions/prisma.instructions.md). Copyright stays with the author.

Prisma & Database Rules

Schema Changes

Edit backend/prisma/schema.prisma
Run npx prisma migrate dev --name descriptive_name
Run npx prisma generate to update the client

Naming Conventions

Models: PascalCase singular (User, Product, OrderItem)
Fields: camelCase (createdAt, totalPrice, isActive)
Enums: UPPER_SNAKE_CASE values (PENDING, DELIVERED, CANCELLED)

Relationships

Always define both sides of relations
Use @relation with explicit field names
Add onDelete cascade/restrict as appropriate

Best Practices

Add @default(now()) to createdAt, @updatedAt to updatedAt
Use Decimal for money fields — never Float
Add indexes on frequently queried fields (@@index)
Add unique constraints where needed (@@unique, @unique)

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/faizahemad962-gadgify-prisma-instructions/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

faizahemad962-gadgify-prisma-instructions.ocm.jsonjson

{
  "ocm": "1",
  "id": "faizahemad962-gadgify-prisma-instructions",
  "kind": "skill",
  "name": "prisma",
  "description": "Use when editing the Prisma schema, creating migrations, or writing database queries for Gadgify.",
  "publisher": "FaizAhemad962",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "github-instructions"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Use when editing the Prisma schema, creating migrations, or writing database queries for Gadgify."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github-instructions",
      "repository": "https://github.com/FaizAhemad962/gadgify",
      "path": ".github/instructions/prisma.instructions.md",
      "ref": "1c0ceb067888e30eb83faa1791b246bb08c37674",
      "url": "https://github.com/FaizAhemad962/gadgify/blob/1c0ceb067888e30eb83faa1791b246bb08c37674/.github/instructions/prisma.instructions.md",
      "key": "FaizAhemad962/gadgify/.github/instructions/prisma.instructions.md"
    },
    "applies_to": "backend/prisma/**"
  },
  "instructions": "# Prisma & Database Rules\n\n## Schema Changes\n\n1. Edit `backend/prisma/schema.prisma`\n2. Run `npx prisma migrate dev --name descriptive_name`\n3. Run `npx prisma generate` to update the client\n\n## Naming Conventions\n\n- Models: PascalCase singular (`User`, `Product`, `OrderItem`)\n- Fields: camelCase (`createdAt`, `totalPrice`, `isActive`)\n- Enums: UPPER_SNAKE_CASE values (`PENDING`, `DELIVERED`, `CANCELLED`)\n\n## Relationships\n\n- Always define both sides of relations\n- Use `@relation` with explicit field names\n- Add `onDelete` cascade/restrict as appropriate\n\n## Best Practices\n\n- Add `@default(now",
  "cost": {
    "context_tokens": 203
  }
}

Fetch it by URL: GET /api/v1/registry/faizahemad962-gadgify-prisma-instructions/manifest?version=1.0.0