supabase

Guides Supabase development tasks including schema migrations, RLS policies, auth, and CLI workflows.

Updated May 13, 2026
One-click install
npx skills add https://github.com/sapatamuku-creator/mastersapatamuku --skill supabase-sapatamuku-creator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase
Source: https://github.com/sapatamuku-creator/mastersapatamuku/tree/main/releases/v2.7/.agents/skills/supabase
Command: npx skills add https://github.com/sapatamuku-creator/mastersapatamuku --skill supabase-sapatamuku-creator

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 provides up-to-date operational guidance so AI agents implement Supabase features correctly and securely. ## Core Features & Use Cases - Security checklist enforcement: Covers RLS policies, views with security_invoker, SECURITY DEFINER functions, app_metadata vs user_metadata, storage access control, and BOLA/IDOR prevention. - Schema change workflows: Distinguishes declarative schemas from imperative migrations, with correct use of execute_sql, supabase db pull, and advisors before committing migrations. - CLI and MCP troubleshooting: Guides command discovery via --help, version-specific gotchas, and step-by-step MCP server connection diagnosis. - Use Case: When adding a new table with row-level security in a Next.js app, the Skill ensures the table is exposed via the Data API, RLS is enabled with proper TO authenticated + ownership predicates, and the migration is generated cleanly. ## Quick Start Ask the agent to help you implement any Supabase task, such as creating an RLS policy for a new table or troubleshooting an auth session issue.

Frequently Asked Questions about supabase

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

FAQPage Schema
How do I create a secure RLS policy in Supabase?▼

Combine TO authenticated with an ownership predicate in USING, such as (select auth.uid()) = user_id. For UPDATE policies, include both USING and WITH CHECK so users cannot reassign rows to other owners.

How do I make schema changes with the Supabase CLI?▼

Use execute_sql via MCP or supabase db query to iterate on changes without writing migration history. When ready, run supabase db advisors, then generate the migration with supabase db pull <name> --local --yes.

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

Depending on your Data API settings, new tables may not be auto-exposed. You must explicitly GRANT access to the anon and authenticated roles, and enable RLS when granting public access.

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

No, auth.role() is deprecated. Use the TO clause on the policy instead, since auth.role() = 'authenticated' silently passes for anonymous sign-ins that carry the authenticated Postgres role.

Why does my Supabase view bypass row-level security?▼

Views bypass RLS by default because they run with the view owner's privileges. On Postgres 15+, create the view WITH (security_invoker = true), or revoke access from anon and authenticated roles on older versions.

How do I fix Supabase MCP server connection issues?▼

First curl https://mcp.supabase.com/mcp and expect a 401, which confirms the server is up. Then verify your .mcp.json points to the correct URL, and complete the OAuth 2.1 browser authentication flow in your agent.