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.

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 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.

Provides a complete guide to backing up and restoring Odoo, covering PostgreSQL dumps, filestore archiving, cron automation, and optional cloud uploads so production instances can recover quickly from failures.

Sets up production-ready Odoo with Docker, docker-compose, PostgreSQL, persistent volumes, env config, optional Nginx SSL proxy, plus diagnostics and best practices for launching on VPS or local dev.

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.

Guidelines for structuring Android and Kotlin Multiplatform apps using Clean Architecture—module layout, dependency rules, UseCases, repositories, Room/SQLDelight/Ktor data stacks, and DI via Koin or Hilt.

Automates API injection security tests across endpoints by mapping inputs and crafting payloads for SQL, NoSQL, SSRF, and command injection vectors, helping analysts validate input handling and backend access control before production rollouts.

Identifies and exploits insecure local data storage in Android and iOS apps, covering SharedPreferences, SQLite, backups, and keychain misuse to support OWASP M9 and MASVS storage assessments during mobile penetration tests.