supabase

Guides Supabase development, schema migrations, security audits, and debugging workflows.

Updated Sep 1, 2026
One-click install
npx skills add https://github.com/umairshahid622/perfumora --skill supabase-umairshahid622
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase
Source: https://github.com/umairshahid622/perfumora/tree/main/perfumora/.agents/skills/supabase
Command: npx skills add https://github.com/umairshahid622/perfumora --skill supabase-umairshahid622

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve? Working with Supabase involves frequent API changes, subtle security traps (RLS bypasses, SECURITY DEFINER misuse, JWT claim pitfalls), and version-specific CLI behavior that training data often gets wrong. This Skill keeps Supabase work accurate by enforcing changelog verification, current documentation lookups, and structured debugging workflows. ## Core Features & Use Cases - Security Checklist Enforcement: Covers Supabase-specific vulnerabilities including user_metadata in JWT authorization, views bypassing RLS, BOLA/IDOR in policies, SECURITY DEFINER exposure, and Storage upsert permissions. - Schema Change Workflows: Distinguishes declarative schema projects from imperative migrations, with correct use of execute_sql, db pull, and advisors before committing migrations. - Debugging & Troubleshooting: Directs agents to fetch the Monitoring and Debugging docs before diagnosing REST API errors, RLS blocks, Auth issues, Edge Function crashes, or Realtime drops. - Use Case: When a user reports a newly created table is inaccessible via the REST API, the Skill guides checking Data API settings, granting anon/authenticated roles access, and enabling RLS. ## Quick Start Ask the agent to help you create a new Supabase table with proper RLS policies and expose it to the Data API.

Frequently Asked Questions about supabase

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I make schema changes in a Supabase project?▼

Use execute_sql via MCP or supabase db query via CLI to iterate on SQL directly, then commit with supabase db pull once ready. For declarative schema projects, edit files in supabase/schemas/ and generate the migration instead of hand-writing one.

Why is my new Supabase table not accessible via the REST API?▼

Newly created tables may not be automatically exposed through the Data API depending on project settings. You must explicitly grant access to the anon and authenticated roles via GRANT SQL, and enable RLS when granting public access.

Why does my RLS update policy silently affect zero rows?▼

In Postgres RLS, an UPDATE requires a SELECT policy first because the row must be readable before it can be modified. Without a SELECT policy, updates return 0 rows with no error. UPDATE policies also need both USING and WITH CHECK clauses.

Can I use auth.role() in Supabase RLS policies?▼

No, auth.role() is deprecated in favor of the TO clause, such as TO authenticated. The old pattern also breaks silently with anonymous sign-ins, since anonymous users carry the authenticated Postgres role and pass the check.

How do I troubleshoot Supabase MCP server connection issues?▼

First curl https://mcp.supabase.com/mcp and expect a 401 response confirming the server is up. Then verify a valid .mcp.json exists in the project root, and finally complete the OAuth 2.1 authentication flow in your agent and reload the session.