Оптимизация производительности SQL-баз данных

★ 6.6 · data

database-optimizer is a Claude Code skill that acts as a senior database performance engineer specializing in slow query analysis, execution plan inspection, index design, query rewrites, and configuration tuning for PostgreSQL and MySQL. The skill targets sub-100ms query performance at scale and covers lock contention resolution, partitioning strategies, and cache hit rate improvements. It ships with five reference files — query-optimization, index-strategies, postgresql-tuning, mysql-tuning, and monitoring-analysis — and follows a five-step workflow: analyze, identify bottlenecks, design solutions, implement incrementally, and validate with metrics. A practical fit for engineering teams dealing with database slowdowns, EXPLAIN ANALYZE puzzles, or scaling challenges in high-traffic environments.