coding agent · analytics session
develocity MCP
Which projects have the worst cache-miss rate this month? Ranked, top 5.
Agent
Cross-project question — loading the SQL skill, then querying.
⏺ develocity · get_develocity_skill(build-sql-analytics)
└ guidance loaded
⏺ develocity · execute_query
SELECT projectname, ROUND(100.0 * COUNT_IF(avoidance_outcome = 'executed_cacheable') / COUNT(*), 1) AS miss_rate FROM unit_execution_summary WHERE build_start_date >= DATE_TRUNC('month', CURRENT_DATE) AND build_cache_enabled = true GROUP BY projectname HAVING COUNT(*) >= 100 ORDER BY miss_rate DESC LIMIT 5
└ 5 rows
ProjectCache-miss rateweb-storefront38.4%payments-api29.1%android-client22.7%data-pipeline16.3%search-service9.8%
web-storefront has the worst cache-miss rate this month — the top three are where most build time is being rebuilt.
› Ask about your builds▸