Develocity Analytics · MCP session
develocity analytics MCP
Give me the 3 most disruptive flaky tests for the last month.
Agent
develocity analytics · execute_query
SELECT work_unit_path, COUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count > 0 THEN build_id END) AS builds_affected, ROUND(100.0 * COUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count > 0 THEN build_id END) / COUNT(DISTINCT build_id), 2) AS fail_rate_pct FROM test_performance_summary WHERE build_start_date >= DATE '2026-05-12' AND work_unit_path IS NOT NULL GROUP BY work_unit_path HAVING COUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count > 0 THEN build_id END) > 0 AND COUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count = 0 THEN build_id END) > 0 ORDER BY builds_affected DESC LIMIT 3;
3 rows
The 3 test tasks that failed the most builds while also passing in others — classic flaky behavior:
Test task
Builds affected
Failure rate
:checkout-service:integrationTest
605
26.16%
:payments-gateway:contractTest
418
37.39%
:web-app:e2eTest
397
41.92%
› Ask about your builds