Skill UI

A comprehensive guide for deep PostgreSQL diagnostics, designed for advanced troubleshooting when standard methods fail. Covers using pg_stat_statements for identifying slow queries, analyzing lock contention with pg_locks, detecting connection leaks, debugging RLS policy conflicts, and profiling Edge Function cold starts. Essential for performance regression investigation and escalating issues to support.

A comprehensive diagnostic guide for resolving common errors across the entire Supabase stack, including PostgREST, PostgreSQL, Authentication, and Storage. Use this tool when encountering specific error codes (e.g., PGRST301, 42501) or debugging complex API failures like RLS violations or session expiry. It provides step-by-step instructions for identifying the error layer and applying the correct fix.

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.

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

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.

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.