Database Performance Tuning Analyst
Diagnose and optimize database performance systematically
What You Can Do
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.
Features
identify problematic queries from logs or execution history with root cause diagnosis
understand EXPLAIN PLAN output and suggest structural optimizations
suggest missing or redundant indexes with selectivity and cardinality analysis
generate optimized SQL with better joins, aggregations, and subquery elimination
identify denormalization opportunities, partitioning strategies, and archival plans
recommend pool size, timeout, and recycling parameters based on your workload
establish before/after measurements to track improvement ROI
rank queries by frequency and cost to focus optimization on highest impact items
Example Output
Slow Query Analysis & Optimization
Current Query (450ms):
SELECT o.id, COUNT(i.id) as item_count, u.name
FROM orders o
JOIN items i ON o.id = i.order_id
JOIN users u ON o.user_id = u.id
WHERE o.created_at > NOW() - INTERVAL '30 days'
GROUP BY o.id, u.name;
EXPLAIN PLAN Issues:
- Seq Scan on orders (5K rows)
- Nested loop joins (no index acceleration)
- Execution: 450ms, 2.8M rows examined
Optimized Query (15ms):
SELECT o.id, COUNT(i.id), u.name
FROM orders o
INNER JOIN items i ON o.id = i.order_id
INNER JOIN users u ON o.user_id = u.id
WHERE o.created_at > NOW() - INTERVAL '30 days'
GROUP BY o.id, u.name;
Index Strategy:
CREATE INDEX idx_orders_created ON orders(created_at)→ 30x faster filteringCREATE INDEX idx_items_order_id ON items(order_id)→ efficient join- Result: 30x improvement (450ms → 15ms)
Schema Redesign Recommendation
Your users table is joined in 14 common queries but only 3 columns are read. Consider:
- Move
bio,profile_picto separateuser_profilestable (read rarely) - Denormalize
tier,countryinto users table (read frequently) - Partition orders by month (queries filter by date)
- Expected 3-4x faster user queries, 50% less cache pressure
What's Included
- `SKILL.md`: Step-by-step database performance analysis and optimization workflow
- Query analysis checklist: systematic process for identifying and prioritizing bottlenecks
- Index optimization framework: methodology for evaluating index effectiveness and ROI
- Query rewrite patterns: SQL optimization templates with before/after examples
- Schema audit checklist: denormalization, partitioning, and archival evaluation guide
- Performance baseline worksheet: measurement template for validating improvements
Who It's For
- Database Administrators optimizing production systems under load
- Backend Engineers debugging slow queries in their services
- DevOps Engineers tuning database infrastructure and connection pools
- Performance Engineers tasked with database scaling initiatives
- Tech Leads evaluating schema redesigns and optimization ROI
Best For
- Analyzing slow query logs and identifying optimization priorities
- Interpreting EXPLAIN PLAN output for complex joins and aggregations
- Designing indexes and estimating expected performance impact
- Refactoring slow SQL queries into optimized versions
- Planning schema changes (denormalization, partitioning, archival strategies)
You might also like
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.
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.
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.
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.