rls-audit SKILL.md skillA

rls-audit from martinolivero/saas-builder is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add martinolivero/saas-builder/rls-audit@git:20261007.f2beefe

Pins git:20261007.f2beefe in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
martinolivero/saas-builder
Path
skills/rls-audit/SKILL.md
Versions recorded
1
Latest version
git:20261007.f2beefe, committed Oct 7, 2026
Size
10,726 bytes
Repository stars
4
License
MIT

This skill should be used to audit Row-Level Security and database permissions on a Postgres backend exposed through an auto-generated API — Supabase, InsForge, or any Postgres + PostgREST setup. Trigger phrases (English) include "audit my RLS", "review my policies", "is my database exposed", "can users see each other's data", "check the anon key", "row level security", "someone could read my tables", "security definer", "is USING (true) a problem". Trigger phrases (Spanish) include…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# RLS Audit

On a BaaS, the database **is** the API. The public key ships inside your JavaScript bundle, so anyone can send any query your grants and policies allow. This skill finds the gap between what you meant to expose and what the database actually permits.

Analogy: RLS is the bouncer at each door of a building. This skill doesn't ask the bouncer whether they're doing a good job — it walks up to every door with a visitor badge and tries the handle.

## Why a scanner is not enough

A generic scanner greps for `USING (true)` and flags it. That is wrong in both directions: a public price list is *supposed* to be `USING (true)`, while a policy that looks strict (`customer_id = auth.uid()`) can be useless if the user is the one who writes `customer_id`. The scanner has no way to know what you intended. **Intent is the missing input, and you have to declare it.** That declaration is Step 1.

## Scope

Postgres reachable through PostgREST-style auto APIs: Supabase, InsForge, Neon + PostgREST. The role names below (`anon`, `authenticated`) are the common ones — confirm yours. It does not apply to MySQL, MongoDB or Firebase rules.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add martinolivero/saas-builder/rls-audit@sha256:247c18fe59d2c73d

The line at the top of this page pins the label git:20261007.f2beefe, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_ouvtwru7pvxkc7ps.svg)](https://markdownregistry.com/a/art_ouvtwru7pvxkc7ps)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Oct 7, 2026.

versioncommittedcommitsizeaudit
git:20261007.f2beefe latest2026-10-07 f2beefe 10,726 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (10726 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

martinolivero/saas-builder · 4 stars · license MIT · pushed 2026-10-11 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_ouvtwru7pvxkc7ps
GET https://markdownregistry.com/api/v1/resolve?ref=martinolivero/saas-builder/rls-audit
GET https://markdownregistry.com/api/v1/blob/247c18fe59d2c73dea0b95767c515f788557541dacca30a531d5118b26ba5476

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from martinolivero/saas-builder

accessibility SKILL.md skill
martinolivero/saas-builder · skills/accessibility/SKILL.md · This skill should be used when building or reviewing UI for accessibility — keyboard navigation, screen readers, ARIA…
git:20260606.1d02dd6 · audit A · 4 stars
ai-features SKILL.md skill
martinolivero/saas-builder · skills/ai-features/SKILL.md · This skill should be used when putting an LLM inside the product itself — a chatbot or support agent, AI-generated…
git:20261007.f2beefe · audit A · 4 stars
api-design SKILL.md skill
martinolivero/saas-builder · skills/api-design/SKILL.md · This skill should be used when designing or building an API — endpoints, routes, request/response shapes, error…
git:20261007.f2beefe · audit A · 4 stars
architecture-primer SKILL.md skill
martinolivero/saas-builder · skills/architecture-primer/SKILL.md · This skill should be used when the user wants to design, plan, or decide the architecture of a system, app, or platform…
git:20260605.5e4d680 · audit A · 4 stars
auth SKILL.md skill
martinolivero/saas-builder · skills/auth/SKILL.md · This skill should be used when adding authentication or authorization to an app or SaaS — login, signup, sessions…
git:20261007.f2beefe · audit A · 4 stars
data-modeling SKILL.md skill
martinolivero/saas-builder · skills/data-modeling/SKILL.md · This skill should be used when designing a database schema, modeling data, choosing a database, planning migrations, or…
git:20261007.f2beefe · audit A · 4 stars
deployment SKILL.md skill
martinolivero/saas-builder · skills/deployment/SKILL.md · This skill should be used when shipping an app to production — setting up CI/CD, deploys, preview environments, error…
git:20261007.f2beefe · audit A · 4 stars
design-taste-frontend SKILL.md skill
martinolivero/saas-builder · skills/design-taste-frontend/SKILL.md · Anti-slop frontend skill for landing pages, portfolios, and redesigns. The agent reads the brief, infers the right…
git:20260618.989db49 · audit B · 4 stars
frontend-performance SKILL.md skill
martinolivero/saas-builder · skills/frontend-performance/SKILL.md · This skill should be used when a frontend feels slow, fails Core Web Vitals, has a large bundle, or needs performance…
git:20260606.1d02dd6 · audit A · 4 stars
image-to-code SKILL.md skill
martinolivero/saas-builder · skills/image-to-code/SKILL.md · Elite website image-to-code skill for Codex. For visually important web tasks, it must first generate the design…
git:20260618.989db49 · audit A · 4 stars
integrations SKILL.md skill
martinolivero/saas-builder · skills/integrations/SKILL.md · This skill should be used when the product talks to a platform you do not control — receiving webhooks, syncing with a…
git:20261007.f2beefe · audit A · 4 stars
landing-page SKILL.md skill
martinolivero/saas-builder · skills/landing-page/SKILL.md · This skill should be used when the user wants to create a landing page, sales page, home page, lead-capture page, or…
git:20261007.f2beefe · audit A · 4 stars

Every file in martinolivero/saas-builder

Browse by kind, by grade A, or by owner.