Skill UI

This guide provides comprehensive, code-based solutions for diagnosing and fixing common errors encountered in Databricks environments. It covers critical issues such as cluster state failures, Spark OutOfMemory errors, Delta Lake concurrency conflicts, permission problems, and schema mismatches, offering tailored fixes in Python, SQL, and Bash.

This comprehensive diagnostic bundle collects critical evidence from the Databricks environment, including environment setup, cluster state, job run history, and Delta table diagnostics. It generates a redacted, safe tar.gz file specifically designed for submitting detailed support tickets and efficiently troubleshooting complex data pipeline issues.

A comprehensive runbook designed for on-call engineers to manage Databricks incidents, outages, and major job failures. It provides structured procedures for immediate triage, decision tree guidance (covering cluster failures, code errors, and data quality issues), and steps for evidence collection and postmortem documentation, ensuring rapid and systematic incident resolution.

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.

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.

Query the GTEx portal and API to retrieve tissue-specific gene expression, eQTL, sQTL, and variant-level regulatory data for interpreting GWAS loci and exploring gene regulation across 54 human tissues.

Analyzes occupational health data to assess work-related risks, ergonomic issues, symptoms, and trends. Use it to generate personalized workplace health advice, screen for occupational hazards, and relate work factors to sleep, exercise, and mental health.

Trackio is an essential library for logging, visualizing, and analyzing machine learning training experiments. It provides multi-interface support: a Python API for real-time metric logging and alert firing during training; a Command Line Interface (CLI) for retrieving historical metrics and alerts; and synchronization capabilities to Hugging Face Spaces for persistent dashboards. This tool is crucial for debugging, diagnosing training issues (like loss spikes), and automating ML workflow iteration.

Reviews Python + BigQuery pipelines to flag runaway costs, missing dry-run safeguards, unsafe backfills, write idempotency issues, and monitoring gaps, returning a structured report with exact function/line references for minimal fixes.

This skill provides programmatic access to the CZ CELLxGENE Census, a comprehensive collection of versioned public single-cell and spatial transcriptomics data. It enables efficient querying of population-scale cell metadata, gene expression slices, and embeddings without downloading entire datasets. Suitable for analyzing human, mouse, and other organism data across tissues and diseases. Integrates with Scanpy, AnnData, and TileDB-SOMA for large-scale analysis and machine learning workflows.

This tool collects comprehensive diagnostic data from ClickHouse system tables. It gathers crucial metrics, query logs, merge statuses, and disk usage information. It is essential for troubleshooting performance bottlenecks, preparing detailed support tickets, or investigating complex database infrastructure issues.

This guide provides a quick reference for diagnosing and fixing the top common errors encountered in ClickHouse, including syntax errors, memory limit issues, write permission failures, and data type mismatches. It offers specific error codes, root causes, and actionable SQL solutions for smooth database operation and complex analytics.