backend-development

Installation

SKILL.md

Supabase Local Dev Workflow

Core Philosophy

Schema-driven development — all structural changes go to schema files, never direct SQL
RPC-first architecture — no direct supabase-js table calls; all data access through RPCs
DB functions as first-class citizens — business logic lives in the database

Process

Phase 0: Setup Verification (run once per project)

Before starting any backend work, verify the project's infrastructure is in place.

1. Run the check query — Load assets/check_setup.sql and execute it via execute_sql. It returns a JSON object like:

Related skills

More from tomaspozo/skills

supabase-dev-workflow
Development workflow with Supabase backend. Activate when modifying database schema, creating tables, adding columns, writing RLS policies, building database functions, or implementing business logic in PostgreSQL. Use for any data layer changes including migrations, TypeScript type generation, and RPC development. Enforces RPC-first architecture where all data access uses database functions instead of direct supabase-js table calls. Triggers on - new table, new field, new function, add RLS, business logic, schema change, supabase db, execute_sql.
2

Installs

11

Repository

tomaspozo/skills

First Seen

Feb 8, 2026

Security Audits

Gen Agent Trust HubWarn