Skill UI

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.

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.

Guides using SQLMap to automate SQL injection discovery, enumerate databases/tables/columns, dump data, and collect hashes across MySQL/PostgreSQL/MSSQL/Oracle during authorized penetration tests.

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 provisions instant, temporary PostgreSQL databases via Neon. It eliminates the need for user sign-up, logins, or credit cards, making it ideal for rapid local development, API prototyping, and isolated testing environments. Supports multiple methods including REST API calls, CLI commands, and SDK integration.

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.

A comprehensive guide to implementing Clean Architecture patterns for both Android and Kotlin Multiplatform (KMP) projects. It covers robust module structuring, dependency inversion rules, defining UseCases and Repositories, and designing the data layer using technologies like Room, SQLDelight, and Ktor. Learn how to separate concerns, maintain platform independence, and manage complex data flows.