# VC-SYS Enhanced Greenfield Fullstack Development Workflow with Supabase
# Version 3.1 - Market Intelligence + Security First + Accessibility Compliance + Supabase Provisioning

workflow:
  name: VC-SYS Greenfield Fullstack Development with Supabase
  version: 3.1
  description: Enhanced greenfield development with market intelligence, security-first architecture, accessibility compliance, and automated Supabase backend provisioning
  enhanced_features:
    - market_intelligence_integration
    - security_first_architecture  
    - accessibility_compliance
    - ai_agent_optimization
    - evidence_based_validation
    - supabase_backend_provisioning
    - automated_database_design

# Enhanced Workflow Phases
phases:
  # Phase 1: Market Intelligence & Business Foundation
  - name: market_intelligence
    description: Market research, competitive analysis, and business case development
    agents: [market-research-specialist, business-analyst, laboratory]
    deliverables:
      - docs/project-brief.md
      - docs/market-research.md
      - docs/competitor-analysis.md
      - docs/business-case.md
    quality_gates:
      - market_validation_required
      - competitive_analysis_comprehensive
      - business_case_validated_with_stakeholders
    
  # Phase 2: Product Requirements & User Experience
  - name: requirements_definition
    description: Evidence-based product requirements and user experience design
    agents: [product-owner, ux-expert, accessibility-specialist]
    dependencies: [market_intelligence]
    deliverables:
      - docs/prd.md
      - docs/user-personas.md
      - docs/user-journey-maps.md
      - docs/accessibility-requirements.md
    quality_gates:
      - requirements_evidence_based
      - user_research_validated
      - accessibility_compliance_integrated
      - stakeholder_alignment_confirmed

  # Phase 3: Security-First Architecture
  - name: architecture_design
    description: Security-first technical architecture with performance and accessibility
    agents: [technical-architect, security-specialist, performance-specialist]
    dependencies: [requirements_definition]
    deliverables:
      - docs/architecture.md
      - docs/architecture/security-architecture.md
      - docs/architecture/performance-architecture.md
      - docs/architecture/accessibility-architecture.md
      - docs/threat-model.md
    quality_gates:
      - security_architecture_reviewed
      - threat_model_comprehensive
      - performance_requirements_defined
      - accessibility_architecture_compliant

  # Phase 4: Database Design & Schema Architecture
  - name: database_design
    description: Automated database schema design and data architecture using Database Wizard
    agents: [database-wizard, technical-architect, security-specialist]
    dependencies: [architecture_design]
    cli_tools:
      - vcsys database-wizard --requirements docs/prd.md --schema-output docs/database-schema.sql
    deliverables:
      - docs/database-schema.sql
      - docs/database-architecture.md
      - docs/data-security-model.md
      - docs/database-performance-plan.md
    quality_gates:
      - database_schema_validated
      - data_security_implemented
      - performance_optimization_designed
      - scalability_requirements_addressed

  # Phase 5: Supabase Backend Provisioning
  - name: supabase_provisioning
    description: Automated Supabase project creation and backend infrastructure setup
    agents: [database-wizard, integration-specialist, security-specialist]
    dependencies: [database_design]
    cli_tools:
      - vcsys supabase auth
      - vcsys supabase provision --name {{project_name}} --schema docs/database-schema.sql
      - vcsys supabase deploy-schema docs/database-schema.sql
      - vcsys supabase env > .env.local
    deliverables:
      - live_supabase_project
      - database_tables_created
      - rls_policies_deployed
      - api_endpoints_configured
      - environment_variables_generated
    quality_gates:
      - supabase_project_provisioned
      - database_schema_deployed
      - security_policies_active
      - api_authentication_configured
      - environment_properly_configured

  # Phase 6: Epic Planning & Story Development
  - name: epic_planning
    description: Value-driven epic planning with AI-optimized story development including Supabase integration
    agents: [product-owner, technical-architect, scrum-master]
    dependencies: [supabase_provisioning]
    deliverables:
      - docs/epics/epic-*.md
      - docs/stories/story-*.md
      - docs/implementation-plan.md
      - docs/supabase-integration-guide.md
    quality_gates:
      - epics_value_driven
      - stories_ai_agent_optimized
      - implementation_plan_validated
      - dependencies_clearly_mapped
      - supabase_integration_planned

  # Phase 7: Development Setup & Foundation
  - name: development_foundation
    description: Secure development environment with quality gates and Supabase integration
    agents: [technical-architect, integration-specialist, qa-specialist]
    dependencies: [epic_planning]
    deliverables:
      - project_scaffolding
      - ci_cd_pipeline
      - security_scanning_integration
      - testing_framework
      - monitoring_setup
      - supabase_client_configuration
    quality_gates:
      - security_scanning_integrated
      - accessibility_testing_automated
      - performance_monitoring_enabled
      - quality_gates_enforced
      - supabase_client_integrated

  # Phase 8: AI-Optimized Implementation
  - name: implementation
    description: AI agent-optimized development with continuous validation and Supabase backend integration
    agents: [developer, qa-specialist, security-specialist, accessibility-specialist]
    dependencies: [development_foundation]
    deliverables:
      - implemented_features
      - test_suites
      - security_validation
      - accessibility_validation
      - performance_benchmarks
      - supabase_integration_complete
    quality_gates:
      - code_security_validated
      - accessibility_compliance_tested
      - performance_benchmarks_met
      - quality_standards_enforced
      - supabase_functionality_verified

  # Phase 9: Quality Validation & Deployment Readiness
  - name: quality_validation
    description: Comprehensive quality validation and deployment preparation with Supabase backend verification
    agents: [qa-specialist, security-specialist, accessibility-specialist, performance-specialist]
    dependencies: [implementation]
    deliverables:
      - security_audit_report
      - accessibility_compliance_report
      - performance_test_results
      - deployment_checklist
      - supabase_production_validation
    quality_gates:
      - security_audit_passed
      - accessibility_compliance_verified
      - performance_requirements_met
      - deployment_readiness_confirmed
      - supabase_backend_production_ready

