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
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.
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.
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'll design and implement mobile features with architectural rigor, cross-platform considerations, and edge-case handling built-in. This skill generates complete system designs, platform-specific implementation strategies, performance optimization approaches, and testing frameworks. The output is production-ready guidance spanning iOS and Android with security, offline resilience, and deployment strategies included.
Design and optimize injectable formulations by analyzing your active pharmaceutical ingredient (API), selecting compatible excipients, and predicting stability outcomes. You'll receive systematic workflows that guide you through API characterization, formulation architecture, and risk mitigation—enabling faster development cycles and regulatory-ready documentation.
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.
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.