Use this agent when you need to optimize system performance, identify and resolve bottlenecks, improve application response times, reduce resource consumption, conduct performance testing and profiling, tune database queries, optimize infrastructure configurations, improve scalability, analyze memory usage patterns, or implement caching strategies. Examples:\n\n<example>\nContext: User has implemented a new feature and wants to ensure it performs well.\nuser: "I've added a new dashboard feature that loads user analytics. Can you check if there are any performance issues?"\nassistant: "I'll use the performance-engineer agent to analyze the dashboard feature for performance bottlenecks and optimization opportunities."\n<uses Task tool to launch performance-engineer agent with instructions to profile the dashboard feature, identify slow queries or rendering issues, and provide optimization recommendations>\n</example>\n\n<example>\nContext: Application is experiencing slow response times in production.\nuser: "Our API endpoints are taking 3-5 seconds to respond. This is unacceptable."\nassistant: "I'll delegate this to the performance-engineer agent to investigate the API performance issues and identify the root causes."\n<uses Task tool to launch performance-engineer agent with instructions to profile API endpoints, analyze database queries, check for N+1 problems, review caching strategies, and provide specific optimization recommendations>\n</example>\n\n<example>\nContext: Proactive performance review after completing a feature.\nuser: "Here's the new real-time audio processing feature I just built."\nassistant: "Great work! Let me have the performance-engineer agent review this for any potential performance concerns, especially given the real-time nature of audio processing."\n<uses Task tool to launch performance-engineer agent with instructions to analyze the audio processing implementation for performance bottlenecks, memory leaks, CPU usage patterns, and optimization opportunities>\n</example>

Use this agent when you need to optimize database performance, analyze slow queries, design efficient indexes, tune database configurations, or improve scalability. Examples include:\n\n<example>\nContext: User is experiencing slow query performance on a production database.\nuser: "Our patch_sheets query is taking 3+ seconds to load. Can you help optimize it?"\nassistant: "I'm going to use the Task tool to launch the database-optimizer agent to analyze and optimize this query performance issue."\n<commentary>\nSince the user is reporting slow query performance, use the database-optimizer agent to analyze execution plans, identify bottlenecks, and recommend optimizations.\n</commentary>\n</example>\n\n<example>\nContext: User wants to improve database scalability before a major feature launch.\nuser: "We're launching a new feature next week that will 10x our database load. Can you review our schema and queries?"\nassistant: "I'm going to use the Task tool to launch the database-optimizer agent to perform a comprehensive scalability review."\n<commentary>\nSince the user needs scalability improvements, use the database-optimizer agent to analyze schema design, query patterns, indexing strategies, and recommend optimizations for handling increased load.\n</commentary>\n</example>\n\n<example>\nContext: User has just completed a new feature with complex database queries.\nuser: "I've finished implementing the real-time analytics dashboard. Here's the code."\nassistant: "Great work! Now I'm going to use the Task tool to launch the database-optimizer agent to review the query performance and indexing strategy."\n<commentary>\nProactively use the database-optimizer agent after complex database work is completed to ensure queries are optimized before they reach production.\n</commentary>\n</example>