mariadb-agents-query-optimizer
OfficialOptimize MariaDB queries with a 7-step deterministic procedure
Software Engineering#query optimization#MariaDB#EXPLAIN analysis#index recommendation#slow query fix
AuthorImpertio-Studio
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides a systematic approach to optimizing slow MariaDB queries, addressing common pitfalls like missing indexes, wrong index usage, and inefficient query structures.
Core Features & Use Cases
- Systematic Query Optimization: Follows a 7-step procedure to analyze and optimize queries.
- EXPLAIN Analysis: Utilizes EXPLAIN output to identify bottlenecks and suggest improvements.
- Index Recommendations: Assesses index recommendations for selectivity and duplication.
- Use Case: A user submits a slow query with EXPLAIN output. The Skill analyzes the query, identifies the bottleneck, and suggests an optimized index or query rewrite.
Quick Start
Use the mariadb-agents-query-optimizer skill to analyze and optimize a slow query. Provide the SQL query and its EXPLAIN output.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: mariadb-agents-query-optimizer Download link: https://github.com/Impertio-Studio/MariaDB-Claude-Skill-Package/archive/main.zip#mariadb-agents-query-optimizer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.