Skill UI

This skill analyzes provided long-form content to assess its quality, completeness, and adherence to modern SEO best practices. It meticulously audits for E-E-A-T signals, readability, keyword optimization, and overall structure, providing a detailed 'Content Audit Report' with scores and actionable recommendations for improvement.

This skill acts as a content freshness specialist, identifying outdated elements—such as statistics, dates, examples, and industry trends—within existing SEO content. It provides strategic guidelines, update priorities (High/Medium/Low), and actionable refresh plans to improve search engine rankings and maintain topical authority. Use it proactively for established but aging content to combat content decay.

A comprehensive guide detailing the foundational principles of modern SEO. It covers critical areas such as E-E-A-T framework, Core Web Vitals, technical SEO implementation (e.g., sitemaps, structured data), and advanced content quality strategies. This skill helps users build sustainable, high-trust online visibility by focusing on user experience and search engine understanding, not temporary hacks.

A specialized tool for comprehensive content optimization and SEO strategy. It analyzes existing content to calculate keyword density, identify primary and secondary targets, and generate relevant LSI (Latent Semantic Indexing) keywords and semantic variations. Use this skill proactively to improve topical authority and ensure natural, high-ranking content structure.

This specialized skill guides users in formatting and structuring content to maximize its eligibility for featured snippets and rich results across Search Engine Results Pages (SERP). It focuses on best practices for Q&A format, list generation, and comparative tables, ensuring content is highly concise, direct, and easily digestible by search algorithms.

SimPO (Simple Preference Optimization) is a state-of-the-art, reference-free method designed for aligning Large Language Models (LLMs) using human preference data. It is an efficient alternative to DPO and PPO, notably outperforming DPO without requiring a separate reference model. It is ideal for practitioners who need faster, simpler, and more resource-efficient fine-tuning for preference alignment.

This guide provides advanced patterns and best practices for optimizing Apache Spark jobs. It covers critical areas like effective partitioning, memory tuning, minimizing data skew, and optimizing different types of joins (broadcast, bucket). Use this when troubleshooting slow, large-scale data processing workflows or needing to scale Spark pipelines efficiently and reliably.

This skill provides systematic patterns and best practices for transforming slow database queries into high-performance operations. It covers techniques like proper indexing, query plan analysis (e.g., using EXPLAIN), schema design improvements, and resolving common issues like N+1 query problems. Use it to debug performance bottlenecks, reduce database load, and ensure scalable application backends.

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.

Automates SQL query optimization guidance for data analytics workflows, offering best practices, pattern advice, and production-ready code for queries, BI, and visualization tasks whenever the user invokes SQL query optimizer support.

Master advanced techniques for scaling Supabase projects to handle high production load. This skill covers six critical layers: implementing read replicas for analytics, optimizing connectivity using connection pooling (Supavisor), upgrading compute resources, utilizing CDN caching for Storage, deploying Edge Functions regionally, and performing database table partitioning. Ideal for engineers preparing for traffic spikes or optimizing large-scale database architectures.

This expert guides you through building modern, high-performance applications across Apple platforms (iOS, macOS, watchOS, tvOS) using Swift 5.9+. It specializes in SwiftUI state management, Protocol-Oriented Architecture, concurrent programming with async/await and Actors, and implementing best practices for type safety and performance optimization. Ideal for developing complex, robust applications.