# Enhanced Quality Gates
quality_gates:
  market_validation_required:
    description: Market research and competitive analysis must be comprehensive
    validation_criteria:
      - market_size_quantified
      - competitive_landscape_analyzed
      - user_personas_research_backed
      - business_case_financially_validated
    evidence_required: true

  security_architecture_reviewed:
    description: Security architecture must pass comprehensive review
    validation_criteria:
      - threat_model_comprehensive
      - security_controls_appropriate
      - compliance_requirements_addressed
      - security_testing_integrated
    mandatory: true

  accessibility_compliance_integrated:
    description: Accessibility requirements must be built into all phases
    validation_criteria:
      - wcag_aa_compliance_planned
      - inclusive_design_principles_applied
      - assistive_technology_support_designed
      - accessibility_testing_automated
    compliance_level: WCAG-AA

  ai_agent_optimization:
    description: All deliverables must be optimized for AI agent implementation
    validation_criteria:
      - story_sizing_appropriate
      - implementation_patterns_consistent
      - context_windows_optimized
      - testing_automation_ready
    optimization_level: high

  database_schema_validated:
    description: Database schema must be comprehensive and secure
    validation_criteria:
      - schema_design_complete
      - rls_policies_implemented
      - performance_indexes_optimized
      - data_integrity_constraints_enforced
    mandatory: true

  supabase_project_provisioned:
    description: Supabase backend must be properly provisioned and configured
    validation_criteria:
      - project_created_successfully
      - database_schema_deployed
      - api_endpoints_functional
      - authentication_configured
      - environment_variables_exported
    mandatory: true

# Success Metrics
success_metrics:
  business_metrics:
    - market_opportunity_score: ">= 7/10"
    - competitive_advantage_score: ">= 8/10"
    - business_case_roi: ">= 20%"
    - stakeholder_alignment_score: ">= 9/10"

  technical_metrics:
    - security_compliance_score: ">= 95%"
    - accessibility_compliance_score: ">= 100% WCAG-AA"
    - performance_benchmark_score: ">= 90%"
    - ai_implementation_readiness: ">= 95%"
    - supabase_integration_score: ">= 95%"

  quality_metrics:
    - evidence_validation_score: ">= 100%"
    - test_coverage: ">= 90%"
    - documentation_completeness: ">= 95%"
    - stakeholder_satisfaction: ">= 9/10"
    - backend_reliability_score: ">= 99%"

# Risk Management
risk_management:
  market_risks:
    - competitive_pressure_assessment
    - market_timing_analysis
    - user_adoption_risk_evaluation
    
  technical_risks:
    - security_vulnerability_assessment
    - performance_bottleneck_analysis  
    - integration_complexity_evaluation
    - supabase_dependency_risks
    
  project_risks:
    - resource_availability_tracking
    - timeline_risk_monitoring
    - stakeholder_alignment_maintenance
    - backend_provisioning_failures

# Continuous Improvement
continuous_improvement:
  feedback_loops:
    - user_research_continuous
    - market_intelligence_monitoring
    - competitive_analysis_updates
    - performance_metrics_tracking
    - supabase_performance_monitoring
    
  optimization_areas:
    - ai_agent_workflow_optimization
    - quality_gate_effectiveness
    - stakeholder_communication_improvement
    - delivery_velocity_enhancement
    - database_performance_optimization

# CLI Tool Integration
cli_automation:
  workflow_tools:
    - vcsys workflow start vcsys-greenfield-fullstack-supabase
    - vcsys workflow status
    - vcsys workflow next
    - vcsys workflow advance
  
  database_tools:
    - vcsys database-wizard --requirements {{requirements_file}} --schema-output {{schema_file}}
    
  supabase_tools:
    - vcsys supabase auth
    - vcsys supabase provision --name {{project_name}} --schema {{schema_file}}
    - vcsys supabase deploy-schema {{schema_file}}
    - vcsys supabase env
    - vcsys supabase status