StarAI RULEBOOK
Fullstack & DB
Windsurf Cascade Rules Hub Directory

Prisma ORM Windsurf Cascade Rules

Production-grade architectural rulebook for Prisma ORM. Engineered to eliminate LLM hallucinations, enforce strict deterministic conventions, and prevent architectural drift across Cursor IDE, Claude Code CLI, and autonomous multi-agent pipelines.

Target Path
.windsurf/rules/prisma.md
Execution Scope
Project Context
Specification Format
Markdown / Config
AI Tool Support
Universal AI Assistants
02 / DRIFT ANALYSIS & VALUE PROPOSITION

Failure Patterns Prevented for Prisma ORM

Without This Rule (Default LLM Behavior)Vulnerable

Default AI Prisma queries often select entire entity trees, causing catastrophic over-fetching. These rules enforce `select` fields, explicit index hints, and batch transactions.

Hallucination Symptoms
  • Invokes deprecated or removed APIs from older model training weights
  • Generates conflicting configuration files and invalid imports
  • Silently drops type-safety, boundaries, or transaction isolation
With This Rule (Guaranteed Invariants)Deterministic
Always use `select` to specify required fields; avoid raw `findMany()` fetching unused relations.
Wrap multi-step dependent writes inside `prisma.$transaction()`.
Ensure foreign keys and queried filter fields are indexed with `@@index` in schema.prisma.
Use global singleton PrismaClient to avoid exhausting connection pools in serverless environments.
04 / REPOSITORY PLACEMENT & 3-STEP TERMINAL INSTALLATION

How to Install Prisma ORM Windsurf Cascade Rules via Terminal

1

Step 1: Open Project Directory & Verify Target Placement

Open your terminal and navigate to your project root folder where the .windsurf/rules/prisma.md file will reside. Ensure the file is placed at the exact path below relative to your project root so the AI engine automatically loads it:

.windsurf/rules/prisma.md
2

Step 2: Fetch Rule File via Terminal Command

Run curl, PowerShell, or wget to stream the rule directly from the DevScratchpad raw API endpoint and write it to .windsurf/rules/prisma.md:

Terminal One-Liner Install

Run directly in your project root to stream and write this rule file with one command.

Raw API Stream
$mkdir -p ".windsurf/rules" && curl -fsSL "https://www.devscratchpad.tech/api/raw/windsurf-rules/prisma" -o ".windsurf/rules/prisma.md"
3

Step 3: Verify and Activate with AI Agent

Launch your AI coding assistant (Universal AI Assistants). The assistant will automatically discover .windsurf/rules/prisma.md in your repository and apply the architectural guardrails, type constraints, and verification protocols during code generation.

05 / ROUTE DIRECTORY & CROSS-TOOLING
Format Pillar HubComprehensive Manual

Windsurf Cascade Rules Directory & Generator

Inspect the complete specification manual, glob patterns, directory rules, and all available presets in our central directory.

/windsurf-rules Directory
06 / RECOMMENDED OFFLINE DEVELOPER TOOLS

Pair With Prisma ORM Client-Side Utilities

100% private, browser-based utilities to test, format, and inspect code generated by your AI rules.

View All 28 Tools

Migrating from Legacy .cursorrules or CLAUDE.md?

Use our free, offline converter to transform monolithic rulebooks into modular Cursor .mdc, Claude SKILL.md, and Windsurf Cascade rules.

Convert Rules Free →
07 / FREQUENTLY ASKED QUESTIONS

Technical FAQ: Prisma ORM AI Rulebooks

Why should Prisma queries always specify select?

Selecting only required fields reduces database memory, shrinks JSON network payloads, and avoids accidentally exposing password hashes or internal fields.