Cursor rule

1---
2description: How to add RLS policies for a database table
3globs: *.ts
4alwaysApply: false
5---
6 
7To add RLS, we need to create a SQL file detailing the row-level-security application.
8The database is postgres, running on supabase.
9 
10It should look similar to:
11 
12-- Policy for labels table
13CREATE POLICY "labels_tenant_isolation_policy" ON "labels"
14FOR ALL
15USING (
16"organization_id" = current_setting('request.jwt.claim.org_id', true)::text
17)
18WITH CHECK (
19"organization_id" = current_setting('request.jwt.claim.org_id', true)::text
20);
21 
22Unless otherwise specified, we should apply policies in this way -- "FOR ALL" and
23requiring an organization_id.
24 
25The migration should be in a new file in the folder packages/db/drizzle
26 
27Then, add the migration to the list in packages/db/drizzle/meta/\_journal.json
28