Supabase & PostgreSQL CLAUDE.md Generator | 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
CLAUDE.md
Execution Scope
Root Workspace Context
Specification Format
Project Memory (.md)
AI Tool Support
Claude Code & Agent Workflows
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:

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

CLAUDE.md Repository Guidelines Directory

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

/claude-md 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.