Skill UI

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 a comprehensive, production-ready reference architecture for building advanced analytics platforms powered by ClickHouse. It details everything from project layout (TypeScript/Node.js structure) and data ingestion pipelines (Kafka, Webhooks) to the optimal 3-layer schema design (Raw, Hourly, Daily) and multi-tenancy patterns, ensuring scalable and efficient OLAP query performance.

This workflow provides comprehensive methods for executing core Create, Read, Update, and Delete (CRUD) operations on standard Salesforce objects, including Accounts, Contacts, Leads, and Opportunities. It utilizes both powerful SOQL querying for data retrieval and the robust REST API for bulk modifications and advanced integrations, making it ideal for automating complex CRM and sales processes.

This tool empowers users to query, filter, and aggregate logs from Datadog directly from the command line using the Composio CLI. It bypasses the graphical UI, providing structured JSON output for complex analysis, cross-service correlation, and automated reporting. Ideal for deep dive investigations, tracking latency regressions, or building scheduled operational digests.

A powerful DI extension point for Website Builders, allowing developers to inject custom query parameters into all live preview URLs. This is essential for integrating complex features like signed tokens, tenant identifiers, or feature flags directly into the preview experience. It supports asynchronous operations, such as fetching remote authorization tokens, ensuring robust customization across the editor iframe and generated links.

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.

This skill provides comprehensive guides and references for writing, debugging, and systematically optimizing DAX formulas within semantic models. It covers advanced topics including systematic performance optimization workflows, engine internals (like xmSQL), and best practices for both local (Power BI Desktop) and remote (Fabric/XMLA) model environments, ensuring efficient data calculation and query performance.