Skill UI

Implements a robust, enterprise-grade Role-Based Access Control (RBAC) system for Supabase. This skill teaches how to store custom roles (e.g., admin, editor, viewer) in JWT claims (`app_metadata`), enforce granular permissions, and scope access at the row level using PostgreSQL RLS policies. It covers organization scoping, role hierarchy management, and API key protection.

This comprehensive deep dive guides you through the entire database migration lifecycle using the Supabase CLI. Learn best practices for executing zero-downtime schema changes, safely backfilling data in production, managing schema versioning across environments, and implementing robust rollback strategies. Covers advanced PostgreSQL concepts like concurrent indexing and multi-phase column renaming.

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.

Supabase-curated Postgres best practices that prioritize query, schema, connection, security, and monitoring rules to guide writing, reviewing, or tuning SQL plus database configuration for better performance.

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.

This comprehensive workflow guides users through a multi-phase process for assessing web application security. It is designed to systematically test for common vulnerabilities listed in the OWASP Top 10, including SQL injection, XSS, broken authentication, and access control issues. Ideal for professional penetration testing, security auditing, and bug bounty hunting.

This expert guides the optimization and design of the entire revenue engine, connecting marketing, sales, and customer success. It provides frameworks for lead lifecycle management, defining MQL-to-SQL handoffs, implementing comprehensive lead scoring models (fit and engagement), and structuring lead routing rules. Use this when optimizing cross-functional processes and systems.

A powerful skill for conducting structured, systematic code reviews for PRs and MRs. It goes beyond basic style checks, performing deep analysis such as blast radius tracing, comprehensive security scanning (SQLi, XSS, secrets), detecting breaking changes in APIs/DB schemas, and calculating test coverage delta. Ideal for reviewing large, complex, or security-sensitive code changes before merging.

This skill provides comprehensive read-only access to explore, query, and analyze datasets hosted on Hugging Face. It utilizes the Dataset Viewer API to list splits, preview rows, perform text searches, filter records, and retrieve crucial metadata and Parquet links. Furthermore, it supports advanced data extraction by enabling complex SQL querying (via parquetlens) directly against dataset shards, allowing export into CSV, JSON, or Parquet formats.

A comprehensive skill for managing the entire lifecycle of datasets on the Hugging Face Hub. It allows users to initialize, configure, and stream updates for datasets of various types (Chat, Text Classification, Tabular). Crucially, it extends data handling capabilities by enabling powerful SQL-based querying and transformation directly on Hub datasets using the DuckDB engine, facilitating advanced data exploration and pipeline creation.

This skill generates a complete, opinionated, modern full-stack Rails application boilerplate. It sets up a robust tech stack including Rails 8, PostgreSQL, React, Inertia.js, Vite, Tailwind CSS, Sidekiq, and Redis. Designed for developers who need a starting point that adheres to best practices for database structure (UUIDs, JSONB), background job processing, comprehensive testing, and modern frontend development (TSX). Ideal for bootstrapping complex, production-grade web services.