Skill UI

Guides a Power BI DAX expert through performance, readability, best-practice, and maintainability reviews; recommends variable reuse, context tuning, and error handling; then outputs an optimized formula plus justification for analytics models.

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.

Helps implement optimized Power BI semantic models by analyzing the active model with MCP tools, then advising on star schemas, DAX, relationships, security, documentation, and performance best practices for reporting scenarios.

This technique guides users to use precise chemical compound names, specific concentration values (e.g., "1.5 mg/L"), and taxonomic synonym counts as exact-match search anchors when querying biological literature. By leveraging quotation marks and combining multiple specific terms, it uniquely identifies research papers or species details, greatly improving search precision in biochemistry and botany.

This guide teaches advanced methodology for identifying target species using multiple biological features. Users learn to combine distinct clues such as habitat, morphology, behavior, and geographic range. A key technique involves first identifying the country through demographic clues (e.g., population growth, endemic status) to significantly narrow the search scope before searching for the specific species.

ETE is a comprehensive toolkit for phylogenomic research, designed to handle and analyze hierarchical tree structures. It supports various tree formats (Newick, NHX) and provides advanced functionalities such as detecting evolutionary events (duplication/speciation), identifying orthologs/paralogs, integrating with NCBI taxonomy for lineage tracking, and generating publication-quality visualizations in PDF/SVG.

This comprehensive skill provides a standardized pipeline for reconstructing the evolutionary history of biological sequences (genes, proteins, genomes). It guides users through essential steps, including multiple sequence alignment using MAFFT, maximum likelihood tree inference with IQ-TREE 2, and visualization with ETE3. Ideal for research in viral phylodynamics, molecular clock studies, and large-scale comparative genomics.

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.

Provides quick, LLM-optimized summaries for a single academic paper using arXiv IDs or URLs. This skill employs a tiered source fallback system, starting with a structured overview, progressing to full markdown, and finally inspecting the source LaTeX files for deep details. It is designed for rapid comprehension of one specific paper, not for broad literature reviews.

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 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.