backend-dev

Generate Express.js backends from OpenAPI contracts with Knex migrations and RBAC.

2|1|Updated Nov 15, 2025
One-click install
npx skills add https://github.com/lpding888/aiygw4.0 --skill backend-dev-lpding888
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: backend-dev
Source: https://github.com/lpding888/aiygw4.0/tree/main/skills/backend_dev_skill
Command: npx skills add https://github.com/lpding888/aiygw4.0 --skill backend-dev-lpding888

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams convert Product Planner task cards and contract definitions into production-ready backend services using Express.js, Knex.js, MySQL 8 and Redis. It enforces OpenAPI-first design, test-driven development, RBAC security, and observability as engineering baselines, enabling reliable and auditable backend delivery.

Core Features & Use Cases

  • OpenAPI-first design: Generate and lock OpenAPI contracts before implementation.
  • Data layer & migrations: Create Knex migrations, define schemas, and enforce robust data models.
  • RBAC & security: Integrate authentication/authorization, auditing, and safe defaults.
  • Observability & testing: Provide structured logs, request tracing, and >=80% test coverage.
  • Collaborative workflow: Align OpenAPI/UI contracts with Frontend/SCF, QA, Reviewer, and Deploy.

Quick Start

Bootstrapping a new backend task: draft an OpenAPI contract for the new resource, then use this Skill to generate the service skeleton, tests, and deployment notes.

Frequently Asked Questions about backend-dev

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

FAQPage Schema
How do I generate an Express.js backend from an OpenAPI specification?

You generate an Express.js backend from an OpenAPI specification by automating the conversion of planner contracts into production-ready services. It locks the OpenAPI contract first, then creates the service skeleton, Knex migrations, RBAC, and tests.

What is OpenAPI-first backend development and when do I need it for API-driven projects?

OpenAPI-first backend development generates and locks API contracts before implementation to enforce test-driven development and secure defaults. You need it for API-driven projects requiring robust data models, RBAC auditing, and collaborative alignment across teams.

Can I use Knex migrations and RBAC with Express.js for production-ready APIs?

Yes, you can use Knex migrations and RBAC with Express.js to build production-ready APIs. This approach enforces robust data models, integrates authentication and authorization auditing, and provides safe defaults for MySQL 8 and Redis environments.

How to achieve 80% test coverage and observability in an Express.js backend?

To achieve 80% test coverage and observability in an Express.js backend, you enforce test-driven development alongside structured logs and request tracing. This provides a verifiable CI/CD workflow with reliable, auditable backend delivery.

Does this backend generation approach work with MySQL 8 and Redis?

Yes, this backend generation approach works with MySQL 8 and Redis. It converts product planner task cards into production-ready backend services using Express.js and Knex.js, enforcing OpenAPI-first design and RBAC security baselines.