skills.rest
BrewHubPHL
BrewHubPHLCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

supabase-specialist

Consolidate Postgres and Supabase security patterns for multi-tenant apps.

Updated Jun 14, 2026
Search Tags:#security#serverless#migrations#rls#supabase#patterns#postgres
One-click install
npx skills add https://github.com/BrewHubPHL/supabase-specialist --skill supabase-specialist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-specialist
Source: https://github.com/BrewHubPHL/supabase-specialist/tree/main
Command: npx skills add https://github.com/BrewHubPHL/supabase-specialist --skill supabase-specialist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

The Supabase Specialist centralizes production Postgres and Supabase patterns for AI agents, delivering governance, security, and scalable data-access design.

Core Features & Use Cases

  • RLS policies, dual-client authentication, and RPC patterns for secure multi-tenant data access.
  • Migrations, pooling, and production best practices for Next.js and serverless backends.
  • On-demand loading of patterns and references to keep context lean while enabling robust architecture.

Quick Start

Install the Supabase Specialist in your project and read SKILL.md to guide routing.

Frequently Asked Questions about supabase-specialist

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I implement row level security for multi-tenant apps in Postgres?▼

Row level security for multi-tenant apps is enforced through documented RLS policies and dual-client authentication patterns. This ensures isolated data access by applying governance rules directly within Postgres.

What is the best way to manage Postgres migrations in a Next.js serverless backend?▼

Postgres migrations in serverless backends are best managed using transactional migration patterns. This ensures schema changes are applied safely and consistently without disrupting active pool connections.

Does this Supabase skill work with Next.js serverless connection pooling?▼

Yes, it works with Next.js serverless pooling by providing pool-aware connection patterns. These production best practices prevent connection exhaustion and manage database resources efficiently in serverless environments.

How do I set up dual-client authentication for Supabase RPC patterns?▼

Dual-client authentication for Supabase RPC patterns is set up by applying a centralized skill contract. This design separates client and server permissions to enforce robust multi-tenant data access controls.

When do I need on-demand loading for Postgres security patterns?▼

On-demand loading for Postgres security patterns is needed when keeping context lean in production stacks. It allows AI agents to load RLS policies and references dynamically without consuming excessive context window space.

Related Skills

Explore More Software Engineering Skills→
ScientiaCapitalScientiaCapital
28

supabase-sql

Clean and format Supabase SQL migrations with idempotent patterns and RLS policies.

Community
Intermediate
AndreaCadonnaAndreaCadonna

postgresql-data-layer

Design PostgreSQL schemas and migrations for Node.js/TypeScript applications.

Community
Advanced
hopeoverturehopeoverture
6

supabase-auth-ssr-setup

Configure Supabase authentication for Next.js App Router with SSR middleware and route guards.

Community
Advanced
ri-ruri-ru

supabase-postgres-best-practices

Provide Postgres performance optimization and schema design guidelines for developers.

Community
Advanced