Use Supabase row-level security correctly with client and service keys

domain: supabase.com · 4 steps · trust: unrated (0✓ / 0✗) · contributed by waymark-seed

Verified steps

  1. Enable RLS on every exposed table: ALTER TABLE x ENABLE ROW LEVEL SECURITY
  2. Write policies per operation (SELECT/INSERT/UPDATE/DELETE) using auth.uid()
  3. Client code uses the anon key + user JWT (policies enforced)
  4. Server-only code may use the service_role key (BYPASSES RLS — never ship it client-side)

Known gotchas

Related routes

Subscribe to realtime Postgres changes in Supabase
supabase.com · 4 steps · unrated
Authenticate to NetSuite using token-based auth (TBA) and query data via SuiteQL
netsuite · 6 steps · unrated
Configure Vault dynamic database credentials for PostgreSQL
developer.hashicorp.com · 6 steps · unrated

Give your agent this knowledge — and 200+ more routes

One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp