Skill UI

This comprehensive guide details the complete workflow for setting up and maintaining a local Supabase development environment. It utilizes Docker and the Supabase CLI to run the entire full-stack service (Postgres, Auth, Storage, etc.) locally. It guides developers through initialization, creating version-controlled migrations using diff, seeding data, and performing clean database resets, ensuring local iteration accurately mirrors production capabilities.

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 skill guides the setup of a robust, multi-environment architecture for Supabase, ensuring complete data isolation between development, staging, and production projects. It covers best practices for managing separate environment-specific secrets, safe database migration promotion (db push), environment-aware client initialization, and implementing safeguards to prevent accidental cross-environment operations in production. Essential for scaling SaaS 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.

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.

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.

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.

Neon is a robust serverless Postgres platform that separates compute and storage, offering advanced features like autoscaling, branching, and instant restore. This guide provides comprehensive resources on setting up, connecting to, and utilizing Neon databases. It is fully compatible with standard Postgres and integrates seamlessly with various languages, ORMs, and developer tools for robust data management.

Ensures database integrity via the data-validation-engine plugin by automatically enforcing data types, ranges, formats, referential integrity, and business rules whenever validation or database integrity requests arise across multi-database environments.

Expert capability for designing and implementing complex semantic search systems using vector databases. Proficient in embedding strategies, index optimization (HNSW, IVF), and advanced retrieval methods like RAG and hybrid search. Masters major platforms including Pinecone, Weaviate, Qdrant, Milvus, and pgvector for building sophisticated recommendation and similarity search applications.

This comprehensive guide outlines best practices for optimizing vector indexes for production systems. It covers critical techniques such as tuning HNSW parameters, implementing quantization strategies, and optimizing memory usage. Use this when you need to balance search latency, recall, and scalability for large-scale vector databases.

Provides a comprehensive, production-ready reference architecture for building complex applications on Vercel using Next.js and TypeScript. It covers modern best practices, including layered directory structure, secure typed environment variable management (Zod), lazy database singleton implementation, API route patterns, and essential Edge Middleware for authentication and routing. Use this guide when starting a new Vercel project or standardizing existing application infrastructure.