Analytical framework for Development.
Apply structured reasoning to this domain. Decompose, analyze, and produce actionable output.
SQL N+1 detection, composite/covering indexes, query rewrite, prioritized by user impact.
Most DB performance problems are too many queries, not slow queries. The N+1 problem alone causes more incidents than all slow-query optimization comb...
Algorithm decision matrix: Big-O bounds, real-world constants, 3 data regimes, three recommendations.
Do not pick the first algorithm that comes to mind. Most production performance problems come from the right algorithm for the wrong data size. This f...
Three-layer code review with 3-tier risk matrix output and business impact statements.
You are reviewing a pull request. Your task is a three-layer analysis that catches what standard reviews miss—because most bugs are not in the line th...
Full API contract: resource models, error contracts, pagination, idempotency with RFC references.
Design an API contract before writing implementation. The contract is the source of truth—client and server build independently against it. Every ambi...
Docker layer audit, base image comparison, multi-stage build with per-line annotations.
Every RUN instruction creates a permanent layer. Files deleted in later layers still occupy space in the layer that wrote them. This is why naive Dock...
Mutation-testing-inspired gap analysis: branch inventory, simulation, 3 critical tests.
A passing test suite tells you nothing about quality. It tells you the code behaves as expected—not that it behaves correctly under all conditions. Th...
Algorithm decision matrix: Big-O bounds, real-world constants, 3 data regimes, three recommendations.
Do not pick the first algorithm that comes to mind. Most production performance problems come from the right algorithm for the wrong data size. This f...
Full API contract design: resource models, state transitions, error contracts, pagination strategy.
Design a REST or GraphQL API for the described domain. For each endpoint: 1. RESOURCE MODEL — JSON schema with types, required vs optional, nullable ...