Evidence · 32 files · recorded 22 Nov 2026

Every request behind the case study, as recorded.

The findings on the case study are trimmed from these files. Here they are in full: the scripted attacks on the before app, the same attacks on the hardened one, the advisor reports and the leak test output. Keys and tokens are shortened to their first characters; nothing else is edited.

12 files

Attacks on the before app

Each exploit as a scripted request against the local, intentionally vulnerable app, with the full response.

12 files

The same attacks on the hardened app

The replay against the hardened schema and Worker, plus query plans and the rate-limit check.

3 files

Database advisor and UI audits

Supabase-style advisor lints on both schemas, and the AI-look tells in each app’s UI source.

  • Database advisor report: afterevidence/audit/after.mdSource: after/supabase/migrations, loaded into localbase (PGlite, Postgres with Supabase roles and grants). Lints modelled on Supabase splinter. Generated by scripts/audit-db.ts.
  • Database advisor report: beforeevidence/audit/before.mdSource: before/supabase/schema.sql, loaded into localbase (PGlite, Postgres with Supabase roles and grants). Lints modelled on Supabase splinter. Generated by scripts/audit-db.ts.
  • AI-look tells: impeccable detect (v4.10.0)evidence/audit/tells.mdMeasured 2026-11-22T17:48Z. Same command on each app's UI source; telemetry off.
3 files

Leak test reports

Output of the free two-user leak test. Reports list tables and counts, never row values.

2 files

Sources

The prompt log that produced the before app, and the leak test’s README.

  • Two-user RLS leak testtools/leak-test/README.mdSigns in to your Supabase project as two test users and as an anonymous visitor, then reports which tables and database functions show one user's data to a stranger or to the…
  • Lovable prompt log: Folioport (before)before/LOVABLE_PROMPTS.mdBuild me a web app called Folioport. Its a client portal + invoicing tool for small creative agencies (design studios, social media agencies). Agencies can add their clients,…