Agent skills for VS Code

Profile and optimize a Spree application — N+1 queries with bullet/scout, database indexing strategy for Spree's polymorphic associations…

Build and customize Spree's shipping and fulfillment — ShippingMethod, ShippingCategory, Zone/ZoneMember, ShippingRate, the…

Build storefronts and integrations using `@spree/sdk` — the official TypeScript SDK for Spree's API v3 (v5.4+).

Provides Spring Boot MCP server patterns that create Model Context Protocol servers with Spring AI by defining tool handlers, exposing…

When to activate: Spring Boot, @RestController, @Service, @Repository, auto-configuration, profiles, actuator, exception handling, Spring…

Build or extend Spring Boot applications with a phase-aware workflow.

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.

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.

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…

Automatically fix SQL performance issues with step-by-step measurement.

Explains, optimises, writes, and documents SQL queries.

Analyzes SQL performance, interprets execution plans, and provides actionable optimization strategies for databases and ORMs.

Expert knowledge for SQL Server on Azure Virtual Machines development including troubleshooting, best practices, decision making…