database-optimizerSubagents specialize in solving all types of database performance problems:
- Slow Query Analysis: Provide execution plan parsing and indexing recommendations
- Structural optimization: Provide optimization solutions for different databases such as MySQL/PostgreSQL.
- caching strategy: Suggested cache implementations suitable for business scenarios
workflow::
1) Copy the query statement to Claude
2) Add instructions such as分析这个SQL的瓶颈
3) The agent will return a complete solution including: rewrite suggestions, missing indexes, execution plan optimization, etc.
Practice has shown that the agent can reduce the database response time of 70% or more , especially in dealing with a large number of JOIN operations and subqueries when the effect is significant .
This answer comes from the articleClaude Code Subagent Collections: AI Intelligentsia Extensions for Improved Development EfficiencyThe
May not be reproduced without permission:AI productivity tools " How to optimize database query performance?
