skills.rest
dudqks0319-cpu
dudqks0319-cpuCOMMUNITY
Explore all skills by this author →
GitHub

supabase

Manages Supabase CLI workflows, migrations, RLS policies, and Edge Functions.

Updated Jan 16, 2026
Search Tags:#postgresql#migrations#backend#cli#supabase#row level security#edge functions
One-click install
npx skills add https://github.com/dudqks0319-cpu/antigravity-skills --skill supabase-dudqks0319-cpu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase
Source: https://github.com/dudqks0319-cpu/antigravity-skills/tree/main/supabase
Command: npx skills add https://github.com/dudqks0319-cpu/antigravity-skills --skill supabase-dudqks0319-cpu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Setting up and maintaining a Supabase backend involves juggling CLI commands, SQL migrations, Row Level Security policies, and Edge Functions, and mistakes like disabling RLS or exposing service keys can compromise your entire database. ## Core Features & Use Cases - Local-First Migration Workflow: Initialize projects, generate migrations from schema diffs, seed data, and push changes to remote environments through the Supabase CLI. - Row Level Security Patterns: Apply ready-made RLS policy templates for public read, owner access, authenticated inserts, and admin roles, plus auto-profile triggers linked to auth.users. - Edge Functions & Storage: Scaffold Deno-based serverless functions with auth context, configure storage buckets with access policies, and deploy through CI/CD pipelines. - Use Case: You are building a new app backend and need a profiles table linked to Supabase Auth. This Skill guides you to create the migration, enable RLS with owner-only policies, add a signup trigger, and deploy everything via GitHub Actions. ## Quick Start Ask the assistant to initialize a Supabase project locally, create a profiles table migration with RLS enabled, and link it to your remote project.

Frequently Asked Questions about supabase

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

FAQPage Schema
How do I create and run Supabase migrations locally?▼

Run supabase migration new <name> to create a migration file, edit the SQL, then apply it with supabase db reset. Alternatively, make changes in local Studio and generate the migration with supabase db diff -f <name>.

How do I set up Row Level Security policies in Supabase?▼

Enable RLS with ALTER TABLE ... ENABLE ROW LEVEL SECURITY, then create policies using auth.uid() for owner checks or auth.role() for authenticated access. RLS defaults to deny, so every table needs explicit policies for each operation.

Can I use Supabase Edge Functions with user authentication?▼

Yes, Edge Functions are Deno-based and can create a Supabase client passing the request Authorization header, then call supabase.auth.getUser() to verify the user. Deploy them with supabase functions deploy after local testing via supabase functions serve.

What is the difference between Supabase transaction and session pooler modes?▼

Transaction mode on port 6543 with pgbouncer=true suits serverless workloads with short queries. Session mode on port 5432 supports long transactions and is required for running migrations.

Why should I never expose the Supabase service role key?▼

The service role key bypasses all Row Level Security policies, granting full database access. It must stay server-side only in environment variables, never in client-side code or committed .env files.

Related Skills

Explore More Software Engineering Skills→
4asaanAI4asaanAI

db-schema

Design and review PostgreSQL and Supabase database schemas with indexes and RLS policies.

Community
Intermediate
encoredevencoredev
26

encore-frontend

Generate a typed TypeScript client for React/Next.js frontends from Encore.ts APIs.

Official
Intermediate
canyouseeuscanyouseeus

infra-ops

Governs Supabase deployments via managed migrations, policies, and secrets.

Community
Advanced
MolcajeteAIMolcajeteAI
2

drizzle-setup

Configure Drizzle ORM for Node.js with PostgreSQL schema and migrations.

Official
Intermediate