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'll develop systematic approaches to injectable formulation design, from API selection through sterilization strategy. Claude helps you troubleshoot failed batches by analyzing root causes, recommends regulatory pathways (505(b)(2), ANDA, NDA), and provides science-backed solutions for stability, compatibility, and manufacturability challenges.
This skill helps you systematically assess integration needs across your systems, design architecture patterns that scale with your organization, and identify technical and operational risks before implementation. You'll receive architecture recommendations aligned to your business constraints, clear integration roadmaps, and risk mitigation strategies that reduce deployment surprises. Get structured decision records suitable for architecture review boards and engineering teams.
Claude analyzes your code diffs and generates standardized commit messages that follow the Conventional Commits specification. The skill automatically determines the correct commit type, scope, and description based on the changes you've made, ensuring your messages are parseable by automation tools while remaining human-readable for code reviewers.
You can transform raw text into structured, labeled datasets for machine learning, analysis, and research. This skill performs named entity recognition, sentiment classification, part-of-speech tagging, and dependency parsing—generating consistent, validated annotations at scale. Use it to prepare corpora, extract entities, classify documents, or perform linguistic analysis without manual annotation.
This skill helps you systematically analyze service mesh architectures, identify inter-service communication failures, and design optimal routing and security policies. You'll receive step-by-step troubleshooting guidance tailored to your mesh platform (Istio, Linkerd, Consul), configuration validation reports, and architectural recommendations that reduce latency, improve observability, and tighten security posture.
This skill automates the creation of production-ready deployment validation checklists, infrastructure-as-code templates, and incident response runbooks tailored to your ML stack. You get comprehensive pre-deployment checks covering model validation, data pipeline integrity, infrastructure readiness, and monitoring setup—all customized for your specific models and cloud provider. The skill generates executable runbooks that teams can follow during incidents, including rollback procedures, failover strategies, and diagnostic commands.
Build scalable internal developer platform architectures that reduce cognitive load and standardize workflows for your development organization. Document golden paths that guide developers through common tasks like onboarding, deployment, and troubleshooting. Map platform capabilities, integrations, and service topology to align with your engineering scale and technical strategy.
Rapidly analyze firmware logs and diagnose hardware issues that cause device failures, connectivity problems, and performance degradation. You'll identify root causes from stack traces, crash dumps, and sensor data, then generate specific optimization recommendations. This skill transforms raw device logs into actionable debugging plans that reduce time-to-resolution from hours to minutes.