sql-and-query-optimization
CommunitySpeed up SQL and ORM queries safely.
Software Engineering#indexing#sql#orm#query-optimization#query-tuning#execution-plan#database-performance
AuthorTiepbm
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Optimizes SQL and ORM-generated queries to reduce latency, resource usage, and lock contention, without altering business results.
Core Features & Use Cases
- Analyze execution plans, row estimates, and bottlenecks to identify inefficient predicates, scans, and join orders.
- Align indexes with common predicates, joins, and sorting to improve coverage and minimize write costs.
- Validate changes with before/after measurements, and ensure safe rollout with rollback plans and monitoring.
Quick Start
Run an actual execution plan analysis on a representative query and implement the recommended index or rewrite changes to validate performance gains.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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: sql-and-query-optimization Download link: https://github.com/Tiepbm/software-engineering-agent/archive/main.zip#sql-and-query-optimization 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.