Optimizes database performance through advanced query tuning, strategic indexing, and scalable architectural design.
The Database Optimizer skill transforms Claude into a specialized performance engineer for modern data systems. It provides expert guidance on analyzing execution plans, rewriting inefficient queries, and implementing advanced indexing strategies across SQL, NoSQL, and NewSQL platforms. From resolving N+1 query issues in ORMs to designing distributed caching layers and horizontal scaling architectures, this skill helps developers eliminate bottlenecks, reduce cloud infrastructure costs, and ensure high availability for data-intensive applications.
主な機能
01Strategic multi-tier indexing for B-tree, GIN, and Composite indexes
02Distributed caching architecture design with Redis and Memcached
03Comprehensive N+1 query detection and ORM optimization patterns
04Database scaling strategies including partitioning and sharding
0531,722 GitHub stars
06Advanced execution plan analysis and query rewriting
ユースケース
01Optimizing cloud database costs and resource utilization in AWS, Azure, or GCP
02Identifying and resolving slow query performance in production environments
03Designing zero-downtime schema migrations for high-traffic tables
