Skill UI

A comprehensive template for developing modern, full-stack applications. This guide covers architecture overview, file structure, and best-practice code patterns for advanced technology stacks including Next.js, FastAPI, Supabase, and structured AI integration using Claude API. It serves as a robust blueprint for professional development teams.

Learn how to implement robust authentication and authorization flows using Clerk in Next.js. This guide covers configuring `clerkMiddleware` for route protection, protecting API endpoints with permission checks, customizing session claims (JWT), and generating secure tokens for external services like Supabase. Essential for building secure, enterprise-grade SaaS applications.

A comprehensive guide for migrating user authentication systems from major providers like Auth0, Firebase, Supabase, or NextAuth to Clerk. It covers essential steps including user data export, bulk import, updating database references, and replacing client and server-side authentication code for a smooth, phased transition.

This guide provides expert patterns for implementing secure, full-stack authentication in Next.js using Supabase. It covers essential architectural components, including setting up separate browser and server clients, utilizing middleware for route protection and session refreshing, handling OAuth callbacks, and implementing auth operations safely via Server Actions and Server Components. Essential knowledge for building secure, modern web applications.

A comprehensive guide maintained by Supabase for optimizing Postgres performance. It provides critical rules and best practices across query performance, schema design, connection management, and security (including RLS). Use this skill when writing, reviewing, or optimizing complex SQL queries, database schemas, or configurations to ensure optimal database health and performance.

A comprehensive guide for deep PostgreSQL diagnostics, designed for advanced troubleshooting when standard methods fail. Covers using pg_stat_statements for identifying slow queries, analyzing lock contention with pg_locks, detecting connection leaks, debugging RLS policy conflicts, and profiling Edge Function cold starts. Essential for performance regression investigation and escalating issues to support.

A comprehensive guide to securely implementing Supabase across diverse modern application stacks. This skill covers critical patterns for Next.js Server Components (SSR), Single Page Applications (SPA), React Native mobile apps, Edge Functions (Serverless), and complex multi-tenant deployments using RLS or schema isolation. It guides developers on correctly managing client types (anon vs. service_role) and handling authentication flows in various environments.

This module provides the essential three pillars for building robust full-stack applications on Supabase. It implements comprehensive user authentication (including OAuth, email/password, and session management), secure file storage (uploading, downloading, and managing signed URLs), and real-time data subscriptions (listening to Postgres changes, presence, and broadcasts). It is crucial for developing modern, live-updating, and highly secure web services.

Automates Supabase operations through the Rube MCP toolkit, letting you query tables, inspect schemas, execute SQL, manage projects/orgs, and monitor storage or edge functions with workflow-aware guidance.

Automate the entire Supabase development lifecycle within CI/CD pipelines using GitHub Actions. This tool links projects, validates database migrations, deploys Edge Functions, generates TypeScript types, and runs comprehensive tests against local Supabase instances. Essential for maintaining robust code quality and ensuring schema consistency before deployment.

A comprehensive diagnostic guide for resolving common errors across the entire Supabase stack, including PostgREST, PostgreSQL, Authentication, and Storage. Use this tool when encountering specific error codes (e.g., PGRST301, 42501) or debugging complex API failures like RLS violations or session expiry. It provides step-by-step instructions for identifying the error layer and applying the correct fix.

This guide provides comprehensive, actionable methods to audit and significantly reduce Supabase operational costs. It covers advanced database tuning (vacuuming, index cleanup, bloat management), efficient storage lifecycle management, connection pooling strategies, and optimal plan selection. Use this when analyzing high billing reports, identifying resource waste, or implementing robust cost-saving measures in a cloud environment.