Skill UI

Automates creating and validating GCP BigQuery views with best-practice guidance, production-ready code snippets, and integrations for Vertex AI, Cloud Run, Firebase, and similar services to keep analytics workloads consistent.

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 workflow for executing advanced, semantic web searches using Exa. This tool moves beyond simple keyword matching, enabling deep context retrieval by understanding the intent behind the query. Key features include RAG context retrieval, content extraction (summaries, highlights, full text), and robust filtering by date range, specific domains, and content categories. Ideal for building knowledge base search features and complex research pipelines.

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.

A comprehensive workflow utilizing the Perplexity Sonar API for advanced, multi-turn research. It systematically decomposes broad topics into focused sub-queries, executes batch queries while maintaining context continuity, deduplicates citations, and synthesizes all findings into a structured, comprehensive research document. Ideal for academic research, market analysis, and generating detailed investment or industry briefs.

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.