Database Performance Tuning Analyzer
Identify and fix database performance issues with AI-driven diagnostics
What You Can Do
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.
Features
Parses EXPLAIN output to identify sequential scans, expensive joins, and nested loop inefficiencies
Suggests composite, covering, and partial indexes based on actual query patterns
Detects anti-patterns like missing primary keys, improper normalization, and suboptimal data types
Pinpoints blocking queries, deadlocks, and transaction isolation problems from logs
Categorizes queries by read/write ratio and complexity to prioritize optimization efforts
Evaluates sizing, connection wait times, and leak detection
Assesses buffer pool hit ratios and cache efficiency metrics
Quantifies performance gains from applied optimizations
Example Output
Query Performance Analysis
- 🔴 CRITICAL: SELECT orders.* FROM orders
JOIN customers ON orders.customer_id = customers.id
WHERE orders.created_at > '2024-01-01'
Execution time: 12.4 seconds (target: <1 second)
Issue: Seq scan on orders table (1.2M rows)
Missing index on (created_at, customer_id)
CREATE INDEX idx_orders_created_customer
ON orders(created_at DESC, customer_id)
INCLUDE (id, total);
Expected improvement: 8-10x faster
Lock Contention Report
- ⚠️ MEDIUM: High lock wait time on accounts table
Wait queue: 23 transactions
Average wait: 340ms
Root cause: Long-running UPDATE in background job
Solution: Break updates into smaller batches
Estimated impact: Reduce wait from 340ms → 12ms
What's Included
- SKILL.md: Complete database performance diagnostic workflow
- Query Analysis Template: Standardized checklist for evaluating execution plans
- Index Recommendation Worksheet: Step-by-step index optimization process
- Schema Review Checklist: Anti-patterns and remediation strategies
- Diagnostic Query Reference: Pre-built queries for PostgreSQL, MySQL, SQL Server
- Performance Measurement Guide: How to quantify optimization impact
- Lock and Contention Diagnostic Workbook: Common patterns and solutions
Who It's For
- Database Administrators — Diagnose and resolve production performance issues
- Performance Engineers — Systematize query tuning and indexing strategies
- Backend Engineers — Identify inefficient queries before deployment
- DevOps Engineers — Troubleshoot database performance during incident response
- Solutions Architects — Plan optimization roadmaps and capacity strategy
Best For
- Production incident response — Quickly diagnose slow queries causing outages
- Query optimization projects — Methodically improve application performance
- Index strategy development — Design optimal indexes for your workload
- Capacity planning — Defer infrastructure upgrades through optimization
- Performance regression diagnosis — Analyze unexpected query slowdowns
You might also like
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.
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.
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.