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
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.