Navigate Spree's canonical data model — the Catalog (Product/Variant/OptionType/Taxon/Property/Metafield), Pricing (Price/PriceList)…
Build with Spree's event bus and Webhooks 2.0 — `Spree::Events` publication, `Spree::Subscriber` DSL with `subscribes_to` and `on`…
Build Spree extensions as Rails engines — gem scaffolding, `bin/rails g spree:extension`, mounting routes/migrations/assets, the modern…
Work with Spree's legacy v2 APIs — JSON:API-style Storefront API at `/api/v2/storefront/*` and Platform API at `/api/v2/platform/*`…
Configure Spree for multi-store and multi-region commerce — one Rails install running many `Store` records, the v5.4+ `Market` model…
Profile and optimize a Spree application — N+1 queries with bullet/scout, database indexing strategy for Spree's polymorphic associations…
Build storefronts and integrations using `@spree/sdk` — the official TypeScript SDK for Spree's API v3 (v5.4+).
When to activate: Spring Boot, @RestController, @Service, @Repository, auto-configuration, profiles, actuator, exception handling, Spring…
Provides distributed transaction patterns using the Saga Pattern for Spring Boot microservices.
Facilitates the implementation of robust microservice architectures using Nacos, Sentinel, RocketMQ, and other Alibaba Cloud components.
Converts strategy documents, issue lists, or audits into dependency-aware agent-team execution boards.
Plan a sprint with capacity estimation, story selection, dependency mapping, and risk identification.
Summarize a sprint's worth of Claude Code activity — sessions grouped by project (cwd), per-model cost breakdown, token efficiency (cache…
SpriteKit API reference — all node types, physics body creation, action catalog, texture atlases, constraints, scene setup, particles…
Use when the user wants to audit SpriteKit game code for common issues.
Reviews and merges Dependabot pull requests for Go modules (gomod) at the sq repo root.
SQL query writing and optimisation: complex joins, window functions, CTEs, indexes, query plans, migration patterns
Remediates SQL injection security findings safely using validated execution plans, allowlisted tools, and strict outcome verification.
Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.
Analyzes SQL queries for missing indexes, N+1 patterns, suboptimal joins, and full table scans.
Write SQL and design indexes that stay fast as data grows — composite index column ordering, keeping predicates sargable, avoiding…