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

数据库管理

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.

主要功能

Multi-client management for Browser, Server, and Admin environments
Specialized schema support for galleries, client records, and payment tracking
End-to-end TypeScript type safety and project-specific query patterns
Strict Row Level Security (RLS) enforcement and policy optimization
Advanced debugging tools for SQL migrations and join result validation
0 GitHub stars

使用场景

Generating and implementing type-safe database queries for Next.js server components
Setting up secure, photographer-specific photo galleries with complex access rules
Debugging and optimizing slow RLS policies to improve application response times

关于

主要功能

Multi-client management for Browser, Server, and Admin environments
Specialized schema support for galleries, client records, and payment tracking
End-to-end TypeScript type safety and project-specific query patterns
Strict Row Level Security (RLS) enforcement and policy optimization
Advanced debugging tools for SQL migrations and join result validation
0 GitHub stars

使用场景

Generating and implementing type-safe database queries for Next.js server components
Setting up secure, photographer-specific photo galleries with complex access rules
Debugging and optimizing slow RLS policies to improve application response times