optimizing-sql
CommunityBoost SQL query performance.
Software Engineering#indexing#postgresql#sql#performance tuning#mysql#query analysis#database optimization
Authorancoleman
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses slow database queries by providing tools and strategies to analyze execution plans, identify bottlenecks, and optimize SQL performance across PostgreSQL, MySQL, and SQL Server.
Core Features & Use Cases
- EXPLAIN Plan Analysis: Interpret query execution plans to pinpoint performance issues.
- Indexing Strategies: Guidance on creating single-column, composite, and covering indexes.
- Query Rewriting: Techniques to refactor inefficient queries, avoid anti-patterns, and leverage database-specific features.
- Use Case: A critical API endpoint is experiencing slow response times due to a poorly performing SQL query; this Skill helps diagnose the issue and provides actionable steps to rewrite the query and add appropriate indexes, reducing latency.
Quick Start
Use the optimizing-sql skill to analyze the performance of the provided SQL query and suggest optimizations.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: optimizing-sql Download link: https://github.com/ancoleman/ai-design-components/archive/main.zip#optimizing-sql Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.