How does this skill help avoid premature optimization?

By profiling every stage of a pipeline (e.g., from download to final ingestion) before making changes, it identifies exactly which phase consumes the most time, preventing developers from optimizing the wrong component.

Can I use this for databases other than QuestDB?

Yes, while the examples highlight QuestDB, the methodology and agents are designed to be adapted to any multi-stage data system or database environment.

Do the investigation agents run one after another?

No, this skill utilizes Claude's ability to trigger multiple tool calls simultaneously, allowing all four investigation agents to run in parallel to save time.

Multi-Agent Performance Profiler

Name: Multi-Agent Performance Profiler
Author: terrylica

byterrylica

•

分析与监控

Identifies and quantifies system bottlenecks through parallel multi-agent analysis of data pipelines and database operations.

This skill automates a sophisticated 5-agent orchestration pattern to diagnose performance issues in complex, multi-stage data systems. By spawning parallel agents to analyze instrumentation, database configurations, client libraries, and batch sizes simultaneously, it provides an evidence-based integration report that prioritizes optimizations by impact (P0-P2). This methodology helps developers avoid the common pitfall of premature optimization by identifying the true root cause of performance gaps, ensuring that engineering efforts are focused on the stages that provide the highest return on investment for meeting Service Level Objectives.

主要功能

01Multi-stage pipeline instrumentation (Download, Extract, Parse, Ingest)

02Consensus-based synthesis for automated optimization roadmaps

03Deep analysis of database configurations and client library patterns

042 GitHub stars

055-Agent Parallel Orchestration for comprehensive system auditing

06Impact quantification framework (P0-P2 Priority levels)

使用场景

01Evidence-based pre-optimization analysis for complex backend systems

02Optimizing database ingestion performance to meet strict SLOs

03Diagnosing throughput bottlenecks in multi-stage ETL pipelines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add terrylica/cc-skills multi-agent-performance-profiling

For use in Claude.ai and ChatGPT

Download Skill