Design a single feature with database schema and API endpoints
Design complete features with database schema and API endpoints through an interactive 4-phase workflow. Use this when starting new features to generate ERD, DBML, PostgreSQL migrations, and API contracts that follow your team's standards.
/plugin marketplace add venturo-id/venturo-claude/plugin install venturo-planner@venturo-toolsYou will guide the user through creating a complete feature design with ERD, DBML, PostgreSQL migration, and API contract.
This command uses an incremental 4-phase workflow to create feature documentation step-by-step.
Ask the user these questions first:
product_catalog, order_management)Present a complete plan and ask for confirmation before proceeding.
After confirmation, execute these phases sequentially (read each phase file when needed):
phases/new-feature/01-feature-erd.mdphases/new-feature/02-feature-dbml.mdphases/new-feature/03-feature-migrations.mdphases/new-feature/04-feature-api-contract.mdAfter each phase:
Database Standards:
DATABASE_STANDARDS.md before startingFile Naming:
docs/database/erd/{feature_name}.mmddocs/database/dbml/{feature_name}.dbmldocs/database/migrations/{timestamp}_{feature_name}.sqldocs/api/contracts/{feature_name}.mdUser: /venturo-planner:new-feature
Claude: I'll help you design a new feature with database schema and API endpoints.
Let me ask some questions first:
1. What is the name of the feature? (use snake_case)
User: product_catalog
Claude: 2. What entities will this feature contain?
User: products, categories, product_images
Claude: 3. Let's define the 'products' entity.
What attributes should it have?
User: name (required), description (optional), price (required), stock (required), category_id (required), is_active (required)
[Continues through all questions, presents plan, executes phases]
docs/database/erd/{feature_name}.mmd - Mermaid ERDdocs/database/dbml/{feature_name}.dbml - DBML schemadocs/database/migrations/{timestamp}_{feature_name}.sql - PostgreSQL migrationdocs/api/contracts/{feature_name}.md - API contractAfter completion:
/venturo-go:new-feature to generate backend/venturo-react:new-feature with OpenAPI to generate frontend