Can this skill suggest changes for production databases safely?

The skill follows a 'measure first' philosophy, advising on profiling existing baselines and documenting rollback steps before recommending any global configuration or index changes.

Does it support modern MySQL 8.0 features?

Yes, it specifically includes patterns for MySQL 8.0 features like EXPLAIN ANALYZE, EXPLAIN FORMAT=TREE, and functional indexing.

How does this skill help with slow MySQL queries?

It provides a systematic framework for Claude to analyze query execution plans, identifying missing indexes, inefficient join types, or full table scans that cause high latency.

Does it cover complex indexing like Fulltext or Geospatial?

Yes, it includes implementation patterns for B-tree, Fulltext, Spatial (GIS), and Hash indexes to suit various data types and search requirements.

MySQL Performance Tuning

Name: MySQL Performance Tuning
Author: jsamuelsen11

byjsamuelsen11

0•

Gestión de Bases de Datos

Analyzes and optimizes MySQL database performance through query execution plan inspection and strategic indexing.

This skill provides comprehensive guidance for diagnosing and resolving MySQL performance bottlenecks by enabling Claude to interpret complex execution plans and system metrics. It covers the systematic use of EXPLAIN and EXPLAIN ANALYZE to identify inefficient table scans, filesorts, and temporary tables, while providing actionable recommendations for B-tree, covering, and full-text indexing. Designed for both new deployments and existing production systems, the skill emphasizes a data-driven approach that prioritizes measurement and validation to ensure every optimization is justified by concrete performance gains.

Características Principales

01Identification of performance anti-patterns like high row examination counts and inefficient joins.

02Strategic index design recommendations including composite and covering index patterns.

03Deep analysis of EXPLAIN output (TREE and JSON formats) to pinpoint execution bottlenecks.

04Guidance on InnoDB internals and buffer pool configuration for resource optimization.

050 GitHub stars

06Real-time execution profiling using EXPLAIN ANALYZE for MySQL 8.0+.

Casos de Uso

01Designing optimal indexing strategies for new database schemas and features.

02Debugging and refactoring slow-running SQL queries in high-traffic applications.

03Auditing existing database configurations to improve throughput and reduce I/O overhead.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jsamuelsen11/claude-config performance-tuning

For use in Claude.ai and ChatGPT

Download Skill