Skill UI

Automates common CTE query builder tasks for data analytics, offering best-practice guidance, production-ready SQL snippets, and validation against standard requirements when you need help with BI, visualization, or statistical analysis.

A comprehensive guide detailing optimization techniques for Databricks environments. It covers optimal cluster sizing for various workloads (ETL, ML, Streaming), advanced Spark configurations (AQE, memory management), and deep data optimization strategies for Delta Lake, including Z-Ordering and Liquid Clustering. It also provides methods for query plan analysis and join optimization.

A comprehensive tool for querying and analyzing deep blockchain data across multiple EVM-compatible networks, including Ethereum, Polygon, Arbitrum, and Optimism. It supports tracking transactions by hash, checking address balances, inspecting blocks, and resolving ERC-20 token holdings. Ideal for crypto analysts, developers, and researchers requiring programmatic, detailed insights into on-chain financial activity and protocol interactions.

Automates Google BigQuery workflows via Rube MCP and Metabase, letting you run native SQL/MBQL queries, fetch metadata, and explore schemas before querying.

This skill provides comprehensive guidelines for monitoring Granola usage, tracking team meeting patterns, and building detailed analytics dashboards. It guides users in defining critical metrics (e.g., adoption rate, efficiency score) and establishing robust data pipelines. Users can stream meeting metadata from Granola to data warehouses like BigQuery, enabling deep, customizable reporting and automated weekly insights via services like Zapier and Slack.

Automated assistant for metric calculator work in data analytics, offering guidance, best practices, SQL/query support, visualization tips, and BI-ready validation whenever the user requests metric calculator help.

This comprehensive guide outlines advanced strategies for optimizing PostHog in production environments. Key techniques covered include implementing local feature flag evaluation to eliminate network latency, optimizing event batching for network efficiency, utilizing strategic event sampling, and writing efficient HogQL queries. Master these methods to dramatically improve data collection reliability and query speed.

This skill guides you through integrating PostHog's Customer Data Platform (CDP) features. It covers setting up webhooks to trigger real-time actions (e.g., syncing to CRM, sending notifications) when specific user events occur. Furthermore, it demonstrates how to query event data using the Events API and perform complex funnel analysis using HogQL, allowing for deep, custom insights into user behavior.

An advanced workflow orchestrator designed to perform multi-phase, deep-dive schema optimization on large datasets (e.g., BigQuery exports). It systematically analyzes schema structure, identifies unused or redundant fields, assesses potential impact, and generates a comprehensive, actionable report with recommended optimization strategies and estimated savings.

Automates SQL query optimization guidance for data analytics workflows, offering best practices, pattern advice, and production-ready code for queries, BI, and visualization tasks whenever the user invokes SQL query optimizer support.

Enables efficient querying of the bioRxiv preprint server with keywords, authors, dates, and categories, returning structured JSON metadata and optional PDF downloads for literature reviews or tracking research trends.

Provides programmatic access to the CZ CELLxGENE Census (61M+ cells) for querying standardized single-cell expression, metadata, embeddings, and stats across tissues and diseases, supporting scanpy and ML workflows.