What problem does it solves?
This Skill automates the complex and error-prone process of implementing data services, designing optimized database schemas, and configuring high-performance Row Level Security (RLS) policies in Supabase/PostgreSQL. It ensures security, performance, and architectural best practices, eliminating hours of manual configuration and debugging.
Core Features & Use Cases
- Optimized Schema Design: Creates database schemas with proper multi-tenancy, indexes (critical for RLS), constraints, and auto-update triggers.
- Secure RLS Policy Implementation: Configures Row Level Security policies following best practices to prevent circular dependencies, optimize performance, and ensure multi-tenant data isolation.
- Pure Data Services: Implements CRUD (Create, Read, Update, Delete) data services with
snake_case ↔ camelCase transformations and robust error handling, ensuring no business logic leaks into the data layer.
- TypeScript Type Generation: Automates the generation and validation of TypeScript types directly from your Supabase schema for end-to-end type safety.
- Use Case: After use cases are defined, this Skill designs the
tasks table schema, implements RLS policies to ensure users only access their organization's tasks, creates a TaskService for CRUD operations, and generates TypeScript types, all while making existing service tests pass.
Quick Start
1. Start with mandatory Context7 research:
mcp__context7__get_library_docs({
context7CompatibleLibraryID: "/supabase/supabase",
topic: "RLS row level security policies performance joins security definer circular",
tokens: 3000
})
2. Then, proceed through the 6-phase workflow for schema, RLS, and services.
