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…
Automatically fix SQL performance issues with step-by-step measurement.
Explains, optimises, writes, and documents SQL queries.
Generate SQL queries from natural language descriptions.
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…
Use when: comparing SQL Server tables across instances, data migration validation, ETL verification, row mismatch detection, schema drift…
SQLAlchemy 2.0 patterns - model definition, engine setup, async patterns, relationships, query optimization, repository pattern, and…
SQLDelight patterns for Kotlin Multiplatform - .sq file definitions, platform drivers, type adapters, migrations, and shared database…
SQLite changes since training cutoff (latest: 3.51.0) — JSON enhancements, new SQL functions, FTS5 locale support, date modifiers, JSONB…