backend-design

Translate product discovery artifacts into backend API, schema, and auth specifications.

Updated Nov 8, 2025
One-click install
npx skills add https://github.com/ivanyeors/product-agentic-templates --skill backend-design-ivanyeors
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: backend-design
Source: https://github.com/ivanyeors/product-agentic-templates/tree/main/.cursor/skills/04-backend-design
Command: npx skills add https://github.com/ivanyeors/product-agentic-templates --skill backend-design-ivanyeors

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Translates discovery and product design artifacts into implementation-ready backend specifications, ensuring traceable APIs, schemas, and an integration-ready auth model.

Core Features & Use Cases

  • OpenAPI contract generation from PRD and data dictionary
  • Schema design mapping to database tables with migration plans
  • Auth & permissions modeling and integration point design
  • Gate-driven handoff and phase-4 coordination for backend implementation

Quick Start

Create Phase 04 backend design artifacts by converting discovery and product design outputs into API contracts, schemas, and auth models.

Frequently Asked Questions about backend-design

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

FAQPage Schema
How do I generate an OpenAPI spec from a PRD and data dictionary?

To generate an OpenAPI spec from a PRD and data dictionary, translate product discovery artifacts into concrete backend specifications. This requires mapping PRD FR-IDs to API contracts, aligning schemas with the data dictionary, and defining explicit error handling.

How do I design database schemas from product design artifacts?

Designing database schemas from product design artifacts involves mapping schema designs to database tables with migration plans. This process ensures backend specifications remain traceable to PRD requirements and aligned with the data dictionary.

What is the best way to model auth and permissions for a new product backend?

Modeling auth and permissions for a new product backend requires translating discovery outputs into an integration-ready auth model. You must define explicit integration points and ensure traceability to PRD FR-IDs during the API contract design phase.

Does API contract design require traceability to PRD FR-IDs?

Yes, API contract design requires strict traceability to PRD FR-IDs. Translating product discovery into backend specifications ensures APIs, schemas, and auth models remain verifiable against functional requirements and aligned with the data dictionary.

How do I handle pagination and error handling in OpenAPI spec generation?

Handling pagination and error handling during OpenAPI spec generation requires explicitly defining these elements within the API contracts. You must translate discovery artifacts into backend specifications that include defined error handling and pagination for list endpoints.

When do I need backend specifications for new products?

You need backend specifications for new products during Phase 4 coordination, applying them to API contract design, OpenAPI spec generation, database schema design, and auth modeling. This ensures implementation-ready handoff from product discovery outputs.