Senior Backend

What it does

This skill automates complex backend development tasks, including API creation, database management, and performance testing. It provides tools for generating API routes from OpenAPI specifications or existing databases, creating migration files with rollback support, and load-testing API endpoints to identify bottlenecks. The goal is to streamline backend workflows and improve efficiency through optimized scripts and automated processes.

When to use it

• Generating API route handlers and middleware quickly based on an OpenAPI specification.
• Analyzing a database schema for potential optimizations and generating migration files.
• Load testing an API endpoint to assess its performance under stress.
• Creating TypeScript types and validation middleware alongside generated routes.
• Automatically generating an OpenAPI specification from existing API routes.

Key capabilities

• API Scaffolder: Generates API route handlers, middleware, and OpenAPI specifications from schema definitions or database schemas. Supports Express.js, Fastify, and Koa frameworks.
• Database Migration Tool: Analyzes database schemas, detects changes, generates migration files with rollback support, and provides optimization suggestions.
• API Load Tester: Performs load testing on API endpoints to measure performance metrics like response time and error rates.

Example prompts

• "Generate Express routes from this OpenAPI specification: openapi.yaml."
• "Analyze the database schema at postgres://localhost/mydb and suggest optimizations."
• "Load test the /users endpoint on https://api.example.com with a concurrency of 50 for 30 seconds."

Tips & gotchas

• Requires Python to execute the provided scripts.
• The Database Migration Tool requires a database connection string to analyze schemas and generate migrations.
• Ensure that the specified frameworks (Express, Fastify, Koa) are compatible with your project's environment.