Skill

Optimize Application Performance End-to-End

Skill orchestrating a 5-phase, multi-agent workflow for end-to-end application performance profiling and optimization.

Works with datadognew relicopentelemetryredismemcached

71
Spark score
out of 100
Updated 9 days ago
Version 14.6.0

Add to Favorites

Why it matters

Achieve peak application performance by orchestrating a comprehensive optimization process across your entire stack, from deep profiling to continuous monitoring.

Outcomes

What it gets done

01

Profile application performance and establish baselines.

02

Optimize database queries, backend code, and distributed systems.

03

Enhance frontend loading, CDN caching, and mobile experiences.

04

Conduct load testing and validate performance improvements.

Install

Add it to your toolbox

Run in your project directory:

curl -fsSL https://spark.entire.vc/get/ag-application-performance-performance-optimization | bash

Overview

Application Performance Performance Optimization

Skill orchestrating a five-phase, multi-subagent application performance optimization workflow - profiling and baselines, database/backend tuning, frontend/CDN/mobile optimization, load testing with CI/CD regression guardrails, and production monitoring - with concrete numeric success criteria for latency, Core Web Vitals, throughput, and cost. Use when coordinating performance optimization across backend, frontend, and infrastructure together with access to real metrics and tracing data.

What it does

This skill orchestrates a comprehensive, five-phase application performance optimization workflow across the entire stack, dispatching specialized subagents via the Task tool for each step so that later phases build on data-driven findings from earlier ones rather than theoretical improvements. Phase 1 (Performance Profiling & Baseline) uses a performance-engineer subagent to generate CPU flame graphs, heap dumps, I/O traces, and database/API/frontend baseline metrics (with APM tools like DataDog or New Relic where available), an observability-engineer subagent to assess existing monitoring, OpenTelemetry tracing, and log aggregation for instrumentation gaps, and a further performance-engineer pass to measure Core Web Vitals (LCP, FID, CLS) and Real User Monitoring data. Phase 2 (Database & Backend Optimization) has a database-optimizer subagent tackle slow queries, missing indexes, Redis/Memcached caching, and connection pooling; a backend-architect subagent address N+1 queries, async patterns, pagination, response compression, and circuit breakers; and a performance-engineer subagent optimize service-to-service communication, message queues (Kafka/RabbitMQ), and distributed caching. Phase 3 (Frontend & CDN Optimization) has a frontend-developer subagent handle code splitting, tree shaking, lazy loading, and critical rendering path; a cloud-architect subagent configure CDN/edge caching (CloudFlare/CloudFront), image formats (WebP/AVIF), and HTTP/2/3 with Brotli compression; and a mobile-developer subagent optimize service workers, adaptive loading, and touch responsiveness for mobile/PWA. Phase 4 (Load Testing & Validation) runs comprehensive load tests with k6/Gatling/Artillery across normal, peak, and stress scenarios, then builds automated performance regression tests wired into CI/CD (Lighthouse CI, Artillery, GitHub Actions) with automatic rollback triggers. Phase 5 (Monitoring & Continuous Optimization) sets up production APM, distributed tracing, Grafana dashboards, PagerDuty alerts, and SLI/SLO definitions, then establishes an ongoing process of performance-budget tracking, A/B testing of performance changes, continuous production profiling, and regular review cycles. Configurable options include performance_focus (latency/throughput/cost/balanced), optimization_depth (quick-wins/comprehensive/enterprise), available tooling, budget constraints, and rollout tolerance (zero-downtime/maintenance-window/gradual). It defines concrete success criteria: P50 <200ms/P95 <1s/P99 <2s response times, Core Web Vitals thresholds (LCP <2.5s, FID <100ms, CLS <0.1), 2x peak load support at <1% error rate, database query P95 <100ms, CPU <70%/memory <80% utilization, at least 30% cost-per-performance improvement, and 100% critical-path monitoring coverage.

When to use - and when NOT to

Use this skill when coordinating performance optimization across backend, frontend, and infrastructure together, establishing baselines and profiling to find real bottlenecks, designing load tests or capacity plans, or building performance/reliability observability. Do not use it for a small, localized fix with no broader performance goal, when there's no access to metrics, tracing, or profiling data to ground the work in, or for requests unrelated to performance or scalability. Load testing production requires approval and safeguards, and performance changes should roll out gradually with rollback plans.

Inputs and outputs

Input is the target application/system ($ARGUMENTS) plus configuration for focus, depth, available tooling, and budget/rollout constraints. Output is, per phase: profiling reports and baselines, database/backend/distributed-system optimizations, frontend/CDN/mobile optimizations, load test results and CI/CD-integrated regression tests, and production monitoring dashboards, alerts, and a continuous optimization process.

Integrations

Coordinates specialized subagents (performance-engineer, observability-engineer, database-optimizer, backend-architect, frontend-developer, cloud-architect, mobile-developer, test-automator) and references APM/observability tooling (DataDog, New Relic, Dynatrace, OpenTelemetry, Grafana, PagerDuty), load-testing tools (k6, Gatling, Artillery), and CDN/edge platforms (CloudFlare, CloudFront).

