CLI to Test RLS Policies

[Rodrigotari1]

Hey everyone,

I built a CLI tool that automatically tests your RLS policies before they hit production.

Want to make sure it works seamlessly with the Supabase CLI.

What it does:

• Connects to your Supabase DB
• Simulates different user roles (anon, authenticated, custom)
• Tests CRUD operations on all RLS-enabled tables
• Runs everything in transactions with ROLLBACK (no data changes)
• Generates test snapshots for CI/CD diffing

Would love feedback on:

• How to best align with Supabase CLI workflow
• Self-hosted compatibility
• Any specific pain points you encounter with RLS policies

Tagging @aantti who suggested we open this discussion.

Link to the project: https://github.com/Rodrigotari1/supashield
Thanks!