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.

A universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

Cross-database SQL performance optimization assistant offering query tuning, indexing strategies, pagination, batch operations, and monitoring guidance for MySQL, PostgreSQL, SQL Server, Oracle, and other relational systems.

Accelerate scientific Python code on NVIDIA hardware using CUDA and RAPIDS libraries. Optimizes NumPy, pandas, scikit-learn, and ML workloads for GPU execution. Includes profiling, memory management, and kernel optimization to ensure correctness and performance gains.

High-performance Python DataFrame library built on Apache Arrow. Covers expression-based API, lazy query optimization, streaming out-of-core processing, aggregations, window functions, joins, and pandas migration for ETL and analytics pipelines.

A comprehensive guide to diagnosing and fixing performance bottlenecks when using Qdrant. Covers optimizing slow uploads, resolving stuck optimizers, and tuning HNSW parameters, including best practices for sharding, bulk loading, and multi-tenant indexing to ensure efficient vector search performance.

A comprehensive guide for developers to optimize performance when integrating Adobe APIs (Firefly, PDF, Photoshop). Techniques covered include implementing token caching, parallelizing asynchronous job submissions, leveraging response caching (LRU), and optimizing connection handling to minimize latency and maximize throughput.

This guide outlines advanced strategies to optimize latency and throughput when integrating Anthropic's Claude API. Learn critical techniques such as streaming responses, prompt caching, model selection (Haiku, Sonnet, Opus), and request parallelization, ensuring your applications provide a low-latency, high-performance user experience.

This guide provides advanced techniques to boost Framer API performance. It covers critical optimization areas including batch CMS syncing to prevent timeouts, memoizing expensive React components for better render performance, establishing persistent WebSocket connections, and optimizing image URLs before CMS synchronization. Use this when aiming to improve overall speed and stability of Framer-integrated applications.

This guide provides techniques to significantly boost performance when integrating with the Hex API. It covers essential optimization strategies such as implementing LRU caching for project lists, running multiple independent jobs in parallel, and adopting adaptive polling intervals to manage API latency and resource usage effectively. Use this when facing slow data retrieval or requiring high-throughput data processing.

This comprehensive guide outlines advanced strategies for optimizing interactions with the Attio REST API. Techniques covered include implementing LRU caching for schemas, using batch queries to avoid N+1 problems, efficient pagination (including streaming), and optimizing connection pooling via keep-alive. It helps developers maximize API throughput, minimize latency, and reliably process large volumes of data.