skills.rest
zhizhunbao
zhizhunbaoCOMMUNITY
Explore all skills by this author →
GitHub

senior-backend

Generates Express routes, database migrations, and load tests for Node.js backend APIs.

1|2|Updated Mar 5, 2026
Search Tags:#postgresql#database migration#api design#openapi#load testing#express#backend security
One-click install
npx skills add https://github.com/zhizhunbao/textbook-rag --skill senior-backend-zhizhunbao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: senior-backend
Source: https://github.com/zhizhunbao/textbook-rag/tree/main/.agent/skills/dev-senior_backend
Command: npx skills add https://github.com/zhizhunbao/textbook-rag --skill senior-backend-zhizhunbao

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Backend development involves repetitive scaffolding of API routes, manual database schema analysis, and ad-hoc performance testing. This Skill automates route generation from OpenAPI specs, detects missing indexes and N+1 query risks in PostgreSQL, and measures API latency under load, while providing security hardening patterns based on OWASP Top 10. ## 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 find missing indexes and N+1 query risks, then generate migration files with rollback support and dry-run capability. - API Load Testing: Run concurrent HTTP load tests measuring latency percentiles (P50/P95/P99), throughput, and error rates, with endpoint comparison mode. - Use Case: When building a new user service, define the API in an OpenAPI YAML file, scaffold all routes and validators, analyze the database for missing indexes, then load test the endpoints to verify P95 latency stays under 200ms before deployment. ## Quick Start Ask the assistant to scaffold Express routes from your openapi.yaml spec, then analyze your PostgreSQL database for missing indexes and load test the resulting endpoints.

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 specification?▼

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 router combining all routes.

How to find missing indexes in a PostgreSQL database?▼

Run database_migration_tool.py with your connection string and the --analyze flag. It reports missing indexes with average query times, detects N+1 query risks, and suggests migrations you can generate and dry-run before applying.

Which Node.js frameworks does the API scaffolder support?▼

The scaffolder supports Express, Fastify, and Koa, selected via the --framework flag. Express is the default, and generated output includes route handlers, validators, and TypeScript type definitions.

How do I compare performance between two API endpoints?▼

Pass both endpoint URLs to api_load_tester.py with the --compare flag plus concurrency and duration settings. It runs load tests on both and prints a side-by-side comparison of throughput, latency percentiles, and success rates.

What latency metrics does the load tester report?▼

The load tester reports min, average, max, standard deviation, and P50, P90, P95, and P99 latency percentiles in milliseconds. It also reports requests per second, success rate, error breakdown by type, and performance recommendations.

Can I test database migrations before applying them?▼

Yes, use the --dry-run flag with database_migration_tool.py when running a migration file. This validates the migration against your database without applying changes, and every generated migration includes a corresponding rollback file.

Related Skills

Explore More Software Engineering Skills→
Prathmesh2000Prathmesh2000
1

schema-designer

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

Community
Advanced
mahg-esmahg-es
3

cloud-deploy

Provision cloud infrastructure with Terraform, Pulumi, or CloudFormation.

Official
Advanced
TwuanMinnTwuanMinn

api-security-best-practices

Implement authentication, authorization, input validation, rate limiting, and TLS for API endpoints.

Community
Advanced
tankpkgtankpkg
1

@tank/prisma-production-patterns

Standardize Prisma ORM production patterns for TypeScript applications.

Official
Advanced