Skill UI

This guide identifies and provides solutions for common anti-patterns and mistakes when working with Snowflake. It covers best practices in SQL writing, warehouse resource management, data loading strategies (e.g., using MERGE), and access control setup. It is essential for auditing existing deployments, onboarding new users, or performing code reviews to ensure cost efficiency and data integrity.

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.

This guide provides a comprehensive method for setting up Snowflake observability. It teaches how to leverage built-in ACCOUNT_USAGE views to monitor critical metrics such as query performance (latency, error rates), credit consumption, and storage growth. Furthermore, it demonstrates how to implement automated alerts for operational issues (e.g., high failure rates, stuck warehouses) and export metrics to external monitoring systems like Grafana or Prometheus.

This guide provides comprehensive instructions on managing performance and concurrency within Snowflake. It covers key concepts like warehouse sizing, multi-cluster configuration, and detecting query queuing issues. Users learn how to right-size resources and implement application-level rate limiting to prevent throttling and optimize data warehouse throughput for complex analytics workloads.

This skill performs a structured Systematic Literature Review (SLR) by analyzing multiple academic papers on a given topic. It searches academic databases (like arXiv), extracts structured metadata (research questions, methodologies, key findings, limitations) from the entire set of papers, and synthesizes overarching themes and research trends. It is ideal for creating comprehensive literature surveys, annotated bibliographies, and cross-paper comparisons, outputting reports in professional citation formats like APA, IEEE, or BibTeX.

A high-performance library built on TileDB for scalable ingestion, efficient storage, and retrieval of genomic variant data (VCF/BCF). It supports incremental sample addition, parallel querying across vast genomic regions, and robust data export for population genomics and cohort studies.

This tool performs a rigorous Level 2 semantic epistemic review of Agent-Native Research Artifacts (ARAs). It assesses six critical dimensions—including evidence relevance, falsifiability, and methodological rigor—to determine the content's intellectual soundness. It is used after initial structural validation to provide objective, constructive criticism, scoring the work from Strong Accept to Reject.

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.

Generates a complete, self-contained HTML dashboard for analytics, admin, or control panel views. It structures the layout with a fixed sidebar, top navigation, KPI cards, and detailed charts (using inline SVG). Ideal when the brief requires visualizing key metrics, performance over time, or operational statistics.

This utility displays the precise, real-time token usage and estimated cost savings for the current session. It reads directly from the internal session log, ensuring objective and accurate data without requiring AI computation. Triggered by /caveman-stats, it provides immediate performance metrics to monitor API costs and usage patterns.

A comprehensive skill for creating, editing, and analyzing complex spreadsheets (.xlsx, .csv, etc.). This skill excels in financial modeling, ensuring all calculations are managed via dynamic Excel formulas rather than hardcoded values. It supports data analysis using pandas, rigorous formatting standards, and complex formula integrity checks, making it ideal for financial reporting and data visualization.

This guide provides an expert framework for implementing robust analytics tracking, ensuring all data collected is actionable. It covers core principles, event naming conventions, defining key user actions (e.g., signups, purchases), and practical setup using industry tools like GA4 and Google Tag Manager (GTM). Use this when auditing existing tracking, defining conversion funnels, or measuring marketing campaign performance.