sql-query-optimization

SKILL.md

Analyze SQL queries to identify performance bottlenecks and implement optimization techniques. Includes query analysis, indexing strategies, and rewriting patterns for improved performance.

❌ Don't create indexes without testing impact ❌ Don't use LIKE with leading wildcard without full-text search ❌ Don't JOIN unnecessary tables ❌ Don't ignore ORDER BY performance impact ❌ Don't skip EXPLAIN analysis

✅ DO test query changes in development first ✅ DO monitor query performance after deployment ✅ DO update table statistics regularly ✅ DO use appropriate data types for columns ✅ DO consider materialized views for complex aggregations

성능을 위해 SQL 쿼리를 분석하고 최적화합니다. PostgreSQL 및 MySQL에서 느린 쿼리를 개선하거나, 실행 시간을 줄이거나, 쿼리 성능을 분석할 때 사용합니다. 출처: aj-geddes/useful-ai-prompts.

원본 보기