Borrowing it
Nothing to install: this file belongs to conectlens/lenserfight. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/conectlens/lenserfight/main/.claude/agents/lenserfight-profile-access-team/02-supabase-social-graph-engineer/SKILL.mdgit clone --depth 1 https://github.com/conectlens/lenserfightWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/conectlens/lenserfight/02-supabase-social-graph-engineer)<a href="https://agentmods.dev/skills/conectlens/lenserfight/02-supabase-social-graph-engineer"><img src="https://agentmods.dev/badge/skills/conectlens/lenserfight/02-supabase-social-graph-engineer/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/conectlens/lenserfight/02-supabase-social-graph-engineer"><img src="https://agentmods.dev/badge/skills/conectlens/lenserfight/02-supabase-social-graph-engineer.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00044 | $0.00784 |
| Opus 5 | $0.00022 | $0.00392 |
| Sonnet 5 | $0.00009 | $0.00157 |
| Haiku 4.5 | $0.00004 | $0.00078 |
Grade A, and why
supabase-social-graph-engineer scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 10d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 128 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Supabase Social Graph Engineer
Mission
Design the canonical social graph for follows, approvals, blocks, and derived friendship.
Required stance
Use an asymmetric follow model as the primitive. Do not use a symmetric friendship table as the foundation.
Core tables
lensers.profiles
Must include or reference:
profile_idaccount_idusernameslugvisibilityenum:public|privateaccount_statusenum:active|deactivated|pending_deletion|deleteddeleted_atdeletion_scheduled_fordeactivated_at- summary fields for restricted shell
lensers.relationships
One row per directed relationship from viewer to subject.
Columns:
source_profile_idtarget_profile_idstatusenum:pending|accepted|rejected|blocked|removedrequested_atresponded_ataccepted_atremoved_atis_close_circleboolean default falsecreated_by_policytext nullable- unique
(source_profile_id, target_profile_id)
lensers.profile_counters
Denormalized counters:
followers_countfollowing_countmutuals_countoptionalthreads_count_publicprompts_count_publicbadges_count
Optional lensers.blocks
You may keep blocks in relationships.status='blocked', but a dedicated block table is cleaner if moderation rules grow.
Required helper functions
fn_relationship_state(viewer_profile_id, subject_profile_id)
Returns:
- direct relationship status
- reverse relationship status
is_mutual_followis_blocked_any_direction
fn_can_view_profile(viewer_auth_uid, subject_profile_id)
Returns:
- access outcome
- access reason
- can_view_full_profile
- can_view_restricted_shell
- can_request_follow
- can_cancel_request
- can_unfollow
fn_request_follow(subject_profile_id)
Rules:
- public account => create accepted follow immediately
- private active account => create pending request
- deactivated / pending_deletion / deleted => reject
- blocked relation any direction => reject
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 10d ago First seen · 128 lines · 44 tokens per session scan A 97e53c25c3cc
supabase-social-graph-engineer is a skill published in the GitHub repository conectlens/lenserfight (18 stars, last pushed 1mo ago), licensed MIT. It adds 44 tokens to every session and 784 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.
Other skills, from other repositories
database-expert
Advanced database design and administration for PostgreSQL, MongoDB, and Redis. Use when designing schemas, optimizing queries, managing database performance, or implementing data patterns.
generic-fullstack-feature-developer
Guide feature development for full-stack applications with architecture focus. Covers Next.js App Router patterns, NestJS backend services, database models, data workflows, and seamless integration. Use when adding new features, refactoring existing code, or planning major changes.
multitenant
Architecture multitenant avec approche tiered (Shared/Dedicated Schema/DB), RBAC/ABAC, field-level encryption. Use when working with multitenant applications, tenant isolation, data segregation.
testing-paperclip
Paperclip-Testing-Strategie — Vitest, Plugin-Test-Harness aus @paperclipai/plugin-sdk/testing, echte Postgres-Integration-Tests, Cross-Tenant-Isolation. Verwenden Sie dies beim Schreiben oder Reviewen von Paperclip-Tests.
neon
Neon separates compute and storage, allowing instant database branching and autoscaling. For most Node.js applications, use the @neondatabase/serverless driver over standard pg to leverage WebSocket connections, which bypass serverless environment connection limits.
postgresql
Skill "postgresql" from ashish7802/awesome-api-skills, covering postgresql skill, ecosystem graph preview, recommended next skills, quick start and production patterns.