Files
supabase/apps/studio/components/interfaces/Auth/RLSTester/RoleSelector.tsx
Joshen Lim 5f867e5f6c Feature Preview: RLS Tester (#45121)
## Context

Resolves FE-3077
Related discussion: https://github.com/orgs/supabase/discussions/45233

Verifying the correctness of your RLS policies set up has always been a
gap, as highlighted by a number of GitHub discussions like
[here](https://github.com/orgs/supabase/discussions/12269) and
[here](https://github.com/orgs/supabase/discussions/14401). As such,
we're piloting a dedicated UI for RLS testing (using role impersonation
as the base), in which you'll be able to
- Run a SQL query as a user (not logged in / logged in - this is the
role impersonation part)
- See which RLS policies are being evaluated as part of the query
- And hopefully be able to debug which policies are not set up correctly

Changes are currently set as a feature preview - and we'll iterate as we
get feedback from everyone 🙂 🙏

<img width="613" height="957" alt="image"
src="https://github.com/user-attachments/assets/83c37f8a-28fc-43b3-b0ff-e28571d8710c"
/>


<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->
## Summary by CodeRabbit

* **New Features**
* RLS Tester: run queries as anon or authenticated users, view inferred
SQL, per-table policy summaries, and data previews of accessible rows.
* UI preview: new RLS Tester preview card and modal with opt-in toggle;
RLS Tester sheet with role/user selector and query editor.
  * SQLEditor: “Explain” tab is always visible.

* **Chores**
* Added supporting API endpoints, background checks for table RLS
status, and a local-storage flag to persist the preview opt-in.
<!-- end of auto-generated comment: release notes by coderabbit.ai -->
2026-04-28 15:02:49 +08:00

39 lines
1.2 KiB
TypeScript

import { RadioGroupStacked, RadioGroupStackedItem } from 'ui'
import { FormItemLayout } from 'ui-patterns/form/FormItemLayout/FormItemLayout'
import { useRoleImpersonationStateSnapshot } from '@/state/role-impersonation-state'
interface RoleSelectorProps {
onSelectRole: (value: 'anon' | 'authenticated') => void
}
export const RoleSelector = ({ onSelectRole }: RoleSelectorProps) => {
const { role, setRole } = useRoleImpersonationStateSnapshot()
return (
<FormItemLayout isReactForm={false} label="Test as">
<RadioGroupStacked defaultValue={role?.role ?? 'anon'}>
<RadioGroupStackedItem
value="anon"
id="anon"
label="Anonymous user"
description="Not logged in"
onClick={() => {
onSelectRole('anon')
setRole({ type: 'postgrest', role: 'anon' })
}}
/>
<RadioGroupStackedItem
value="authenticated"
id="authenticated"
label="Authenticated user"
description="A specific logged in user"
onClick={() => {
onSelectRole('authenticated')
}}
/>
</RadioGroupStacked>
</FormItemLayout>
)
}