Create Database View Coverage Validation Dashboard

[pethers]

🎯 Objective

Create real-time monitoring dashboard showing database view-to-entity mapping coverage

📋 Background

With 84 database views and ongoing mapping efforts, need a dashboard to track coverage status, identify unmapped views, and monitor data access layer completeness.

📊 Current State (Measured Metrics)

• Total Views: 84 (56 regular + 28 materialized)
• Current Mapping Coverage: ~77% (65/84 views)
• Monitoring: Manual validation via schema-validation-v2.sql
• Dashboard: None - requires manual script execution

✅ Acceptance Criteria

• Web-based dashboard showing view mapping coverage percentage
• List of mapped vs unmapped views with status indicators
• Integration with schema-validation-v2.sql output
• Real-time coverage metrics updated on schema changes
• Alert mechanism when coverage drops below threshold

🤖 Recommended Agent

Agent: @hack23-code-quality-engineer
Rationale: Integration with existing validation tooling and metrics tracking

📚 Related Documentation

• schema-validation-v2.sql
• DATABASE_VIEW_INTELLIGENCE_CATALOG.md