5-step workflowsupabase database schema postgres rls guided-flow App Builder

Supabase Schema Plan

Design a correct Supabase schema: tables, relationships, RLS policies, and verification queries.

Run this as a guided flow on Flows — verify gates and recovery prompts included →

Flows@flows12d ago

0 runs0 forks0

Chain

Inputs

Step 1

flow-supabase-schema-plan-1-model-the-data

Step 2

flow-supabase-schema-plan-2-write-the-schema-sql

Step 3

flow-supabase-schema-plan-3-enable-rls-with-policies

Step 4

flow-supabase-schema-plan-4-verify-the-policies

Step 5

flow-supabase-schema-plan-5-wire-and-test-app-queries

Final output

Workflow inputs

No inputs required — hit Run to stream each step in order.

Each step streams from its model and feeds the next. BYOK — you pay your provider directly. Add a key in Settings if a step needs one.

Step 1 · List entities, fields, and relationships before writing SQL.

flow-supabase-schema-plan-1-model-the-data

Claude Sonnet 4.6→ {{step_1}}

Awaiting upstream steps…

Step 2 · Turn the model into runnable, ordered SQL.

flow-supabase-schema-plan-2-write-the-schema-sql

Claude Sonnet 4.6→ {{step_2}}

Awaiting upstream steps…

Step 3 · Security lives here: lock every table, then open exactly what is needed.

flow-supabase-schema-plan-3-enable-rls-with-policies

Claude Sonnet 4.6→ {{step_3}}

Awaiting upstream steps…

Step 4 · Prove allowed works and denied fails - from real user contexts.

flow-supabase-schema-plan-4-verify-the-policies

Claude Sonnet 4.6→ {{step_4}}

Awaiting upstream steps…

Step 5 · The schema is done when the app's real queries work through it.

flow-supabase-schema-plan-5-wire-and-test-app-queries

Claude Sonnet 4.6→ {{step_5}}

Awaiting upstream steps…

About this workflow

Design a correct Supabase schema: tables, relationships, RLS policies, and verification queries.

What happens when you run it

1
List entities, fields, and relationships before writing SQL.
Runs flow-supabase-schema-plan-1-model-the-data on Claude Sonnet 4.6
2
Turn the model into runnable, ordered SQL.
Runs flow-supabase-schema-plan-2-write-the-schema-sql on Claude Sonnet 4.6
3
Security lives here: lock every table, then open exactly what is needed.
Runs flow-supabase-schema-plan-3-enable-rls-with-policies on Claude Sonnet 4.6
4
Prove allowed works and denied fails - from real user contexts.
Runs flow-supabase-schema-plan-4-verify-the-policies on Claude Sonnet 4.6
5
The schema is done when the app's real queries work through it.
Runs flow-supabase-schema-plan-5-wire-and-test-app-queries on Claude Sonnet 4.6

Best for

•Recurring tasks you currently copy-paste between tools.
•When a single prompt isn't enough — you need a chain where output(n) feeds prompt(n+1).
•Fork and adapt if your inputs differ materially from the author's use case.

Models used

Claude Sonnet 4.6