Skill UI

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.

This technique guides users on how to construct highly specific search queries for academic papers. Instead of relying solely on broad topic keywords, users should prioritize combining concrete numerical identifiers—such as exact sample sizes, population percentages, concentration levels, or specific year ranges—with methodological terms and discipline keywords. Using these numerical anchors significantly increases the uniqueness and precision of the search results, helping to pinpoint the exact study required.

This skill provides comprehensive, real-time research lookup by intelligently routing queries to the optimal backend. It utilizes fast web search for general market data, advanced APIs for deep synthesis research, and dedicated services for academic papers and DOI searches. Use it for literature verification, background context gathering, and technical documentation retrieval.

This guide details how to configure and manage resource constraints in ClickHouse, addressing server-side limits, user quotas, and connection management. Use it when encountering "too many simultaneous queries," optimizing resource usage, or implementing robust rate limiting strategies in applications connecting to ClickHouse. Covers SQL quota setup and client-side pooling techniques.

This comprehensive guide teaches users how to set up a ClickHouse database environment. It covers creating a MergeTree table, inserting structured event data using TypeScript, and executing essential analytical queries (e.g., counting, grouping, unique user metrics). Ideal for beginners learning OLAP databases, testing connections, or mastering core data warehousing concepts.

This comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.

This expert acts as a dedicated data analysis partner for Product Managers. It helps users explore data, write complex queries (e.g., SQL, BigQuery), analyze key metrics, and create structured dashboards. Use this tool when you need to derive actionable insights from complex datasets, compare user cohorts, or understand product performance trends to inform critical business decisions.

This skill allows for the generation and execution of complex, optimized SQL queries to derive deep business insights. It supports sophisticated data workflows, including multi-table joins, multi-dimensional analysis (e.g., trend analysis, attribution modeling, comparative analysis), and subsequent recommendations for appropriate data visualizations (e.g., line charts, waterfall charts). It goes beyond simple SELECT statements by planning the query structure, handling schema relationships, and ensuring adherence to best practices.

A comprehensive guide for deep debugging complex Snowflake issues. This guide covers advanced techniques including detailed query profiling (spill analysis), diagnosing lock contention and transaction conflicts, analyzing metadata operations, and optimizing partition usage. Use it when standard troubleshooting fails to address slow queries or warehouse performance bottlenecks.

This guide provides a comprehensive methodology for load testing and capacity planning within Snowflake data warehouses. It covers optimizing query performance by adjusting warehouse sizes (Scale UP), simulating high concurrency using multi-threading (Scale OUT), and configuring advanced scaling policies (Standard, Economy, Maximized). Users can benchmark critical queries using SQL and simulate real-world user traffic using Python, ensuring robust and cost-efficient production environments.

Generate data analysis reports by exploring database tables, running multidimensional SQL queries, performing deep attribution analysis, and outputting dynamic HTML visual reports with ECharts for business, trend, and KPI scenarios.

Provides expert guidance for connecting to a local Power BI Desktop tabular model using PowerShell's Tabular Object Model (TOM) and ADOMD.NET. This skill enables model enumeration, executing complex DAX queries, modifying metadata (fields, measures, parameters), and managing the report canvas state via the Desktop Bridge. It is critical for direct model interaction when external CLIs are unavailable.