Skill UI

This comprehensive guide provides systematic methods to optimize Supabase query and database performance. Techniques cover PostgreSQL indexing (basic, composite, partial), using EXPLAIN ANALYZE for query plan analysis, optimizing client calls (column selection, pagination), and managing infrastructure resources like connection pooling. Use this when facing slow queries, high latency, or preparing a project for production-scale traffic.

A comprehensive guardrail system for enforcing organizational governance across Supabase projects. It provides reusable RLS policy templates, strict naming conventions, CI-checked migration processes, cost alert configurations, and security audit scripts. Use this to ensure development consistency, security, and cost control at scale.

This skill provides comprehensive performance optimization and best practices for PostgreSQL, maintained by Supabase. It guides users on optimizing database performance, covering critical areas such as writing efficient SQL queries, designing robust schemas, implementing proper indexing, managing connection pooling, and enforcing Row-Level Security (RLS).

This skill translates complex business requirements and specification documents into a complete, production-ready Postgres schema for Supabase. It covers the full development lifecycle, including entity extraction, defining robust tables with constraints, generating migration SQL files, implementing Row Level Security (RLS) policies, and producing corresponding TypeScript types. It is the foundational step for building any robust SaaS application on Supabase.

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.

A comprehensive skill to identify, analyze, prioritize, and track technical debt across large codebases. It provides three interconnected tools: a Debt Scanner, a Debt Prioritizer (using cost-of-delay frameworks), and a Debt Dashboard. This system helps engineering teams make data-driven decisions to balance new features with necessary maintenance and refactoring work, ensuring the long-term sustainability of software systems.

Provides a structured reference covering the 100 most critical web vulnerabilities, including definitions, root causes, impacts, and mitigation guidance aligned with OWASP categories to support assessments and remediation planning.

Provides a structured reference of the 100 most critical web application vulnerabilities organized by category, helping security teams identify attack vectors, assess impacts, and follow remediation guidance during audits or penetration tests.

Tracks CPU, memory, disk/network I/O, DB connections, and threads via the resource-usage-tracker plugin to reveal performance bottlenecks, recommend right-sizing, and guide cost-saving actions.

This guide provides comprehensive patterns for optimizing Turborepo build pipelines within monorepos. It covers local and remote caching strategies, including integration with Vercel and self-hosted solutions. Use it when setting up new monorepos, improving CI/CD performance, or debugging complex build dependency issues.

This tool collects comprehensive diagnostic data for TwinMind issues. It gathers crucial information including environment details (OS, Node.js version, memory), API health status, network connectivity, and configuration snapshots. It is essential for generating detailed bug reports or preparing for technical support requests, helping developers quickly pinpoint the root cause of complex problems.

Neon is a robust serverless Postgres platform that separates compute and storage, offering advanced features like autoscaling, branching, and instant restore. This guide provides comprehensive resources on setting up, connecting to, and utilizing Neon databases. It is fully compatible with standard Postgres and integrates seamlessly with various languages, ORMs, and developer tools for robust data management.