Does it include both JavaScript and SQL examples?

Yes, the skill provides a quick reference comparing JavaScript client methods with their raw SQL equivalents for most major operations.

Can this skill help with Supabase RLS policies?

Yes, it includes comprehensive patterns for enabling Row Level Security and creating policies for authenticated users, specific roles, and owner-based access.

Can I use this for complex relational joins?

Yes, it covers one-to-many, many-to-one, inner joins, and many-to-many relationships through junction tables using the Supabase select syntax.

Does it support TypeScript integration?

Absolutely. The skill provides guidance on generating and using database types to ensure type-safe operations when using the Supabase client.

Supabase Database

Name: Supabase Database
Author: adaptationio

byadaptationio

データベース管理

Streamlines Supabase database management including complex queries, CRUD actions, and Row Level Security implementation.

概要

This skill empowers Claude to efficiently handle all aspects of Supabase database development, from basic data retrieval and manipulation to advanced PostgreSQL functions and Row Level Security (RLS). It provides standardized patterns for both JavaScript/TypeScript queries and raw SQL, ensuring secure and performant data access layers. Whether you are setting up initial table structures, optimizing complex joins, or managing auth-specific access controls, this skill offers a comprehensive reference for modern backend development within the Supabase ecosystem.

主な機能

Support for Remote Procedure Calls (RPC) and custom PostgreSQL functions
Comprehensive Row Level Security (RLS) policy templates and helpers
0 GitHub stars
Complex relational query handling for one-to-many and many-to-many joins
Full CRUD operation support using Supabase JS client and SQL syntax
Advanced filtering including pattern matching, range operations, and null checks

ユースケース

Building secure data access layers with granular user-based permissions
Implementing complex relational queries and pagination for dashboards
Generating and integrating TypeScript types for end-to-end database safety

概要

主な機能

Support for Remote Procedure Calls (RPC) and custom PostgreSQL functions
Comprehensive Row Level Security (RLS) policy templates and helpers
0 GitHub stars
Complex relational query handling for one-to-many and many-to-many joins
Full CRUD operation support using Supabase JS client and SQL syntax
Advanced filtering including pattern matching, range operations, and null checks

ユースケース

Building secure data access layers with granular user-based permissions
Implementing complex relational queries and pagination for dashboards
Generating and integrating TypeScript types for end-to-end database safety