skills.rest
Tgoldi
TgoldiCOMMUNITY
Explore all skills by this author →
GitHub

senior-backend

Generates Express route scaffolding, database migrations, and HTTP load tests for Node.js backend development.

1|Updated May 10, 2026
Search Tags:#postgresql#database migration#api design#openapi#load testing#express#backend security
One-click install
npx skills add https://github.com/Tgoldi/claude-skills --skill senior-backend-tgoldi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: senior-backend
Source: https://github.com/Tgoldi/claude-skills/tree/main/senior-backend
Command: npx skills add https://github.com/Tgoldi/claude-skills --skill senior-backend-tgoldi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyyaml, and includes scripts (resource) and references (resource) components.

What problem does it solve? Backend engineers repeatedly write boilerplate route handlers, hunt for missing database indexes, and guess at API performance under load. This Skill automates API scaffolding from OpenAPI specs, schema analysis with migration generation, and load testing with latency percentile reporting. ## Core Features & Use Cases - API Scaffolding: Generate Express/Fastify/Koa route handlers, Zod validation middleware, and TypeScript types directly from an OpenAPI specification. - Database Migration & Optimization: Analyze PostgreSQL schemas to detect missing indexes and N+1 query risks, then generate migration files with rollback support. - API Load Testing: Run concurrent HTTP load tests measuring P50/P95/P99 latency, throughput, and error rates, with endpoint comparison mode. - Use Case: When designing a new user service, feed your openapi.yaml to the scaffolder to generate routes and validators, analyze the database for missing indexes, then load test the endpoints before production release. ## Quick Start Ask the assistant to generate Express routes from your OpenAPI spec file and then load test the resulting endpoints with 50 concurrent requests.

Frequently Asked Questions about senior-backend

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate Express routes from an OpenAPI spec?▼

Run the api_scaffolder.py script with your OpenAPI YAML or JSON file and an output directory. It generates route handlers grouped by tag, Zod validation middleware, TypeScript types, and an index file combining all routers.

How to load test a REST API endpoint with Python?▼

Use the api_load_tester.py script with the target URL, concurrency level, and duration. It reports requests per second, success rate, and latency percentiles including P50, P95, and P99, plus recommendations when latency exceeds targets.

Does the API scaffolder support Fastify and Koa?▼

Yes, the scaffolder accepts a --framework flag with express, fastify, or koa options. Express is the default, and the generated output includes route handlers, validators, and TypeScript type definitions.

How do I find missing database indexes in PostgreSQL?▼

Run the database migration tool with your connection string and the --analyze flag. It reports missing indexes with average query times, N+1 query risks, and generates suggested migration files with rollback support.

Can I compare performance between two API versions?▼

Yes, pass two URLs to the load tester with the --compare flag. It runs both endpoints at the same concurrency and duration, then shows a side-by-side diff of throughput, latency percentiles, and success rates.

What are the limitations of the OpenAPI YAML parser?▼

The scaffolder uses PyYAML when available and falls back to a basic built-in parser supporting only a YAML subset. Complex YAML features like anchors or multi-line strings may not parse correctly without PyYAML installed.

Related Skills

Explore More Software Engineering Skills→
Prathmesh2000Prathmesh2000
1

schema-designer

Generate PostgreSQL, OpenAPI, JSON Schema, and GraphQL schemas with migration guidance.

Community
Advanced
chiruu12chiruu12
1

canary

Monitor production apps for errors and regressions after deployment.

Community
Advanced
apisec-incapisec-inc
18

api-security-review

Review API code against the OWASP API Security Top 10 2023.

Official
Advanced
markus41markus41
1

graphql

Create GraphQL schemas, resolvers, queries, mutations, and subscriptions.

Community
Intermediate