Reviews credentials, token handling, JWT claims, service-role confinement, public error envelopes, Row-Level Security (RLS) policies, and private bucket access. Use during database, authentication, or network boundary edits.
83%
Does it follow best practices?
Run evals on this skill
Adds up to 20 points to the overall score
Low
Low-risk findings worth noting
Use this skill when reviewing code that touches authentication, database schemas, environment variables, storage, or external API gateways.
Follow AGENTS.md review throttling and docs/codex-review-protocol.md before starting. Do not review opportunistically or mutate files during pure review. After a completed PR review, post one Review record comment on the PR (see Records); never edit the frozen docs/branch-review-ledger.md table.
service_role key is never exposed to public clients. Never prefix variables containing secret keys with NEXT_PUBLIC_..env.example.auth.role() and prefer strict role predicates (TO authenticated).user_id) to prevent unauthorized cross-tenant data access.clinical-documents, clinical-images) require validated user signatures for retrieval.WITH (security_invoker = true)) so they respect RLS.BigSimmo/PsychSift
0d5a97a
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.