Skill UI

A comprehensive guide to designing high-performance schemas in ClickHouse. Learn how to select the optimal MergeTree engine (e.g., ReplacingMergeTree, AggregatingMergeTree), structure the ORDER BY key for maximum query efficiency, and implement effective partitioning strategies for large-scale analytical workloads and ETL processes.

This comprehensive guide details best practices for securing a ClickHouse deployment. It covers essential security measures including role-based access control (RBAC) for granular user permissions, implementing row-level security for multi-tenancy, configuring network IP restrictions, enabling TLS encryption, and setting up detailed audit logging. Use this when hardening a production ClickHouse instance or enforcing strict data governance.

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.

Comprehensive toolkit for managing sensitive Flexport supply chain data, including shipment records, customs declarations, and financial invoices. This skill enforces strict data governance, handling PII redaction, ensuring GDPR/CCPA compliance, managing mandated data retention periods (e.g., 5-7 years), and blocking restricted export items (ITAR) to maintain global trade compliance standards.

This skill guides the setup of CI/CD pipelines for Hex data analytics projects using GitHub Actions. It enables running automated unit tests on pull requests and triggering live project runs on the main branch merge. Use this when establishing automated testing workflows, validating data transformation logic, or integrating Hex outputs into a continuous delivery process.

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.

Utilize the idc-index Python package to access and query massive public datasets from the NCI Imaging Data Commons (IDC). This skill allows users to search, download, and visualize large-scale radiology (CT, MR, PET) and pathology (slide) images. It is essential for AI model training, medical research, and complex medical data analysis.

This skill guides the systematic process of conducting comprehensive academic literature reviews. It allows users to search multiple biomedical, scientific, and technical databases (e.g., PubMed, arXiv, Semantic Scholar) to synthesize current knowledge. The output generates professionally formatted reports (Markdown/PDF) with verified citations, and mandatorily integrates AI-generated scientific schematics to enhance visualization and depth, suitable for research papers, meta-analyses, and state-of-the-art reports.

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.

A comprehensive, structured framework for conducting sophisticated Open Source Intelligence (OSINT) and cryptocurrency forensic investigations. This guide covers operational security (OpSec), target profiling, advanced transaction tracing across multiple blockchain layers (L1/L2), wallet analysis, and identifying linked digital assets. Use this methodology to guide systematic, multi-dimensional intelligence collection campaigns.