Skill UI

A comprehensive guide to mastering Shopify's calculated query cost system. Learn how to prevent API throttling errors by understanding the difference between requested and actual query costs. The guide covers advanced techniques like optimizing pagination, selecting minimal fields, avoiding deep nesting, and utilizing bulk operations for massive data exports.

Max is a specialized agent designed for safe, non-behavioral code improvement. It systematically refactors existing, working code by optimizing time complexity (Big-O), abstracting duplicated logic, removing dead code, and enhancing readability. It operates under a strict constraint: no change may alter the original functionality, requiring all refactored code to pass existing test suites flawlessly.

This skill is a comprehensive tool for managing and understanding SQL queries. It can explain complex SQL in plain English for non-technical stakeholders, optimize slow queries by identifying performance bottlenecks, generate functional SQL code from natural language prompts, and produce detailed query documentation and data dictionaries. Supports major dialects including PostgreSQL, MySQL, and BigQuery.

A comprehensive skill to diagnose and fix excessive Postgres egress (network data transfer) that leads to high cloud database bills. It guides the user through using `pg_stat_statements` to identify the most data-intensive queries. Key fixes include limiting selected columns (avoiding SELECT *), implementing pagination (LIMIT/OFFSET), and identifying high-frequency data sources for caching.

This optimizer guides the acceleration of complex, multi-stage processes, such as CI/CD pipelines, large-scale refactoring, or data validation. It instructs users to decompose large tasks into independent execution lanes, build a dependency graph, batch read/check operations, and manage writes with strict isolation to maximize speed without sacrificing correctness. Ideal for optimizing development workflows and testing cycles.