CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

security-review

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.

Quality

83%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Low

Low-risk findings worth noting

SKILL.md
Quality
Evals
Security

Security Review Skill

Use this skill when reviewing code that touches authentication, database schemas, environment variables, storage, or external API gateways.

Repository Review Protocol

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.

Review Checklist

1. Key Confinement & Environment Safety

  • Service Role Key: Ensure the Supabase service_role key is never exposed to public clients. Never prefix variables containing secret keys with NEXT_PUBLIC_.
  • Credential Storage: Verify that credentials are not committed or hardcoded. Look for placeholder usage in .env.example.

2. Database & Storage Safety

  • Row-Level Security (RLS): Ensure RLS is active on all public/exposed tables. Avoid deprecated checkers like auth.role() and prefer strict role predicates (TO authenticated).
  • Owner Scope Verification: Verify that API endpoints filter queries by the authenticated user's ID (user_id) to prevent unauthorized cross-tenant data access.
  • Storage Buckets: Verify that files uploaded to private buckets (clinical-documents, clinical-images) require validated user signatures for retrieval.
  • Views: Ensure Postgres views are created with security invokers (WITH (security_invoker = true)) so they respect RLS.
Repository

BigSimmo/PsychSift

Path

.cursor/skills/security-review/SKILL.md

Last updated
First committed

Is this your skill?

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.