Skill UI

A comprehensive skill for optimizing complex SQL queries, designing robust database schemas, and troubleshooting performance bottlenecks across various dialects (PostgreSQL, MySQL, etc.). Use this when queries are slow, complex set-based logic is needed (CTEs, Window Functions), or when structuring/migrating a database schema. It provides detailed query plan analysis, advanced indexing strategies, and industry best practices.

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

This guide provides advanced, deep-dive debugging techniques for complex issues within the Windsurf integrated development environment. It addresses persistent problems such as context corruption in Cascade, indexing failures, extension conflicts, and deep configuration bugs that standard troubleshooting cannot resolve. Use this when the AI suggestions or IDE behavior is consistently incorrect or unstable.

A comprehensive guide to diagnosing and resolving common errors within the Windsurf Integrated Development Environment (IDE). Covers critical issues such as Cascade panel failures, Supercomplete suggestion glitches, indexing slowdowns, and extension conflicts, helping users maintain an optimal coding workflow.

This comprehensive guide offers detailed steps to optimize the Windsurf IDE experience. It addresses common performance bottlenecks such as slow indexing, high memory consumption, and inefficient AI context building (Cascade). Users will learn best practices for configuring exclusion patterns, managing focused workspaces, and tuning IDE settings for maximum development efficiency.

Search, import, and analyze TikTok, YouTube, and Instagram content via Memories.ai LVMM, indexing videos once for repeatable Q&A, summarization, social research, and searchable knowledge-base building backed by MAG.

This tool audits and validates hreflang tags for international SEO. It checks language and region codes, ensures bidirectional links, and verifies canonical URL alignment. It helps detect common mistakes like missing self-referencing tags or invalid ISO codes, ensuring proper multi-language site indexing and search visibility.

A comprehensive skill for ingesting, analyzing, and manipulating multi-modal video and audio content. Supports real-time desktop capture, live stream monitoring (RTSP), and file uploads (URL/local). Capabilities include advanced indexing (visual, semantic, temporal), precise moment searching, professional timeline editing (subtitles, overlays, dubbing), transcoding, and generating actionable alerts. Ideal for content creators, monitoring systems, and complex media workflows.

A comprehensive set of specialized tools for deep interaction with source codebases. This context-mode is mandatory for advanced tasks such as running code snippets, analyzing files, batch processing repository commands, indexing knowledge, searching content, and fetching web data. It ensures that interactions are context-aware and highly efficient, moving beyond basic file listing or general chat prompts.

Guidance for implementing Cloud Firestore in Flutter: selecting the database, configuring offline persistence, designing schemas, querying with filters and pagination, writing batched transactions, indexing, optimizing for scale, and avoiding write hotspots.