StarCURSOR RULES
Fullstack & DB
Cursor Rules (.mdc) Hub Directory

Supabase & Postgres Cursor Rules (.mdc) | Free & Offline

Production-grade architectural rulebook for Supabase & PostgreSQL. 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
.cursor/rules/supabase.mdc
Execution Scope
Glob Pattern Auto-Match
Specification Format
Frontmatter MDC (.mdc)
AI Tool Support
Cursor IDE & Composer
02 / DRIFT ANALYSIS & VALUE PROPOSITION

Failure Patterns Prevented for Supabase & PostgreSQL

Without This Rule (Default LLM Behavior)Vulnerable

Supabase applications are prone to catastrophic security leaks if Row Level Security (RLS) is omitted or if client-side service_role keys are exposed. Cursor rules ensure RLS is enabled on every table and authentication is validated server-side.

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 include `ENABLE ROW LEVEL SECURITY;` on every created table.
Never expose `SUPABASE_SERVICE_ROLE_KEY` in client code or public bundles.
Use `@supabase/ssr` with Next.js App Router cookies for server-side auth.
Enforce typed database definitions generated via `supabase gen types typescript`.
04 / REPOSITORY PLACEMENT & INSTALLATION

Where to Save This Rule in Your Repository

Export the rules from the interactive editor above or download the full ZIP bundle. Ensure the file is placed at the exact path below relative to your project root so the AI engine automatically loads it:

.cursor/rules/supabase.mdc
05 / ROUTE DIRECTORY & CROSS-TOOLING
Format Pillar HubComprehensive Manual

Cursor Rules (.mdc) Directory & Generator

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

/cursor-rules Directory
06 / FREQUENTLY ASKED QUESTIONS

Technical FAQ: Supabase & PostgreSQL AI Rulebooks

Does this rule check for RLS?

Yes. It mandates that any table creation migration explicitly enables Row-Level Security.