How does this skill handle database security?

It follows a mandatory 'RLS First' approach, requiring all tables to have Row Level Security enabled and verified before any implementation occurs.

Does it support both client-side and server-side Supabase clients?

Yes, it provides distinct patterns for Browser, Server, and Admin clients, ensuring that RLS is respected in user-facing environments while allowing administrative tasks where necessary.

What is the mandatory workflow included in this skill?

The skill requires spawning a Domain Expert and a QA Critic to review every implementation plan before any code is written, ensuring maximum reliability.

Is this skill specifically for the PhotoVault project?

While it contains specific logic for the PhotoVault schema, its patterns for RLS, type safety, and client setup are applicable to any Supabase project.

Supabase Database Architect

Name: Supabase Database Architect
Author: nathanielcrowell12-spec

bynathanielcrowell12-spec

0•

Database Management

Implements robust Supabase database patterns, RLS policies, and type-safe TypeScript queries optimized for the PhotoVault ecosystem.

The Supabase Claude Code Skill is a specialized tool designed to manage backend infrastructure with a focus on security and performance. It enforces a strict 'RLS-First' philosophy, ensuring that all data access is governed by granular Row Level Security policies. By integrating TypeScript type safety and project-specific schema knowledge, it assists developers in building complex photography-based applications like PhotoVault. The skill streamlines the creation of photographer-client relationships, storage bucket configurations, and high-performance SQL queries, all while following a mandatory expert-led validation workflow.

Key Features

01Multi-client management for Browser, Server, and Admin environments

02Specialized schema support for galleries, client records, and payment tracking

03End-to-end TypeScript type safety and project-specific query patterns

04Strict Row Level Security (RLS) enforcement and policy optimization

05Advanced debugging tools for SQL migrations and join result validation

060 GitHub stars

Use Cases

01Generating and implementing type-safe database queries for Next.js server components

02Setting up secure, photographer-specific photo galleries with complex access rules

03Debugging and optimizing slow RLS policies to improve application response times

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nathanielcrowell12-spec/photo-vault supabase

For use in Claude.ai and ChatGPT

Download Skill