Skill UI

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.

A comprehensive guide detailing the most common and critical mistakes when developing with Supabase. Covers severe security issues (like exposing service role keys or missing RLS), data integrity failures, and performance bottlenecks (connection pooling, N+1 queries). Essential for code review, onboarding new developers, or auditing existing Supabase projects to ensure secure and robust applications.

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 guide to modern utility-first CSS using Tailwind CSS v4 principles. Covers the shift to CSS-first configuration, utilizing CSS variables for design tokens, implementing advanced container queries, and mastering responsive, dark mode, and complex layout patterns (Grid/Flex). Essential for building modern, component-driven UIs efficiently.

Tracks and optimizes application response times using the response-time-tracker plugin, covering API endpoints, database queries, external calls, frontend rendering, and background jobs to highlight bottlenecks or SLO breaches.

Automate Benchling lab data workflows via the Python SDK or REST API: manage registry entities (DNA, proteins), inventory, ELN entries, workflows, and Data Warehouse queries for syncing and analytics.

Guides building and scaling Convex backends with TypeScript schemas, queries, mutations, real-time subscriptions, auth, file storage, scheduling, and deployment across React, Next.js, Angular, Vue, Svelte, and RN.

Parallel Web Research skill orchestrates Parallel Chat and Extract APIs to search the internet, perform deep intelligence work, and craft cited summaries, with model controls, JSON outputs, and citation verification for market, news, technical, and general queries.

This skill simulates a senior engineer's final, deep audit of an entire codebase before committing or pushing to a remote repository. It systematically checks for junk files, dead code, security vulnerabilities (secrets, injection flaws), and performance bottlenecks (N+1 queries). Use this pre-flight check before any major release or public deployment to ensure maximum code quality and production readiness.

A specialized review tool for identifying critical performance bottlenecks within Django applications. It focuses on validating issues such as N+1 queries, unbounded querysets, missing database indexes, and write loops. Use this when you suspect database slowdowns or memory exhaustion due to inefficient ORM usage, ensuring findings are provable and actionable.

Diagnose and fix Odoo performance bottlenecks by tuning PostgreSQL queries, adjusting worker/memory limits, and applying profiling insights to achieve faster page loads and stable production behavior.

A comprehensive guide and methodology for identifying, measuring, and fixing performance bottlenecks across the entire stack. This skill covers optimizing database queries (e.g., N+1 problems, missing indexes), improving API efficiency (caching, parallel processing), and enhancing frontend performance (memoization, code splitting, image optimization). It emphasizes the critical 'Measure First' principle to ensure all optimizations are data-driven and effective.