SQL Query Optimization for Database Administrators
Optimize SQL queries and eliminate database bottlenecks
What You Can Do
Analyze your SQL queries to identify performance bottlenecks and generate optimized versions. You get refactored queries with better execution plans, index recommendations, and explanations of the improvements. Transform slow, resource-heavy queries into fast, efficient database operations.
Features
Breaks down execution plans and identifies slow operations causing performance degradation
Suggests JOIN rewrites, subquery improvements, and structural changes
Proposes specific indexes with column selections and performance impact estimates
Translates database output into actionable insights and bottleneck identification
Handles PostgreSQL, MySQL, SQL Server, and SQLite syntax and query engines
Compares before/after performance metrics and quantifies improvement potential
Applies proven techniques like query decomposition, window functions, and materialization
Recommends partitioning, caching, and statistical analysis for persistent performance
Example Output
Example: Optimized JOIN query
Original (2500ms):
SELECT u.id, COUNT(o.id) FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.created_at > '2026-01-01'
GROUP BY u.id ORDER BY COUNT(o.id) DESC;
Optimized (280ms):
SELECT u.id, o.order_count FROM users u
LEFT JOIN (SELECT user_id, COUNT(*) as order_count
FROM orders WHERE created_at > '2026-01-01'
GROUP BY user_id) o ON u.id = o.user_id
ORDER BY o.order_count DESC;
✓ 89% faster — Aggregate pushed down; index on orders.created_at eliminates full table scan
What's Included
- SKILL.md: Query optimization workflows and decision trees
- SQL analysis template: Structured checklist for query evaluation
- Index recommendation worksheet: Identifies candidate columns and selectivity metrics
- EXPLAIN plan decoder: Interprets cost estimates and node types across database systems
- Before/after metrics tracker: Documents baseline vs. optimized performance
- Multi-database reference: Syntax and optimization patterns for PostgreSQL, MySQL, SQL Server, SQLite
Who It's For
- Database administrators — Optimize legacy systems and production workloads
- Backend engineers — Improve API response times and reduce database load
- DevOps engineers — Tune high-traffic databases and identify scaling needs
- Data engineers — Speed up ETL pipelines and analytical queries
- System architects — Plan indexing strategies during schema design
Best For
- Analyzing EXPLAIN plans from slow query logs
- Creating index strategies for high-traffic tables
- Refactoring complex JOINs and subqueries
- Optimizing batch operations and bulk data processing
- Diagnosing database performance bottlenecks in production
You might also like
Analyze Solidity and other smart contract code for security vulnerabilities, gas inefficiencies, and best practice violations. Get detailed reports with risk scoring, remediation suggestions, and optimization recommendations. Whether you're auditing before deployment or reviewing third-party contracts, this skill identifies critical issues faster than manual review.
You can systematically diagnose database performance bottlenecks by sharing your schema, slow query logs, and execution plans with Claude. It identifies root causes—missing indexes, inefficient joins, lock contention—and provides prioritized recommendations with ready-to-implement SQL. Skip the manual log analysis and get tuning strategies tailored to your workload.
This skill provides a structured approach to analyzing process problems, identifying root causes, and recommending capacity optimizations. You'll get clear bottleneck identification, data-driven recommendations, and a framework to validate whether your solutions actually work. Perfect for diagnosing why workflows are slow and finding the leverage points that matter most.
Use Claude to systematically analyze your database queries, execution plans, and schema to identify performance bottlenecks. The skill generates actionable optimization recommendations with SQL rewrites, index strategies, and configuration tuning. You'll receive detailed before-and-after performance analysis to validate improvements and prioritize work by impact.
This skill evaluates your research protocols against institutional review board requirements, identifies compliance gaps, and generates the documentation needed for IRB submission. You receive a detailed assessment report, risk analysis, and ready-to-use documentation templates tailored to your specific research design.
Conduct organized security assessments using Claude as your strategic partner. You'll develop comprehensive test plans, identify vulnerabilities through systematic reconnaissance, document findings with professional rigor, and map security gaps to compliance frameworks. Claude helps you maintain audit trails, prioritize risks by business impact, and generate executive reports.
You can systematically evaluate cloud platforms, document architectural decisions with tradeoffs, and validate designs against security and compliance requirements. This skill accelerates architecture reviews, ensures consistency across teams, and reduces the cycles needed to reach approval on complex infrastructure decisions.
You can architect multi-node ROS control systems from scratch, including node design patterns, communication flows, and real-time constraints. You'll debug complex node interactions using publisher/subscriber analysis, service call tracing, and action server diagnostics. You can optimize motion controllers through PID tuning, trajectory planning validation, and performance profiling to achieve precise, responsive robotic behavior.