Supabase & Lovable Production Ops
Debug RLS, hide sensitive columns, verify deploys and run safe data operations on a live Supabase + Lovable app.
About this skill
What it does
Field-tested recipes from running a production school-management app: simulate any user in SQL to debug Row Level Security, column-level grants and masking views, verify that a Lovable deploy actually shipped your change, survive stale-chunk reloads, migrate between projects and work with the Lovable agent without surprises.
What you get
- RLS simulation and recipes (SQL)
- Column privilege and safe-view patterns
- Deploy verification script and chunk-reload snippet
- Safe production data playbook and migration order
Who it is for
Teams shipping Supabase apps built with Lovable or Vite who need production-grade operations.
What's inside
- SKILL.md with triage into six tracks
- references/ – RLS recipes and pitfalls, column privileges, deploy verification, safe data ops, migration playbook, Lovable agent workflow, 20 incident patterns
- scripts/rls-sim.sql, verify-deploy.sh, backup-db.sh, discover-tables-from-bundle.js, export-rest-tables.js
- templates/ – chunk-reload.ts, column-grants.sql, safe-view.sql, security-definer-rpc.sql, soft-delete.sql