Skill UI

A comprehensive guide to building production-ready Apache Airflow Directed Acyclic Graphs (DAGs). This skill covers best practices for operators, sensors, testing, deployment, and designing robust data pipelines. Use this when orchestrating complex workflows, managing ETL processes, or ensuring reliable batch job execution in a production environment.

This comprehensive skill simulates an expert business analyst, specializing in transforming complex raw data into actionable, strategic insights. The scope covers modern Business Intelligence (BI) platforms (Tableau, Power BI), AI-powered predictive modeling, designing robust KPI/OKR frameworks, advanced financial modeling, and optimizing business processes. It is designed for users needing to drive data-driven decision-making and create executive-level reports.

This comprehensive reference architecture details a multi-stage pipeline for web scraping and content ingestion using Firecrawl. It seamlessly integrates single-page scraping, site-wide crawling, URL mapping, and structured data extraction. The subsequent processing layer handles cleaning, deduplication, and chunking, making this blueprint ideal for designing robust knowledge bases, RAG systems, and complex AI data pipelines.

SimPy is a powerful, process-based discrete-event simulation framework written in Python. It is designed for modeling complex systems where entities interact with shared resources and time-based events occur, such as manufacturing lines, service queues, network traffic, or logistics networks. Use this skill to analyze resource contention, simulate process optimization, conduct capacity planning, and model dynamic system behaviors.

This skill automatically generates an interactive SQL Notebook designed to validate changes in dbt models or snapshots. It processes changes identified from a GitHub PR or local repository, generating comparison queries that compare 'before' (production) and 'after' (development) data states. It is essential for embedding data observability and quality checks into CI/CD pipelines.

SimPy is a powerful, process-based discrete-event simulation framework written in Python. It is designed for modeling complex systems where entities interact with shared resources and time-based events occur, such as manufacturing lines, service queues, network traffic, or logistics networks. Use this skill to analyze resource contention, simulate process optimization, conduct capacity planning, and model dynamic system behaviors.

A comprehensive guide to designing high-performance schemas in ClickHouse. Learn how to select the optimal MergeTree engine (e.g., ReplacingMergeTree, AggregatingMergeTree), structure the ORDER BY key for maximum query efficiency, and implement effective partitioning strategies for large-scale analytical workloads and ETL processes.