Skill UI

This bundle collects comprehensive diagnostic evidence from the Juicebox platform. It gathers API connectivity status, dataset health reports, analysis quota usage, and rate limit information into a single archive. Use it to systematically troubleshoot complex issues such as failed dataset uploads, stalled AI analysis runs, API authentication failures, or quota exhaustion.

This guide provides advanced strategies for optimizing interactions with the Juicebox AI API. It covers crucial best practices such as implementing caching mechanisms (with defined TTLs), executing batch operations for efficiency, managing rate limits, and optimizing data chunking for large datasets. Following these steps can significantly reduce end-to-end analysis time and ensure responsive, scalable data workflows.

This skill provides advanced techniques for optimizing PostHog Cloud usage and reducing associated costs. It covers auditing event volume, implementing intelligent event sampling (e.g., sampling pageviews or autocapture events), filtering bot traffic, and tuning session recording rates. The goal is to maintain critical analytical value while staying within budget limits.

This skill acts as an expert risk manager, providing comprehensive guidance on monitoring portfolio risk, calculating R-multiples, and optimizing position limits. It covers advanced quantitative finance topics such as Value at Risk (VaR), correlation analysis, and stress testing using Monte Carlo simulations. Use it for systematic risk assessment, developing hedging strategies (options/futures), and implementing rigorous risk controls in trading workflows.

This tool parses API Gateway access logs from various providers (AWS, Kong, Nginx). It performs statistical analysis using pandas to detect critical security threats such as Broken Object Level Authorization (BOLA/IDOR), credential stuffing, rate limit bypass attempts, and injection vulnerabilities. Ideal for SOC analysts or security engineers investigating API abuse and building advanced threat detection rules.

This skill queries documented public database APIs with explicit endpoints, filters, and pagination. It is used when scientific, regulatory, or financial facts must be retrieved reproducibly from named sources. The skill catalogs 80 databases across domains like biology, finance, and chemistry. It ensures auditable results with provenance, handling identifier conversions and rate limits safely.

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 guide provides comprehensive solutions for diagnosing and resolving common errors and exceptions encountered while using the Hex data platform. It covers critical areas such as API authentication failures (401, 403), resource not found issues (404), rate limiting, and various run status errors (ERRORED, KILLED). This is essential for debugging failed data requests, optimizing integration workflows, and ensuring stable data analytics pipelines.

This tool collects a comprehensive diagnostic archive for the Hex platform. It gathers crucial evidence, including API connectivity status, project inventory, recent run histories, data connection health, and current rate limit information. Use this bundle when encountering persistent bugs, preparing detailed support tickets, or troubleshooting complex data flow issues.

Provides a comprehensive checklist for deploying Hex data analytics integrations into production. It covers critical operational best practices, including API key management, rate limit handling, error resilience (circuit breakers, exponential backoff), and robust monitoring strategies. This guide ensures that data pipelines are deployed reliably, minimizing downtime and guaranteeing consistent, high-quality data reporting for go-live scenarios.

This guide provides robust solutions for handling Hex API rate limits, implementing backoff, and ensuring idempotent API calls. It includes a rate limiter class and a retry mechanism with exponential backoff. Use this when building reliable data pipelines, running large-scale batch analytics, or integrating Hex into CI/CD environments where API call throttling is expected.

A comprehensive guide for migrating data to, from, and between Notion workspaces. This skill covers complex data pipelines, including rate-limited bulk imports (CSV/JSON), full database exports with pagination, cross-database syncing, and data transformation patterns for integrating content from sources like Confluence and Google Docs. Essential for building robust Notion ETL workflows.