Enterprise Supabase PostgreSQL Platform with AI-powered open-source BaaS architecture, Context7 integration, and intelligent PostgreSQL orchestration for scalable modern applications
Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.
Um comando direto ignora o prompt de revisão. Verifique a origem antes de executá-lo.
Instruções da origem · Visualização somente leitura
name
moai-baas-supabase-ext
version
4.0.0
created
2025-11-11T00:00:00.000Z
updated
2025-11-13T00:00:00.000Z
status
stable
description
Enterprise Supabase PostgreSQL Platform with AI-powered open-source BaaS architecture, Context7 integration, and intelligent PostgreSQL orchestration for scalable modern applications
Enterprise Supabase PostgreSQL Platform expert with AI-powered open-source BaaS architecture, Context7 integration, and intelligent PostgreSQL orchestration for scalable modern applications.
Revolutionary v4.0.0 capabilities:
🤖 AI-Powered Supabase Architecture using Context7 MCP for latest PostgreSQL documentation
📊 Intelligent Real-time Orchestration with automated subscription optimization
🚀 Advanced PostgreSQL Optimization with AI-driven query tuning and indexing
🔗 Enterprise Row-Level Security with zero-configuration data protection
📈 Predictive Performance Analytics with usage forecasting and optimization
When to Use
Automatic triggers:
Supabase PostgreSQL architecture and real-time feature discussions
Row-level security implementation and optimization
Edge Functions and serverless backend development
Open-source BaaS platform evaluation and integration
Manual invocation:
Designing enterprise Supabase architectures with PostgreSQL optimization
Implementing real-time subscriptions and data synchronization
Planning PostgreSQL to Supabase migrations
Configuring advanced security with Row-Level Security
Quick Reference (Level 1)
Supabase PostgreSQL Platform (November 2025)
Core Features Overview
PostgreSQL 16+: Latest version with extensions and performance improvements
Real-time Subscriptions: WebSocket-based real-time data synchronization
: Fine-grained data access control
Row-Level Security (RLS)
Edge Functions: Deno runtime with 28+ global regions
File Storage: Object storage with CDN integration
Authentication: Multi-provider auth with PostgreSQL integration
Key PostgreSQL Extensions
pgvector: Vector similarity search for AI applications
pg_cron: Scheduled database jobs and maintenance
PostgREST: Automatic REST API generation from PostgreSQL schemas
pg_graphql: GraphQL API generation from PostgreSQL
Latest Features (November 2025)
Database Branching: Development workflows with isolated environments
Improved Auth Section: User bans and authenticated logs
Official Vercel Integration: Seamless deployment and management
-- Comprehensive RLS policies for enterprise applications-- Enable RLS on sensitive tablesALTER TABLE profiles ENABLE ROW LEVEL SECURITY;
ALTER TABLE projects ENABLE ROW LEVEL SECURITY;
ALTER TABLE documents ENABLE ROW LEVEL SECURITY;
-- User can only access their own profileCREATE POLICY "Users can view own profile" ON profiles
FORSELECTUSING (auth.uid() = user_id);
CREATE POLICY "Users can update own profile" ON profiles
FORUPDATEUSING (auth.uid() = user_id);
-- Project access based on team membershipCREATE POLICY "Team members can view team projects" ON projects
FORSELECTUSING (
user_id IN (
SELECT user_id FROM team_members
WHERE team_id = projects.team_id
)
);
CREATE POLICY "Team admins can manage team projects" ON projects
FORALLUSING (
user_id IN (
SELECT user_id FROM team_members
WHERE team_id = projects.team_id AND role ='admin'
)
);
-- Document access with role-based permissionsCREATE POLICY "Document access control" ON documents
FORALLUSING (
CASEWHEN is_public THENtrueWHEN owner_id = auth.uid() THENtrueWHEN user_id IN (
SELECT user_id FROM document_shares
WHERE document_id = documents.id AND permission IN ('read', 'write', 'admin')
) THENtrueELSEfalseEND
);
