Skill UI

This guide provides comprehensive, actionable methods to audit and significantly reduce Supabase operational costs. It covers advanced database tuning (vacuuming, index cleanup, bloat management), efficient storage lifecycle management, connection pooling strategies, and optimal plan selection. Use this when analyzing high billing reports, identifying resource waste, or implementing robust cost-saving measures in a cloud environment.

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.

Provides Terraform and OpenTofu best-practice guidance for module design, testing selection, CI/CD pipeline setup, security scanning, and architecture decisions in production infrastructure-as-code projects.

This comprehensive guide outlines the core principles for developing immersive Virtual and Augmented Reality (VR/AR) applications. It covers critical aspects such as platform selection (Quest, ARKit, ARCore), mandatory performance metrics (FPS, frame budget), user comfort techniques (motion sickness prevention), and best practices for spatial interaction and world design. Essential reading for engineers building next-generation spatial computing experiences.

A comprehensive guide covering modern web game development principles. It details framework selection (Phaser, Three.js), implementing WebGPU, performance optimization strategies like asset compression and object pooling, adhering to browser constraints, and utilizing PWA capabilities for cross-platform gaming experiences.

Guides writing high-quality YARA-X detection rules for malware hunting, covering naming conventions, string selection, performance tuning, migrations from legacy YARA, and reducing false positives when authoring, reviewing, or debugging signatures.

This skill facilitates the end-to-end deployment of web applications and websites, supporting full-stack architectures including backend APIs, databases, and file storage. It is used when the user wishes to publish a project to a public, live URL, managing the entire deployment lifecycle from template selection to status checking and updates.

This guide provides a comprehensive walkthrough for developing and deploying Apify Actors. Actors are serverless, containerized applications designed for powerful tasks like web scraping, data processing, and complex automation. Learn the mandatory setup, template selection (Python, JS, TS), step-by-step development workflow, and crucial security best practices for building robust, production-ready data pipelines.

This comprehensive guide facilitates the development of a production-ready Minimum Viable Product (MVP) for a SaaS business. It covers the entire lifecycle, including idea validation, modern tech stack selection (Next.js, Supabase, Stripe), architectural design for multi-tenancy, database schema planning, authentication setup, payment integration, and a detailed pre-launch checklist for technical and marketing readiness.

Structured guidance for safely migrating Odoo between major releases, covering pre-upgrade checklists, tool selection (Odoo Upgrade Service vs OpenUpgrade), staging execution, and post-upgrade validation to minimize downtime and risks.

This skill covers implementing complex user interactions within Three.js scenes. It demonstrates techniques like raycasting for precise object selection and click detection, handling mouse and touch inputs, and integrating various camera controls (OrbitControls, FlyControls, FirstPersonControls). Use this when building highly interactive, immersive 3D web applications.

Guides security architects through designing and deploying a continuous CSPM program across AWS, Azure, and GCP, covering tool selection, policy baselines, automation, and SOC integration to monitor misconfigurations and prioritize remediation.