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.

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.

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.

Skill for working with Power BI reports using the pbir CLI. It covers exploring, building, managing, formatting, validating, and publishing reports, as well as driving Power BI Desktop for refresh and screenshots, and querying semantic models.

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.

Expert guidance for the cross-platform Tabular Editor CLI (`te`) to scaffold, inspect, edit, validate, query, deploy, refresh, and test Power BI / Analysis Services semantic models from the terminal, including TMDL/BIM conversion, BPA, DAX testing, and CI/CD pipelines.

A powerful utility that queries multiple free APIs (Pexels, Pixabay, Internet Archive, etc.) in a single query. It retrieves normalized, license-tagged results for real-world, historical, or archival images, videos, and GIFs, making it a peer to local semantic search and generative media tools. Includes specialized scripts for fetching and judging audio.

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.