Skill UI

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.

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.

This comprehensive skill guides the full lifecycle management of Supabase projects in a production environment. It covers essential DevOps practices, including running database migrations, deploying Edge Functions, managing secrets, implementing zero-downtime blue/green rollouts, and executing robust rollback procedures and post-deployment health checks. Ideal for ensuring stable and reliable production deployments.

A comprehensive guide for structured incident response when a Supabase-backed application fails. This runbook guides users through triaging issues, verifying platform status, inspecting connection pools, debugging stuck queries using pg_stat_activity, and analyzing Edge Function logs. Essential for root cause analysis and escalating issues to support.

Master advanced techniques for scaling Supabase projects to handle high production load. This skill covers six critical layers: implementing read replicas for analytics, optimizing connectivity using connection pooling (Supavisor), upgrading compute resources, utilizing CDN caching for Storage, deploying Edge Functions regionally, and performing database table partitioning. Ideal for engineers preparing for traffic spikes or optimizing large-scale database architectures.

A comprehensive guide for managing resource limits and quotas across all Supabase services (API, Auth, Storage, Realtime, Edge Functions). Learn how to understand tier-specific limits, configure connection pooling using Supavisor (Transaction/Session mode), and implement robust retry logic with exponential backoff to gracefully handle 429 rate limiting errors, ensuring high application reliability.

A comprehensive guide to building event-driven architectures using Supabase. It covers four core event mechanisms: Database Webhooks (pg_net), Postgres LISTEN/NOTIFY, Edge Function HTTP calls, and Realtime subscriptions. Includes production-ready SQL triggers, signature verification logic, and best practices for handling data changes (INSERT, UPDATE, DELETE) as external HTTP events.

This skill helps developers adhere to Test-Driven Development (TDD) principles by generating comprehensive, failing unit and integration tests. It is specifically designed for the 'Red' phase, ensuring that expected behaviors, edge cases (null, boundary values), and error handling are rigorously defined before any implementation code is written. It forces the definition of the 'what' before the 'how'.

This guide provides production-ready patterns for implementing the TwinMind AI memory and meeting intelligence REST API. It covers best practices for authentication, storing contextual memories, searching knowledge bases, and processing meeting transcripts to extract actionable insights. Use this when building robust, scalable AI-powered applications or standardizing team coding practices.

This skill acts as an expert test automation specialist, capable of analyzing source code across multiple languages (Python, JavaScript, TypeScript, etc.). It generates comprehensive, maintainable unit test suites using best practices, maximizing code coverage, and specifically targeting edge cases and exception handling. Use it to ensure high code quality and structural consistency.