Skill UI

This guide provides the complete, production-grade reference architecture for integrating the Speak language learning platform. It covers all necessary components, including the client, API gateway, assessment engine, and progress store. Use this blueprint to ensure a robust, scalable, and reliable implementation for managing large-scale language learning operations.

A comprehensive guide to securely implementing Supabase across diverse modern application stacks. This skill covers critical patterns for Next.js Server Components (SSR), Single Page Applications (SPA), React Native mobile apps, Edge Functions (Serverless), and complex multi-tenant deployments using RLS or schema isolation. It guides developers on correctly managing client types (anon vs. service_role) and handling authentication flows in various environments.

This guide demonstrates the fundamental "Hello World" query using the Supabase JS/Python client. It covers creating a structured table, enabling Row Level Security (RLS), inserting a record, and successfully selecting it back. This is essential for verifying project connectivity, understanding the basic data round-trip pattern, and mastering initial database interactions in a new Supabase environment.

This comprehensive guide provides step-by-step instructions for setting up a complete connection to a Supabase backend. It covers installing the necessary SDKs (for TypeScript and Python) and the CLI, securely configuring environment variables (URL, anon key, service role key), and initializing the client singleton for both client-side and server-side applications. Essential for new project development and authentication integration.

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.

Learn robust and production-ready patterns for interacting with Supabase backend services. This skill covers client initialization, advanced CRUD operations (filtering, upserting), authentication, real-time subscriptions, and RPC calls. Provides best practices for both TypeScript and Python environments, ensuring secure and reliable data handling.

A comprehensive guide for migrating and upgrading the Supabase SDK (JS/TS and Python) and CLI. This tool detects breaking changes, covers major version jumps (e.g., v1 to v2), and provides automated code migration patterns for Auth, Realtime, and Storage APIs. Use this when updating your project to a new Supabase version or when encountering API deprecations.

This skill acts as an expert architect for scaffolding production-ready Rust applications. It generates complete, idiomatic, and robust project structures suitable for binary CLI tools, reusable libraries, and complex multi-crate workspaces (monorepos). It ensures adherence to Rust best practices, including proper module organization, advanced Cargo dependency management, and comprehensive testing setup.

This skill provides a comprehensive collection of quick-start templates for developing applications across diverse tech stacks. Users can quickly scaffold full-stack web apps (Next.js), SaaS products, REST APIs (Express, FastAPI), mobile apps (Flutter, React Native), and specialized tools like CLI utilities. It ensures the initial project setup adheres to modern best practices, saving significant time during the initial development phase.