Update an existing feature design with schema and API changes
Updates an existing feature design with schema and API changes, regenerating ERD, DBML, PostgreSQL migration, and API contract files. Use when modifying entities, relationships, or endpoints for existing features.
/plugin marketplace add venturo-id/venturo-claude/plugin install venturo-planner@venturo-toolsYou will guide the user through updating an existing feature design, regenerating ERD, DBML, PostgreSQL migration, and API contract with changes.
This command uses an incremental 5-phase workflow to update feature documentation.
Ask the user these questions first:
product_catalog)Present a complete change plan and ask for confirmation before proceeding.
After confirmation, execute these phases sequentially (read each phase file when needed):
phases/update-feature/01-load-existing.mdphases/update-feature/02-update-erd.mdphases/update-feature/03-update-dbml.mdphases/update-feature/04-generate-migration.mdphases/update-feature/05-update-api-contract.mdAfter each phase:
Database Standards:
DATABASE_STANDARDS.md before startingMigration Strategy:
File Naming:
docs/database/erd/{feature_name}.mmd (overwrite)docs/database/dbml/{feature_name}.dbml (overwrite)docs/database/migrations/{timestamp}_update_{feature_name}.sql (new file)docs/api/contracts/{feature_name}.md (overwrite)User: /venturo-planner:update-feature
Claude: I'll help you update an existing feature design.
1. Which feature do you want to update?
User: product_catalog
Claude: 2. What changes do you need to make?
- Add new entities
- Modify existing entities
- Update API endpoints
- Other
User: Add a new entity "product_reviews" and add a "rating" column to products
Claude: Let me confirm the changes:
**New Entity:**
- product_reviews (id, product_id, user_id, rating, comment, ...)
**Modified Entity:**
- products: add "average_rating" column (DECIMAL 3,2)
**New Relationships:**
- products ||--o{ product_reviews
- users ||--o{ product_reviews
Proceed with these changes?
[Continues through all phases]
docs/database/erd/{feature_name}.mmd - Updated ERDdocs/database/dbml/{feature_name}.dbml - Updated DBMLdocs/database/migrations/{timestamp}_update_{feature_name}.sql - New migrationdocs/api/contracts/{feature_name}.md - Updated API contractDO NOT modify existing migration files! Always create a new migration:
-- Migration: 20250123170000_update_product_catalog.sql
-- Description: Add product_reviews table and average_rating to products
-- Add new table
CREATE TABLE IF NOT EXISTS product_reviews (...);
-- Modify existing table
ALTER TABLE products ADD COLUMN average_rating DECIMAL(3,2);
-- Add new indexes
CREATE INDEX idx_product_reviews_product_id ON product_reviews(product_id);
-- Rollback instructions (commented)
-- DROP TABLE product_reviews;
-- ALTER TABLE products DROP COLUMN average_rating;
Consider backward compatibility:
After updating:
After completion:
/venturo-go:new-migration