Who it's for

Teams and engineers coordinating an end-to-end, cross-stack performance optimization effort - backend, frontend, infrastructure, and monitoring together - who need a phased, data-driven process rather than isolated tuning of one layer.

Source README

Optimize application performance end-to-end using specialized performance and optimization agents:

[Extended thinking: This workflow orchestrates a comprehensive performance optimization process across the entire application stack. Starting with deep profiling and baseline establishment, the workflow progresses through targeted optimizations in each system layer, validates improvements through load testing, and establishes continuous monitoring for sustained performance. Each phase builds on insights from previous phases, creating a data-driven optimization strategy that addresses real bottlenecks rather than theoretical improvements. The workflow emphasizes modern observability practices, user-centric performance metrics, and cost-effective optimization strategies.]

Use this skill when

  • Coordinating performance optimization across backend, frontend, and infrastructure
  • Establishing baselines and profiling to identify bottlenecks
  • Designing load tests, performance budgets, or capacity plans
  • Building observability for performance and reliability targets

Do not use this skill when

  • The task is a small localized fix with no broader performance goals
  • There is no access to metrics, tracing, or profiling data
  • The request is unrelated to performance or scalability

Instructions

  1. Confirm performance goals, constraints, and target metrics.
  2. Establish baselines with profiling, tracing, and real-user data.
  3. Execute phased optimizations across the stack with measurable impact.
  4. Validate improvements and set guardrails to prevent regressions.

Safety

  • Avoid load testing production without approvals and safeguards.
  • Roll out performance changes gradually with rollback plans.

Phase 1: Performance Profiling & Baseline

1. Comprehensive Performance Profiling

  • Use Task tool with subagent_type="performance-engineer"
  • Prompt: "Profile application performance comprehensively for: $ARGUMENTS. Generate flame graphs for CPU usage, heap dumps for memory analysis, trace I/O operations, and identify hot paths. Use APM tools like DataDog or New Relic if available. Include database query profiling, API response times, and frontend rendering metrics. Establish performance baselines for all critical user journeys."
  • Context: Initial performance investigation
  • Output: Detailed performance profile with flame graphs, memory analysis, bottleneck identification, baseline metrics

2. Observability Stack Assessment

  • Use Task tool with subagent_type="observability-engineer"
  • Prompt: "Assess current observability setup for: $ARGUMENTS. Review existing monitoring, distributed tracing with OpenTelemetry, log aggregation, and metrics collection. Identify gaps in visibility, missing metrics, and areas needing better instrumentation. Recommend APM tool integration and custom metrics for business-critical operations."
  • Context: Performance profile from step 1
  • Output: Observability assessment report, instrumentation gaps, monitoring recommendations

3. User Experience Analysis

  • Use Task tool with subagent_type="performance-engineer"
  • Prompt: "Analyze user experience metrics for: $ARGUMENTS. Measure Core Web Vitals (LCP, FID, CLS), page load times, time to interactive, and perceived performance. Use Real User Monitoring (RUM) data if available. Identify user journeys with poor performance and their business impact."
  • Context: Performance baselines from step 1
  • Output: UX performance report, Core Web Vitals analysis, user impact assessment

Phase 2: Database & Backend Optimization

4. Database Performance Optimization

  • Use Task tool with subagent_type="database-cloud-optimization::database-optimizer"
  • Prompt: "Optimize database performance for: $ARGUMENTS based on profiling data: {context_from_phase_1}. Analyze slow query logs, create missing indexes, optimize execution plans, implement query result caching with Redis/Memcached. Review connection pooling, prepared statements, and batch processing opportunities. Consider read replicas and database sharding if needed."
  • Context: Performance bottlenecks from phase 1
  • Output: Optimized queries, new indexes, caching strategy, connection pool configuration

5. Backend Code & API Optimization

  • Use Task tool with subagent_type="backend-development::backend-architect"
  • Prompt: "Optimize backend services for: $ARGUMENTS targeting bottlenecks: {context_from_phase_1}. Implement efficient algorithms, add application-level caching, optimize N+1 queries, use async/await patterns effectively. Implement pagination, response compression, GraphQL query optimization, and batch API operations. Add circuit breakers and bulkheads for resilience."
  • Context: Database optimizations from step 4, profiling data from phase 1
  • Output: Optimized backend code, caching implementation, API improvements, resilience patterns

6. Microservices & Distributed System Optimization

  • Use Task tool with subagent_type="performance-engineer"
  • Prompt: "Optimize distributed system performance for: $ARGUMENTS. Analyze service-to-service communication, implement service mesh optimizations, optimize message queue performance (Kafka/RabbitMQ), reduce network hops. Implement distributed caching strategies and optimize serialization/deserialization."
  • Context: Backend optimizations from step 5
  • Output: Service communication improvements, message queue optimization, distributed caching setup

Phase 3: Frontend & CDN Optimization

