StarAI RULEBOOK
Fullstack & DB
Windsurf Cascade Rules Hub Directory

Drizzle ORM Windsurf Cascade Rules

Production-grade architectural rulebook for Drizzle 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/drizzle.md
Execution Scope
Project Context
Specification Format
Markdown / Config
AI Tool Support
Universal AI Assistants
02 / DRIFT ANALYSIS & VALUE PROPOSITION

Failure Patterns Prevented for Drizzle ORM

Without This Rule (Default LLM Behavior)Vulnerable

Drizzle ORM uses TypeScript-native schema definitions. Rules ensure Cursor properly separates schema declarations, client queries, and migration scripts.

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
Define schemas using pgTable/sqliteTable with explicit foreign keys and constraints.
Use the query builder (`db.query.users.findFirst`) for relational reads and SQL builder for complex mutations.
Never write raw unsanitized SQL string concatenation; use the `sql` tagged template literal.
04 / REPOSITORY PLACEMENT & 3-STEP TERMINAL INSTALLATION

How to Install Drizzle 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/drizzle.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/drizzle.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/drizzle.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/drizzle" -o ".windsurf/rules/drizzle.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/drizzle.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 Drizzle 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: Drizzle ORM AI Rulebooks

Does this cover both relational queries and raw SQL?

Yes, it guides Cursor on when to use Drizzle's relational queries vs parameterized `sql` tagged templates.