Checklist: 5 checks for Supabase apps built with Lovable/Bolt/v0 before real users #53632
knbtz65v2c-pixel
started this conversation in
General
Replies: 1 comment
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
I read a lot of AI-built apps. The same five problems come up in most of them. Check these before you post a public link:
1. Supabase keys. The anon/publishable key in the frontend is fine; the service_role (or
sb_secret_...) key is not. Copy the key VALUE from Supabase -> Settings -> API and search both your repo and the built bundle for that value - the key is a token, it does not contain the word "service_role". If it is anywhere the browser can load, rotate it in the dashboard (rotating the legacy key regenerates the JWT secret and logs every user out).2. Row Level Security. Supabase dashboard -> Authentication -> Policies (or Database -> Policies). A table with RLS off is readable by every visitor. A SELECT policy
USING (true)that applies to anon (noTOclause, orTO anon/public) is also readable by every visitor;USING (true) TO authenticatedmeans every logged-in user, which is sometimes what you want. Check INSERT/UPDATE/DELETE the same way:WITH CHECK (true)means anyone can write.3. Checks that live only in the UI. A hidden button is not access control. In the browser's Network tab, copy a request as cURL, delete the
Authorizationheader (keepapikey) and replay it - that is the logged-out view. Then replay it with the header but change the record id to someone else's - that is the other-user view, where most of these apps leak.4. Unhandled input. Send an empty form, a 10,000-character string, and a negative number to every form. Anything that shows an error with code in it, goes blank, or saves a record it should have rejected is a bug a stranger will find first.
5. Dependencies. Run
npm auditonce (it needs package-lock.json; if the project only has bun.lockb, runbun auditor create the lock first). For Python:pip install pip-audit, thenpip-audit. Generators pick versions from their training data, which can be behind.If any of these turns up something you can't read, post the error text (not the keys) and I'll tell you what it means.
All reactions