7. Frontend Bundle & Loading Optimization

  • Use Task tool with subagent_type="frontend-developer"
  • Prompt: "Optimize frontend performance for: $ARGUMENTS targeting Core Web Vitals: {context_from_phase_1}. Implement code splitting, tree shaking, lazy loading, and dynamic imports. Optimize bundle sizes with webpack/rollup analysis. Implement resource hints (prefetch, preconnect, preload). Optimize critical rendering path and eliminate render-blocking resources."
  • Context: UX analysis from phase 1, backend optimizations from phase 2
  • Output: Optimized bundles, lazy loading implementation, improved Core Web Vitals

8. CDN & Edge Optimization

  • Use Task tool with subagent_type="cloud-infrastructure::cloud-architect"
  • Prompt: "Optimize CDN and edge performance for: $ARGUMENTS. Configure CloudFlare/CloudFront for optimal caching, implement edge functions for dynamic content, set up image optimization with responsive images and WebP/AVIF formats. Configure HTTP/2 and HTTP/3, implement Brotli compression. Set up geographic distribution for global users."
  • Context: Frontend optimizations from step 7
  • Output: CDN configuration, edge caching rules, compression setup, geographic optimization

9. Mobile & Progressive Web App Optimization

  • Use Task tool with subagent_type="frontend-mobile-development::mobile-developer"
  • Prompt: "Optimize mobile experience for: $ARGUMENTS. Implement service workers for offline functionality, optimize for slow networks with adaptive loading. Reduce JavaScript execution time for mobile CPUs. Implement virtual scrolling for long lists. Optimize touch responsiveness and smooth animations. Consider React Native/Flutter specific optimizations if applicable."
  • Context: Frontend optimizations from steps 7-8
  • Output: Mobile-optimized code, PWA implementation, offline functionality

Phase 4: Load Testing & Validation

10. Comprehensive Load Testing

  • Use Task tool with subagent_type="performance-engineer"
  • Prompt: "Conduct comprehensive load testing for: $ARGUMENTS using k6/Gatling/Artillery. Design realistic load scenarios based on production traffic patterns. Test normal load, peak load, and stress scenarios. Include API testing, browser-based testing, and WebSocket testing if applicable. Measure response times, throughput, error rates, and resource utilization at various load levels."
  • Context: All optimizations from phases 1-3
  • Output: Load test results, performance under load, breaking points, scalability analysis

11. Performance Regression Testing

  • Use Task tool with subagent_type="performance-testing-review::test-automator"
  • Prompt: "Create automated performance regression tests for: $ARGUMENTS. Set up performance budgets for key metrics, integrate with CI/CD pipeline using GitHub Actions or similar. Create Lighthouse CI tests for frontend, API performance tests with Artillery, and database performance benchmarks. Implement automatic rollback triggers for performance regressions."
  • Context: Load test results from step 10, baseline metrics from phase 1
  • Output: Performance test suite, CI/CD integration, regression prevention system

Phase 5: Monitoring & Continuous Optimization

12. Production Monitoring Setup

  • Use Task tool with subagent_type="observability-engineer"
  • Prompt: "Implement production performance monitoring for: $ARGUMENTS. Set up APM with DataDog/New Relic/Dynatrace, configure distributed tracing with OpenTelemetry, implement custom business metrics. Create Grafana dashboards for key metrics, set up PagerDuty alerts for performance degradation. Define SLIs/SLOs for critical services with error budgets."
  • Context: Performance improvements from all previous phases
  • Output: Monitoring dashboards, alert rules, SLI/SLO definitions, runbooks

13. Continuous Performance Optimization

  • Use Task tool with subagent_type="performance-engineer"
  • Prompt: "Establish continuous optimization process for: $ARGUMENTS. Create performance budget tracking, implement A/B testing for performance changes, set up continuous profiling in production. Document optimization opportunities backlog, create capacity planning models, and establish regular performance review cycles."
  • Context: Monitoring setup from step 12, all previous optimization work
  • Output: Performance budget tracking, optimization backlog, capacity planning, review process

Configuration Options

  • performance_focus: "latency" | "throughput" | "cost" | "balanced" (default: "balanced")
  • optimization_depth: "quick-wins" | "comprehensive" | "enterprise" (default: "comprehensive")
  • tools_available: ["datadog", "newrelic", "prometheus", "grafana", "k6", "gatling"]
  • budget_constraints: Set maximum acceptable costs for infrastructure changes
  • user_impact_tolerance: "zero-downtime" | "maintenance-window" | "gradual-rollout"

Success Criteria

  • Response Time: P50 < 200ms, P95 < 1s, P99 < 2s for critical endpoints
  • Core Web Vitals: LCP < 2.5s, FID < 100ms, CLS < 0.1
  • Throughput: Support 2x current peak load with <1% error rate
  • Database Performance: Query P95 < 100ms, no queries > 1s
  • Resource Utilization: CPU < 70%, Memory < 80% under normal load
  • Cost Efficiency: Performance per dollar improved by minimum 30%
  • Monitoring Coverage: 100% of critical paths instrumented with alerting

Performance optimization target: $ARGUMENTS

Limitations

  • Use this skill only when the task clearly matches the scope described above.
  • Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
  • Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.

FAQ

Common questions

Discussion

Questions & comments · 0

Sign In Sign in to leave a comment.