Skill UI

A comprehensive skill for managing the entire lifecycle of datasets on the Hugging Face Hub. It allows users to initialize, configure, and stream updates for datasets of various types (Chat, Text Classification, Tabular). Crucially, it extends data handling capabilities by enabling powerful SQL-based querying and transformation directly on Hub datasets using the DuckDB engine, facilitating advanced data exploration and pipeline creation.

A comprehensive expert prompt for evaluating Power BI data models. It guides the assessment of model architecture (Star Schema, relationships), storage optimization (Import, DirectQuery, Dual), data quality, performance scalability, and governance best practices. Use this when reviewing an existing BI model to ensure it is robust, maintainable, and highly performant.

Provides systematic Power BI performance troubleshooting guidance covering model optimization, DAX design, report layout, and capacity diagnostics, plus tool-driven measurement tips for faster page loads, interactions, and query execution.

The ETE Toolkit is a powerful Python library designed for analyzing, manipulating, comparing, and visualizing phylogenetic trees stored in Newick or Nexus formats. It allows users to perform topology edits, calculate phylogenetic distances (e.g., Robinson-Foulds), detect evolutionary events, and query external taxonomic databases like NCBI/GTDB. Note that this tool analyzes existing trees; it is not used for inferring trees from raw sequences.

This powerful Python library provides comprehensive medicinal chemistry filters for compound triage in drug discovery. Users can apply established drug-likeness rules (like Lipinski's Rule of Five, Veber, and CNS rules), detect structural alerts (PAINS, NIBR), calculate complexity metrics, and filter molecular libraries using a custom query language. It is essential for prioritizing hit compounds and optimizing lead structures.

PySam provides a powerful Python interface for low-level, streaming access to HTSlib-supported genomic data formats. It enables reading, querying, filtering, and writing complex formats such as SAM/BAM/CRAM, VCF/BCF, FASTA/FASTQ, and tabix-indexed tables. It is essential for bioinformatics pipelines requiring precise control over genomic data manipulation, including pileup and coverage calculations.

This comprehensive guide provides advanced workflows for interacting with ClickHouse. It covers efficient bulk data insertion (CSV, JSON), complex analytical querying (funnel analysis, retention), implementing materialized views for pre-aggregation, and utilizing powerful window functions. Ideal for building high-performance OLAP dashboards and executing large-scale data transformations.

Provides expert guidance for connecting to Power BI Desktop's local tabular model using the Tabular Object Model (TOM) and ADOMD.NET via PowerShell. This skill covers model enumeration, executing DAX queries, metadata modification (tables, measures, relationships), query tracing, and model refreshing. It is specifically designed for managing the underlying data model structure when external tools like Tabular Editor CLI are unavailable.

A comprehensive guide to authoring, optimizing, and validating Power Query M expressions used within semantic model partitions. This resource covers crucial topics such as maintaining query folding for performance, applying early filtering and column pruning, and leveraging the Power Query API for robust data validation and debugging.

The Tabular Editor CLI (`te`) is a cross-platform, command-line utility for managing the entire lifecycle of semantic models (TMDL/BIM). It allows users to scaffold, inspect, validate, deploy, refresh, test, and query data models against various services, including Power BI, Fabric, and Azure AS, directly from the terminal. Ideal for automated workflows and CI/CD pipelines.

Velociraptor is a powerful open-source platform for endpoint visibility and digital forensics. It allows users to deploy agents across thousands of endpoints and execute sophisticated VQL (Velociraptor Query Language) queries. This enables large-scale, on-demand forensic artifact collection, TTP hunting, and continuous monitoring during incident response, even on air-gapped or unmanaged systems.