What problem does it solve? Backend decisions like API structure, database schema changes, and stack selection are often made ad hoc without measurable criteria, leading to slow queries, inconsistent APIs, and unverifiable reliability targets. This Skill enforces a disciplined workflow: surface assumptions, scaffold routes from OpenAPI specs, analyze database schemas, and load test endpoints before shipping. ## Core Features & Use Cases - API Scaffolding: Generate Express/Fastify/Koa route handlers, Zod validation middleware, and TypeScript types directly from an OpenAPI YAML/JSON specification. - Database Migration Analysis: Analyze PostgreSQL schemas, detect missing indexes and N+1 query risks, and generate migration files with dry-run support. - Load Testing: Run concurrent HTTP load tests measuring P50/P95/P99 latency, throughput, and error rates, with endpoint comparison mode. - Decision Engine: Match team size, QPS, tenancy, and data sensitivity against built-in profiles (node-express, fastapi-python, django-monolith, go-or-rust-microservice) to recommend a stack with SLO floors and named approvers. - Use Case: Before building a new SaaS API, run the decision engine with your team size and traffic forecast, scaffold routes from your OpenAPI spec, then load test the staging endpoints to verify the P99 latency target. ## Quick Start Ask the assistant to design a REST API for your service, starting by answering the seven forcing questions about traffic, tenancy, and data sensitivity so it can recommend a backend profile and scaffold the routes.
