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.

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.

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.

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.

A comprehensive guide to reducing Algolia operational costs. This guide details the pricing structure based on search requests and records, providing advanced techniques such as implementing virtual replicas instead of standard replicas, utilizing multi-query search for request batching, and implementing client-side caching. It also includes strategies for auditing, cleaning up unused indices, and monitoring usage via the Analytics API.

Provides a comprehensive, production-ready reference architecture for building advanced analytics platforms powered by ClickHouse. It details everything from project layout (TypeScript/Node.js structure) and data ingestion pipelines (Kafka, Webhooks) to the optimal 3-layer schema design (Raw, Hourly, Daily) and multi-tenancy patterns, ensuring scalable and efficient OLAP query performance.

A comprehensive guide to high-performance analytical database patterns using ClickHouse. Covers advanced topics including MergeTree engine types (Replacing, Aggregating), efficient query optimization techniques (filtering, window functions), bulk data insertion strategies, and setting up materialized views for real-time analytics. Ideal for data engineers and analysts building OLAP systems.