Skill UI

This comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.

This comprehensive checklist guides users through critical operational readiness steps for a ClickHouse production deployment. It covers server tuning (config.xml), schema design best practices, robust backup strategies (S3), detailed monitoring setup (Prometheus/Grafana), security hardening, and application integration verification. Use this document before go-live, during major upgrades, or when auditing production systems to ensure maximum stability and performance.

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.

Implements a robust data pipeline for handling large documents with the Grammarly API. This utility manages text chunking to comply with API character limits (max 100k), processes text in manageable segments, and aggregates multiple scoring metrics (like correctness, clarity, and tone) into a single, comprehensive report. Ideal for large-scale content analysis and data ingestion.

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.

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 provides comprehensive patterns for extracting and transforming Navan booking and transaction data. It addresses complex data pipeline challenges such as API pagination, date range chunking, and UUID-based deduplication. It supports both direct REST API implementation (via code examples) and configuration for managed connectors like Fivetran and Airbyte. Ideal for populating data warehouses, building robust analytics dashboards, or ensuring data quality from Navan sources.

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.