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
You get Claude to analyze your API specifications and automatically generate bulletproof parameter validation logic. Claude creates security-hardened middleware, enforces type constraints, detects malicious input patterns, and generates comprehensive error handling — all tailored to your framework and existing codebase. The result is production-ready validation code with zero unvalidated inputs reaching your business logic.
This skill enables you to automatically audit your websites against compliance standards and detect deviations from expected baselines. You can track regulatory requirements, identify policy violations, and generate compliance reports with actionable remediation steps. Monitor multiple sites simultaneously and maintain detailed audit trails for compliance documentation.
Transform schema and data changes into production-ready migration packages that protect data integrity and minimize downtime. You can handle column additions, renames, type conversions, and backfills using proven patterns like expand-contract and shadow tables. The skill generates explicit rollback scripts, validation checklists, and phased execution plans that keep applications stable throughout the migration.
You'll transform high-level feature requirements into a complete development plan covering API design, frontend implementation, testing strategy, and documentation. The skill helps you identify dependencies, parallelize work across frontend and backend teams, and establish quality gates that ensure features ship bug-free with proper error handling and logging.
You can conduct comprehensive toxicology safety assessments, generate regulatory-compliant safety documentation, and produce detailed hazard analyses for pharmaceutical and chemical submissions. This skill structures toxicological data into standardized safety reports, maps findings to regulatory guidelines (FDA, EMA, ICH), and identifies risk characterization strategies to support regulatory submissions and approval timelines.
You can submit your Solidity smart contracts for comprehensive security analysis, vulnerability detection, and gas optimization recommendations. Claude reviews your code against known attack vectors, design patterns, and best practices—identifying reentrancy risks, overflow/underflow issues, access control flaws, and inefficient operations. You receive actionable fix recommendations with explanations of the security implications and gas savings potential.
You can design end-to-end NGS pipelines tailored to your experiment type (WGS, WES, RNA-seq, targeted), troubleshoot pipeline failures by analyzing QC metrics and logs, and optimize performance by fine-tuning parameters and identifying bottlenecks. This skill handles the full workflow from raw sequencing data quality assessment through variant interpretation and annotation.
You can accelerate your entire antenna design workflow—from initial concept to optimized specifications—by leveraging Claude's knowledge of electromagnetic theory, antenna types, and design trade-offs. Claude helps you parameterize designs, identify optimal configurations for your frequency band and application, and prepare detailed briefs for simulation and manufacturing. You'll generate design reviews, impedance-matching solutions, and validation checklists without context-switching to multiple tools.