The SQL Query Optimizer skill empowers Claude to act as a Senior Database Administrator, diagnosing performance issues in complex queries across PostgreSQL, MySQL, and SQL Server. It provides deep technical insights into execution plans, identifies performance-draining anti-patterns like non-sargable predicates, and offers concrete code rewrites. By suggesting strategic indexing—including B-Tree, GIN, and covering indexes—and schema refactoring, this skill ensures your database operations are scalable, efficient, and cost-effective.
主要功能
01Strategic indexing recommendations (B-Tree, GIN, GiST)
02Execution plan analysis and bottleneck identification
03Automated SQL rewriting for set-based performance
042 GitHub stars
05Detection of anti-patterns like leading wildcards and N+1 queries
06Schema refactoring advice for normalization and denormalization
