Skill UI

This guide provides comprehensive patterns and best practices for working with ClickHouse, a high-performance OLAP database. It covers advanced topics such as MergeTree engine design, efficient query optimization (filtering, aggregations, window functions), bulk/streaming data ingestion, materialized view creation, and performance monitoring techniques, ensuring optimal performance for large-scale analytical workloads.

Guides ClickHouse database architects through schema designs, query optimization, ingestion strategies, and monitoring techniques tailored for high-performance analytical workloads.

This expert guides users through advanced, data-driven content marketing strategies. It covers AI-powered content creation, comprehensive SEO optimization, omnichannel distribution, social media management, email automation, and performance analytics. Use it when developing comprehensive content plans, maximizing online reach, or optimizing conversion funnels across various digital platforms.

Automates Google Search Console workflows via Rube MCP so you can list verified sites, query search analytics, inspect URLs, and manage sitemaps while keeping an eye on performance metrics in one integrated toolkit.

Automates Google Ads analytics via Rube MCP to list linked accounts, validate GA4 dimensions and metrics, and run tailored performance reports for campaigns while always fetching the latest tool schemas first.

This guide provides advanced techniques for optimizing API integrations, specifically for handling high-volume data operations and rate limits. It covers implementing robust caching strategies for analytics data, managing lead inputs via controlled batching and concurrency, and utilizing prefetching for efficient pagination. It also demonstrates connection pooling using keep-alive mechanisms to maximize throughput and minimize latency.

This tool provides comprehensive usage analytics and reporting for Kling AI video generation. It logs detailed events (submission, completion, errors) into structured JSONL files. Users can track performance metrics, analyze success rates, monitor total resource consumption (credits), and generate cost summaries over defined periods. Ideal for building dashboards, cost auditing, and understanding usage patterns.

A comprehensive guide to implementing expert customer data tracking across the entire stack. Includes best practices for client-side tracking using Analytics.js (React/Next.js), high-performance server-side tracking via Node.js webhooks, user identity resolution, and data governance strategies for Segment CDP.

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.

A comprehensive toolkit designed to track and analyze content performance, engagement metrics, and Return on Investment (ROI) across major social media platforms. By utilizing specialized Apify Actors, this skill extracts deep insights from Instagram, Facebook, YouTube, TikTok, and more, helping users identify high-performing content, monitor growth, and measure marketing campaign effectiveness.

A comprehensive guide to product analytics, covering essential concepts like event tracking (PostHog, Mixpanel), funnels, cohort analysis, retention metrics, North Star Metrics, and OKR setting. Use this skill to define data-driven product strategies, optimize user journeys, and build robust performance dashboards.

Assistant for PostgreSQL developers that highlights native features, advanced data types, performance tuning patterns, and extension usage to optimize queries, indexes, and analytics in PostgreSQL projects.